Excel O365 VBA
Imported Jsonconverter.bas, Imported Dictionary.cls
Reference add for MS Runtime scripting
Can see data in my .ResponseText, but as soon as the program calls "Set Json = JsonConverter.ParseJson(http.responseText)", I get the compile error.
My first go around with parsing JSON data... do I need to do anything with the Dictionary other than importing it? Is there ANY reference to it in the main sub() of my script? Code is below. Error Function is below that and http.responsetext is below that
Sure appreciate the help on the (i'm sure) very simple fix to my error. Learning a lot with this 1st time parsing project :=)
Sub getdata()
Dim inJson As Object
Dim ws As Worksheet: Set ws = Worksheets("Sheet1")
Dim http As Object
Set http = CreateObject("WinHttp.WinHttprequest.5.1")
Url = "https://www.printavo.com/api/v1/orders?email=info%40magsmonograms.com&token=UNlIykfMAuTEaghEtR0KGg" & "&query=1005"
http.Open "Get", Url, False
http.send
Set Json = JsonConverter.ParseJson(http.responseText)
Stop
.
.
.
End Sub
===.> error get thrown and highlights the first "Set" statement after the : (never gets to the Stop)
Public Function ParseJson(ByVal JsonString As String) As Object
Stop
Dim json_Index As Long
json_Index = 1
' Remove vbCr, vbLf, and vbTab from json_String
JsonString = VBA.Replace(VBA.Replace(VBA.Replace(JsonString, VBA.vbCr, ""), VBA.vbLf, ""), VBA.vbTab, "")
json_SkipSpaces JsonString, json_Index
Select Case VBA.Mid$(JsonString, json_Index, 1)
Case "{"
**_Set ParseJson = json_ParseObject(JsonString, json_Index)_**
Case "["
Set ParseJson = json_ParseArray(JsonString, json_Index)
Case Else
' Error: Invalid JSON string
Err.Raise 10001, "JSONConverter", json_ParseErrorMessage(JsonString, json_Index, "Expecting '{' or '['")
End Select
Left chest, both shirts: Sterigenics logo Brilliant Blue shirt: All White thread White shirt: Multi-color logoÂ
Thread sequence for multi-color logo:Â Dark Blue: 1167Â Light Blue: 1095 Green:Â 1049 BlackÂ
I'll pick up when completed. Thanks! TeresaÂ
","order_nickname":"P329028863A - Sterigenics","approved":false,"approved_name":null,"visual_id":20533,"stats":{"paid":false,"paid_date":"2021-03-15"},"notes":"","created_at":"2021-08-26T15:46:47.672-04:00","updated_at":"2021-08-26T15:48:33.028-04:00","due_date":"2021-08-26T15:45:00.000-04:00","order_total":9.0,"order_subtotal":9.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"P329028863A","customer":{"full_name":"Teresa Lehner","first_name":"Teresa","last_name":"Lehner","com
pany":"Proforma Graphic Services","email":"teresa.lehner@proforma.com, pgs.invoices@proforma.com, veronica.carter@proforma.com","customer_id":0},"order_addresses_attributes":[{"id":20802028,"name":"Customer Billing","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"Nicholas Dr Nicholas Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20802029,"name":"Customer Shipping","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"__Proforma Order Confirmation","color":"#B3A8A8"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28198896,"style_description":"Sterigentics","taxable":true,"style_number":"Logo","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":n
ull,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":4.5}],"order_fees_attributes":[],"id":7160836,"customer_due_date":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-09-10T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"09/10/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7160836","amount_paid":0.0,"amount_outstanding":9.0,"public_url":"https://www.printavo.com/invoice/eff853750c482def55a0c00a9a59f71e","pdf":"https://www.printavo.com/invoice/eff853750c482def55a0c00a9a59f71e.pdf","workorder":"https://www.printavo.com/invoices/7160836/workorder","packaging_slip":"https://www.printavo.com/invoices/7160836/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"di
scount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":209597,"public_hash":"d193ad7c6ede00c225690c2d87f30011","production_notes":"","order_nickname":"Patrick Lundy - Company Shirt","approved":false,"approved_name":null,"visual_id":20532,"stats":{"paid":false},"notes":"","created_at":"2021-08-26T09:26:34.774-04:00","updated_at":"2021-08-26T09:26:40.580-04:00","due_date":"2021-08-26T10:00:00.000-04:00","order_total":72.5,"order_subtotal":72.5,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20790457,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":207
90458,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Backordered","color":"#FF0011"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28174705,"style_description":"Company Shirt S/S","taxable":true,"style_number":"5-71391","color":"Navy","size_other":null,"size_xs":null,"size_s":null,"size_m":1,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":60.0},{"id":28174706,"style_description":"Clinton Crest","taxable":true,"style_number":"Logo","color":"LC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28174707,"style_description
":"LUNDY - White","taxable":true,"style_number":"Name","color":"RC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7155010,"customer_due_date":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-08-26T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"08/26/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7155010","amount_paid":0.0,"amount_outstanding":72.5,"public_url":"https://www.printavo.com/invoice/d193ad7c6ede00c225690c2d87f30011","pdf":"https://www.printavo.com/invoice/d193ad7c6ede00c225690c2d87f30011.pdf","workorder":"https://www.printavo.com/invoices/7155010/workorder","packaging_slip":"ht
tps://www.printavo.com/invoices/7155010/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4352599,"user_id":39097,"orderstatus_id":188579,"public_hash":"804ced98afdb8461290558b5cd5ad551","production_notes":"","order_nickname":"Hilliard Bag","approved":false,"approved_name":null,"visual_id":20531,"stats":{"paid":false},"notes":"","created_at":"2021-08-25T14:44:27.528-04:00","updated_at":"2021-08-26T10:19:16.438-04:00","due_date":"2021-08-25T10:00:00.000-04:00","order_total":12.5,"order_subtotal":12.5,"payment_term_id":1818,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Teresa Lehner","first_name":"Teresa","last_name":"Lehner","company":"Proforma Graphic Services","email":"teresa.lehner@proforma.com, pgs.invoices@proforma.com, veronica.carter@proforma.com","customer_id":0},"order_addresses_attributes":[{"id":20780779,"name":"Customer Billing","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","addres
s1":"Nicholas Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20780780,"name":"Customer Shipping","customer_name":"Teresa Lehner","company_name":"Proforma Graphic Services","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28153537,"style_description":"GIA\r\nHILLIARD\r\nWILDCATS","taxable":true,"style_number":"Name","color":"White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":12.5}],"order_fees_attributes":[],"id":7150129,"customer_due_date":"2021-08-25T00:00:00.000-04:00","custom_created_at":"2021-08-25T00:00:00.000-04:00","invoice_date":
"2021-08-25T00:00:00.000-04:00","payment_due_date":"2021-09-24T00:00:00.000-04:00","formatted_invoice_date":"08/25/2021","formatted_customer_due_date":"08/25/2021","formatted_payment_due_date":"09/24/2021","formatted_custom_created_at_date":"08/25/2021","url":"https://www.printavo.com/invoices/7150129","amount_paid":0.0,"amount_outstanding":12.5,"public_url":"https://www.printavo.com/invoice/804ced98afdb8461290558b5cd5ad551","pdf":"https://www.printavo.com/invoice/804ced98afdb8461290558b5cd5ad551.pdf","workorder":"https://www.printavo.com/invoices/7150129/workorder","packaging_slip":"https://www.printavo.com/invoices/7150129/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":185903,"public_hash":"409bb5bf7126cdf7d1e83fed9dce29cd","production_notes":"","order_nickname":"Tim Feldman Shirt and Hat","approved":false,"approved_name":null,"visual_id":20530,"stats":{"paid":false},"notes":"","created_at":"2021-08-24
T14:51:23.455-04:00","updated_at":"2021-08-26T09:15:22.853-04:00","due_date":"2021-08-24T10:00:00.000-04:00","order_total":77.8,"order_subtotal":77.8,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20761464,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20761465,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Ready for Production
","color":"#85F29B"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28111376,"style_description":"\t\r\n5.11 Performance Polo S/S","taxable":true,"style_number":"","color":"Navy","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":1,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":42.0},{"id":28111377,"style_description":"INSPECTOR\r\nFELDMAN\r\n","taxable":true,"style_number":"rc","color":"White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0},{"id":28111378,"style_description":"Clinton Crest","taxable":true,"style_number":"LC","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery Addon Metallic","unit_cost":7.5}
,{"id":28111379,"style_description":"Richardson - Richardson - Mesh Back Series 112 Trucker Cap","taxable":true,"style_number":"R112","color":"Navy","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":8.3},{"id":28111380,"style_description":"New Clinton Puffy","taxable":true,"style_number":"FC","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":10.0},{"id":28111381,"style_description":"FELDMAN","taxable":true,"style_number":"BC","color":"Name","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7140357,"customer_due_date":"2021-08-24T0
0:00:00.000-04:00","custom_created_at":"2021-08-24T00:00:00.000-04:00","invoice_date":"2021-08-24T00:00:00.000-04:00","payment_due_date":"2021-08-24T00:00:00.000-04:00","formatted_invoice_date":"08/24/2021","formatted_customer_due_date":"08/24/2021","formatted_payment_due_date":"08/24/2021","formatted_custom_created_at_date":"08/24/2021","url":"https://www.printavo.com/invoices/7140357","amount_paid":0.0,"amount_outstanding":77.8,"public_url":"https://www.printavo.com/invoice/409bb5bf7126cdf7d1e83fed9dce29cd","pdf":"https://www.printavo.com/invoice/409bb5bf7126cdf7d1e83fed9dce29cd.pdf","workorder":"https://www.printavo.com/invoices/7140357/workorder","packaging_slip":"https://www.printavo.com/invoices/7140357/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4344915,"user_id":39097,"orderstatus_id":188580,"public_hash":"583418e1274fedae49b9a6cc9f582b1d","production_notes":"","order_nickname":"Paws with Names","approved":false,"approved_name":null,
"visual_id":20529,"stats":{"paid":true,"paid_date":"2021-01-22"},"notes":"","created_at":"2021-08-23T15:29:38.423-04:00","updated_at":"2021-08-27T10:36:02.850-04:00","due_date":"2021-08-23T15:30:00.000-04:00","order_total":15.0,"order_subtotal":15.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Mary Davis","first_name":"Mary","last_name":"Davis","company":"Life Uniform - Reynoldsburg","email":"accountspayable@scrubsandbeyond.com, Store345@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20742015,"name":"Customer Billing","customer_name":"Mary Davis","company_name":"Life Uniform - Reynoldsburg","address1":"2841 Taylor Square","address2":"Taylor Square RDSW ","city":"Reynoldsburg","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43068"},{"id":20742016,"name":"Customer Shipping","customer_name":"Mary Davis","company_name":"Life Uniform - Reynoldsburg","address1":"","address2":"","city":"","state":"","state_iso":nu
ll,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28069972,"style_description":"Scrubs\r\nUse white thread","taxable":true,"style_number":"","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":0.0},{"id":28069973,"style_description":"White Thread - LC","taxable":true,"style_number":"Logo","color":"Paws","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5}],"order_fees_attributes":[],"id":7130553,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","p
ayment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7130553","amount_paid":15.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/583418e1274fedae49b9a6cc9f582b1d","pdf":"https://www.printavo.com/invoice/583418e1274fedae49b9a6cc9f582b1d.pdf","workorder":"https://www.printavo.com/invoices/7130553/workorder","packaging_slip":"https://www.printavo.com/invoices/7130553/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4890263,"user_id":39097,"orderstatus_id":188580,"public_hash":"ad854d711cdea29136a3a58b315cca78","production_notes":"","order_nickname":"Embroidery","approved":false,"approved_name":null,"visual_id":20528,"stats":{"paid":true,"paid_date":"2021-08-24"},"notes":"","created_at":"2021-08-23T14:52:29.338-04:00","upd
ated_at":"2021-08-24T13:52:38.866-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":172.0,"order_subtotal":160.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Karen Meidrum","first_name":"Karen","last_name":"Meidrum","company":"Wizard of Dogz","email":"wizardofdogz@msn.com","customer_id":0},"order_addresses_attributes":[{"id":20740808,"name":"Customer Billing","customer_name":"Karen Meidrum","company_name":"Wizard of Dogz","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20740809,"name":"Customer Shipping","customer_name":"Karen Meidrum","company_name":"Wizard of Dogz","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28066979,"style_description":"","taxable":
true,"style_number":"","color":"","size_other":16,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":10.0},{"id":28066980,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":null,"unit_cost":6.4}],"order_fees_attributes":[],"id":7129935,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-08-23T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"08/23/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7129935","amount_paid":172
.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/ad854d711cdea29136a3a58b315cca78","pdf":"https://www.printavo.com/invoice/ad854d711cdea29136a3a58b315cca78.pdf","workorder":"https://www.printavo.com/invoices/7129935/workorder","packaging_slip":"https://www.printavo.com/invoices/7129935/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4890021,"user_id":39097,"orderstatus_id":190428,"public_hash":"0d54e618832cf7cfb1dc0ce81290598d","production_notes":"","order_nickname":"Names on Placemats","approved":false,"approved_name":null,"visual_id":20527,"stats":{"paid":false},"notes":"","created_at":"2021-08-23T14:50:33.249-04:00","updated_at":"2021-08-23T14:50:38.843-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":26.875,"order_subtotal":25.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Mattie Phillips","first_name":"Mattie","last_name":"Phillips","company":"","ema
il":"grooms.6@hotmail.com","customer_id":0},"order_addresses_attributes":[{"id":20740742,"name":"Customer Billing","customer_name":"Mattie Phillips","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20740743,"name":"Customer Shipping","customer_name":"Mattie Phillips","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Create Design(s)","color":"#EB5768"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28066858,"style_description":"","taxable":true,"style_number":"","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":12.5},{"id":28066859,"style_description":"","taxable":false,"style_number":"","
color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.0}],"order_fees_attributes":[],"id":7129902,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-08-23T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"08/23/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7129902","amount_paid":0.0,"amount_outstanding":26.875,"public_url":"https://www.printavo.com/invoice/0d54e618832cf7cfb1dc0ce81290598d","pdf":"https://www.printavo.com/invoice/0d54e618832cf7cfb1dc0ce81290598d.pdf","workorder":"https://www.printavo.com/invoices/7129902/workorder","packaging_slip":"https://www.printavo.com/i
nvoices/7129902/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4360456,"user_id":39097,"orderstatus_id":188580,"public_hash":"1b75e254d1acc9a4862fe3fb2c172868","production_notes":"
Add actual quantity
","order_nickname":"COUG","approved":false,"approved_name":null,"visual_id":20526,"stats":{"paid":true,"paid_date":"2021-02-12"},"notes":"","created_at":"2021-08-23T10:00:44.806-04:00","updated_at":"2021-08-27T10:35:42.696-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":42.5,"order_subtotal":42.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Elaina","first_name":"Elaina","last_name":"","company":"Scrubs and Beyond","email":"accountspayable@scrubsandbeyond.com, manager361@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20730943,"name":"Customer Billing","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"12969 Manchester Road","
address2":"","city":"St Louis","state":"Missouri","state_iso":"MO","country":"US","country_iso":"US","zip":"63131"},{"id":20730944,"name":"Customer Shipping","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"3864 Morse Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43219"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28043503,"style_description":"Central Ohio Urology Group","taxable":true,"style_number":"Logo","color":"","size_other":4,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":4,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":6.5},{"id":28043538,"style_description":"","taxable":true,"style_number":"Name","color":"","size_other":3,"size_xs":null,"size_s":null,"size_m":null,"sizel":null,"size
xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":3,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":5.5}],"order_fees_attributes":[],"id":7124891,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7124891","amount_paid":42.5,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/1b75e254d1acc9a4862fe3fb2c172868","pdf":"https://www.printavo.com/invoice/1b75e254d1acc9a4862fe3fb2c172868.pdf","workorder":"https://www.printavo.com/invoices/7124891/workorder","packaging_slip":"https://www.printavo.com/invoices/7124891/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":fal
se,"discount":0.0,"customer_id":4360456,"user_id":39097,"orderstatus_id":188579,"public_hash":"6b53bf1daf7659da8b0f55f859dcc728","production_notes":"","order_nickname":"Grace Vision","approved":false,"approved_name":null,"visual_id":20525,"stats":{"paid":true,"paid_date":"2021-02-12"},"notes":"","created_at":"2021-08-23T10:00:05.303-04:00","updated_at":"2021-08-27T10:35:19.946-04:00","due_date":"2021-08-23T10:00:00.000-04:00","order_total":24.0,"order_subtotal":24.0,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Elaina","first_name":"Elaina","last_name":"","company":"Scrubs and Beyond","email":"accountspayable@scrubsandbeyond.com, manager361@scrubsandbeyond.com","customer_id":0},"order_addresses_attributes":[{"id":20730926,"name":"Customer Billing","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"12969 Manchester Road","address2":"","city":"St Louis","state":"Missouri","state_iso":"MO","country":"US","country_iso":"US","zip":"63131"},{"
id":20730927,"name":"Customer Shipping","customer_name":"Heather","company_name":"Scrubs and Beyond","address1":"3864 Morse Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43219"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28043471,"style_description":"Grace Vision","taxable":true,"style_number":"Logo","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":6.5},{"id":28043472,"style_description":"","taxable":true,"style_number":"Name","color":"","size_other":2,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","u
nit_cost":5.5}],"order_fees_attributes":[],"id":7124882,"customer_due_date":"2021-08-23T00:00:00.000-04:00","custom_created_at":"2021-08-23T00:00:00.000-04:00","invoice_date":"2021-08-23T00:00:00.000-04:00","payment_due_date":"2021-09-07T00:00:00.000-04:00","formatted_invoice_date":"08/23/2021","formatted_customer_due_date":"08/23/2021","formatted_payment_due_date":"09/07/2021","formatted_custom_created_at_date":"08/23/2021","url":"https://www.printavo.com/invoices/7124882","amount_paid":24.0,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/6b53bf1daf7659da8b0f55f859dcc728","pdf":"https://www.printavo.com/invoice/6b53bf1daf7659da8b0f55f859dcc728.pdf","workorder":"https://www.printavo.com/invoices/7124882/workorder","packaging_slip":"https://www.printavo.com/invoices/7124882/packing_slip"},{"sales_tax":6.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4289216,"user_id":39097,"orderstatus_id":186871,"public_hash":"737da50785eae6188660bac6623fe55d","produ
ction_notes":"","order_nickname":"test pos","approved":false,"approved_name":null,"visual_id":7,"stats":{"paid":false},"notes":"","created_at":"2021-08-22T15:54:51.061-04:00","updated_at":"2021-08-22T16:02:45.711-04:00","due_date":"2021-08-22T10:00:00.000-04:00","order_total":46.9665,"order_subtotal":44.1,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"Test 7","customer":{"full_name":"Freddy Flintstone","first_name":"Freddy","last_name":"Flintstone","company":"Test Customer","email":"cstocksd@stocksdale.net","customer_id":0},"order_addresses_attributes":[{"id":20727801,"name":"Customer Billing","customer_name":"Freddy Flintstone","company_name":"Test Customer","address1":"77 Bedrock Drive","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":"30245"},{"id":20727802,"name":"Customer Shipping","customer_name":"Freddy Flintstone","company_name":"Test Customer","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso
":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Quote Approved","color":"#F75E70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28036514,"style_description":"Richardson - On-Field Series 585 Wool Blend R-Flex Cap.\r\nS = XS-SM (6-5/8 â?? 7â?), M = SM-MD (7 â?? 7-1/4â?), L = LG-XL (7-3/8 â?? 7-5/8â?)","taxable":true,"style_number":"R585","color":"Black","size_other":null,"size_xs":null,"size_s":1,"size_m":2,"size_l":3,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":6,"goods_status":"ordered","category":" 3-Apparel","unit_cost":7.35}],"order_fees_attributes":[],"id":7123276,"customer_due_date":"2021-08-22T00:00:00.000-04:00","custom_created_at":"2021-08-22T00:00:00.000-04:00","invoice_date":"2021-08-22T00:00:00.000-04:00","payment_due_date":"2021-08-22T00:00:00.000-04:00","formatted_invoice_date":"08/22/2021","formatted_customer_due_date":"08/22/2021","formatted_payment_due_date":"08/22/2021","formatted_custom_created_at_date":"08/22/2021"
,"url":"https://www.printavo.com/invoices/7123276","amount_paid":0.0,"amount_outstanding":46.9665,"public_url":"https://www.printavo.com/invoice/737da50785eae6188660bac6623fe55d","pdf":"https://www.printavo.com/invoice/737da50785eae6188660bac6623fe55d.pdf","workorder":"https://www.printavo.com/invoices/7123276/workorder","packaging_slip":"https://www.printavo.com/invoices/7123276/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4888097,"user_id":39097,"orderstatus_id":185904,"public_hash":"1287e08686aaefb9c9243ec0aa0cfb74","production_notes":"","order_nickname":"New Logo and Embroidery","approved":false,"approved_name":null,"visual_id":20524,"stats":{"paid":false},"notes":"","created_at":"2021-08-20T17:14:22.331-04:00","updated_at":"2021-08-27T15:10:32.528-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":147.8125,"order_subtotal":137.5,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"B
en King","first_name":"Ben","last_name":"King","company":"Reaching The Future Faster","email":"ben.king@fasterfuture.org","customer_id":0},"order_addresses_attributes":[{"id":20722844,"name":"Customer Billing","customer_name":"Ben King","company_name":"Reaching The Future Faster","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20722845,"name":"Customer Shipping","customer_name":"Ben King","company_name":"Reaching The Future Faster","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[{"id":5485789,"transaction_date":"2021-08-25T01:00:00.000-04:00","name":"31077","amount":-20.0,"created_at":"2021-08-25T09:10:28.464-04:00","updated_at":"2021-08-25T09:10:28.464-04:00","user_generated":true}],"orderstatus":{"name":"In Production","color":"#54CC6E"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28025331,"style_description":"Reaching Th
e Future Faster","taxable":true,"style_number":"Logo","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery Setup Fee","unit_cost":70.0},{"id":28025332,"style_description":"Reaching The Future Faster","taxable":true,"style_number":"Logo","color":"Left Chest","size_other":9,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":9,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":7.5}],"order_fees_attributes":[],"id":7120810,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_createdat
date":"08/20/2021","url":"https://www.printavo.com/invoices/7120810","amount_paid":0.0,"amount_outstanding":147.8125,"public_url":"https://www.printavo.com/invoice/1287e08686aaefb9c9243ec0aa0cfb74","pdf":"https://www.printavo.com/invoice/1287e08686aaefb9c9243ec0aa0cfb74.pdf","workorder":"https://www.printavo.com/invoices/7120810/workorder","packaging_slip":"https://www.printavo.com/invoices/7120810/packing_slip"},{"sales_tax":7.5,"total_untaxed":25.08,"discount_as_percentage":false,"discount":0.0,"customer_id":4699113,"user_id":39097,"orderstatus_id":185904,"public_hash":"48acf82f94f2ecd45c3610940aaf6d46","production_notes":"","order_nickname":"Giuseppe's Polo's","approved":false,"approved_name":null,"visual_id":20523,"stats":{"paid":false,"paid_date":"2021-06-04"},"notes":"","created_at":"2021-08-20T17:05:05.995-04:00","updated_at":"2021-08-27T12:04:42.410-04:00","due_date":"2021-08-20T17:00:00.000-04:00","order_total":699.32,"order_subtotal":652.28,"payment_term_id":null,"delivery_method_id":null,"visual_p
o_number":"","customer":{"full_name":"Christopher Leadbeater","first_name":"Christopher","last_name":"Leadbeater","company":"Amerikleen","email":"magnummx111@yahoo.com","customer_id":0},"order_addresses_attributes":[{"id":20722662,"name":"Customer Billing","customer_name":"Christopher Leadbeater","company_name":"Amerikleen","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20722663,"name":"Customer Shipping","customer_name":"Christopher Leadbeater","company_name":"Amerikleen","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"In Production","color":"#54CC6E"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28024929,"style_description":"Sport-Tek - PosiCharge RacerMesh Polo","taxable":true,"style_number":"ST640","color":"Graphite","size_other":null,"size_xs":null,"size_s":null,"size_m":4,"size_l":6,"size_xl":
6,"size_2xl":4,"size_3xl":null,"total_quantities":20,"goods_status":"","category":" 3-Apparel","unit_cost":12.98},{"id":28024931,"style_description":"Giuseppe's ","taxable":true,"style_number":"Logo","color":"LC","size_other":40,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":40,"goods_status":"","category":" 1-Embroidery","unit_cost":6.0},{"id":28024932,"style_description":"","taxable":false,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":25.08},{"id":28024930,"style_description":"Port Authority - Uniforming Twill Cap","taxable":true,"style_number":"C913","color":"Steel Grey","size_other":20,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":20,"goods_status":
"","category":" 3-Apparel","unit_cost":6.38}],"order_fees_attributes":[],"id":7120718,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7120718","amount_paid":0.0,"amount_outstanding":699.32,"public_url":"https://www.printavo.com/invoice/48acf82f94f2ecd45c3610940aaf6d46","pdf":"https://www.printavo.com/invoice/48acf82f94f2ecd45c3610940aaf6d46.pdf","workorder":"https://www.printavo.com/invoices/7120718/workorder","packaging_slip":"https://www.printavo.com/invoices/7120718/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.6,"discount_as_percentage":false,"discount":0.0,"customer_id":4472895,"user_id":39097,"orderstatus_id":188580,"public_hash":"0ed193c0
dcbf7a5f1918dad78e616563","production_notes":"
","order_nickname":"Grandview Primary Care shirts","approved":false,"approved_name":null,"visual_id":20522,"stats":{"paid":true,"paid_date":"2021-03-01"},"notes":"","created_at":"2021-08-20T13:40:36.880-04:00","updated_at":"2021-08-25T12:24:40.712-04:00","due_date":"2021-08-20T13:45:00.000-04:00","order_total":16.725,"order_subtotal":15.6,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brett Stefan","first_name":"Brett","last_name":"Stefan","company":"","email":"drbrett@farabaughchiropractic.com","customer_id":0},"order_addresses_attributes":[{"id":20717088,"name":"Customer Billing","customer_name":"Brett Stefan","company_name":"","address1":"2879 East Dublin Granville Road","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43231"},{"id":20717089,"name":"Customer Shipping","customer_name":"Brett Stefan","company_name":"","address1":"","add
ress2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28012475,"style_description":"Farabaugh \r\nChiropractic\r\nDr. Brett C. Stefan\r\n- White\r\n","taxable":true,"style_number":"Logo","color":"Right Chest","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28012476,"style_description":"Farabaugh \r\nChiropractic","taxable":true,"style_number":"Logo","color":"Front Center","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28012477,"style_description":"","taxable":false,"style_number":"","color":"","
size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":0.6}],"order_fees_attributes":[],"id":7117911,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7117911","amount_paid":16.73,"amount_outstanding":-0.004999999999999005,"public_url":"https://www.printavo.com/invoice/0ed193c0dcbf7a5f1918dad78e616563","pdf":"https://www.printavo.com/invoice/0ed193c0dcbf7a5f1918dad78e616563.pdf","workorder":"https://www.printavo.com/invoices/7117911/workorder","packaging_slip":"https://www.printavo.co
m/invoices/7117911/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4330402,"user_id":39097,"orderstatus_id":188579,"public_hash":"a9eaea38090cabc2082ba0f9eb7a9c8f","production_notes":"","order_nickname":"Bryan Childs Hat","approved":false,"approved_name":null,"visual_id":20521,"stats":{"paid":true,"paid_date":"2021-08-26"},"notes":"","created_at":"2021-08-20T11:17:32.473-04:00","updated_at":"2021-08-26T15:45:45.992-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":24.08,"order_subtotal":24.08,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Brian Fraley","first_name":"Brian","last_name":"Fraley","company":"Clinton Township Fire Department","email":"bfraley@clintontwp-columbus.org","customer_id":0},"order_addresses_attributes":[{"id":20713196,"name":"Customer Billing","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","add
ress2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20713197,"name":"Customer Shipping","customer_name":"Brian Fraley","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28004085,"style_description":"New Era - Stretch Mesh Cap","taxable":true,"style_number":"NE1020","color":"Deep Navy","size_other":null,"size_xs":null,"size_s":1,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":11.58},{"id":28004086,"style_description":"ENG 61 INE","taxable":true,"style_number":"Logo","color":"FC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"
size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5},{"id":28004087,"style_description":"LT. CHILDS (Red)","taxable":true,"style_number":"Name","color":"BC","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":5.0}],"order_fees_attributes":[],"id":7115941,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7115941","amount_paid":24.08,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/a9eaea38090cabc2082ba0f9eb7a9c8f","pdf":"https://www.printavo.c
om/invoice/a9eaea38090cabc2082ba0f9eb7a9c8f.pdf","workorder":"https://www.printavo.com/invoices/7115941/workorder","packaging_slip":"https://www.printavo.com/invoices/7115941/packing_slip"},{"sales_tax":0.0,"total_untaxed":2.77,"discount_as_percentage":false,"discount":0.0,"customer_id":4467961,"user_id":39097,"orderstatus_id":188580,"public_hash":"6197fc797daeae16098120315f90ec49","production_notes":"","order_nickname":"NE Hats","approved":false,"approved_name":null,"visual_id":20520,"stats":{"paid":true,"paid_date":"2021-08-20"},"notes":"","created_at":"2021-08-20T11:13:41.594-04:00","updated_at":"2021-08-20T12:01:28.937-04:00","due_date":"2021-08-20T10:00:00.000-04:00","order_total":72.25,"order_subtotal":72.25,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Bryan Childs","first_name":"Bryan","last_name":"Childs","company":"Clinton Township Fire Department","email":"bchilds61@gmail.com","customer_id":4330402},"order_addresses_attributes":[{"id":20713098,"nam
e":"Customer Billing","customer_name":"Bryan Childs","company_name":"Clinton Township Fire Department","address1":"3820 Cleveland Avenue","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43224"},{"id":20713099,"name":"Customer Shipping","customer_name":"Bryan Childs","company_name":"Clinton Township Fire Department","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":28003847,"style_description":"New Era - Stretch Mesh Cap","taxable":true,"style_number":"NE1020","color":"Black/Gold","size_other":null,"size_xs":null,"size_s":4,"size_m":null,"size_l":2,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":6,"goods_status":"","category":" 3-Apparel","unit_cost":11.58},{"id":28003848,"style_description":"","taxable":false,"styl
e_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":2.77}],"order_fees_attributes":[],"id":7115888,"customer_due_date":"2021-08-20T00:00:00.000-04:00","custom_created_at":"2021-08-20T00:00:00.000-04:00","invoice_date":"2021-08-20T00:00:00.000-04:00","payment_due_date":"2021-08-20T00:00:00.000-04:00","formatted_invoice_date":"08/20/2021","formatted_customer_due_date":"08/20/2021","formatted_payment_due_date":"08/20/2021","formatted_custom_created_at_date":"08/20/2021","url":"https://www.printavo.com/invoices/7115888","amount_paid":72.25,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/6197fc797daeae16098120315f90ec49","pdf":"https://www.printavo.com/invoice/6197fc797daeae16098120315f90ec49.pdf","workorder":"https://www.printavo.com/invoices/7115888/workorder","packaging_slip":"https://www.pri
ntavo.com/invoices/7115888/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4331808,"user_id":39097,"orderstatus_id":188580,"public_hash":"36215ee644eec7b3857b16504f17f0e5","production_notes":"","order_nickname":"Captains Mugs","approved":false,"approved_name":null,"visual_id":20519,"stats":{"paid":true,"paid_date":"2021-03-18"},"notes":"
","created_at":"2021-08-19T16:36:44.034-04:00","updated_at":"2021-08-24T13:54:12.931-04:00","due_date":"2021-08-19T16:30:00.000-04:00","order_total":30.79875,"order_subtotal":28.65,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"10107","customer":{"full_name":"Luba Istocki","first_name":"Luba","last_name":"Istocki","company":"Auld Crafters","email":"luba@auldcraft.com","customer_id":0},"order_addresses_attributes":[{"id":20705116,"name":"Customer Billing","customer_name":"Luba Istocki","company_name":"Auld Crafters","address1":"","address2":"","city":"","state":"","stat
e_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20705117,"name":"Customer Shipping","customer_name":"Luba Istocki","company_name":"Auld Crafters","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27987215,"style_description":"Captain\r\nName\r\nYear","taxable":true,"style_number":"","color":"","size_other":5,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":5,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":5.5},{"id":27987283,"style_description":"","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":"0-Convenie
nce fee if paying by credit card","unit_cost":1.15}],"order_fees_attributes":[],"id":7111879,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7111879","amount_paid":30.8,"amount_outstanding":-0.001250000000002416,"public_url":"https://www.printavo.com/invoice/36215ee644eec7b3857b16504f17f0e5","pdf":"https://www.printavo.com/invoice/36215ee644eec7b3857b16504f17f0e5.pdf","workorder":"https://www.printavo.com/invoices/7111879/workorder","packaging_slip":"https://www.printavo.com/invoices/7111879/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4431525,"user_id":39097,"orderstatus_id":188579,
"public_hash":"683549bd86c6bfd24c8aa7a7aa7f5027","production_notes":"","order_nickname":"Nate's Shirts/Goalie Shirts/Pink Pennies","approved":false,"approved_name":null,"visual_id":20518,"stats":{"paid":false},"notes":"","created_at":"2021-08-19T15:54:51.985-04:00","updated_at":"2021-08-23T12:04:37.312-04:00","due_date":"2021-08-19T16:00:00.000-04:00","order_total":181.675,"order_subtotal":169.0,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Tim Martini","first_name":"Tim","last_name":"Martini","company":"Alder FC Uniform Account","email":"timmy.martini@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20703717,"name":"Customer Billing","customer_name":"Tim Martini","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":""},{"id":20703718,"name":"Customer Shipping","customer_name":"Tim Martini","company_name":"Alder FC Uniform Account","address1":"","
address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27984193,"style_description":"Sport-Tek - Heather Contender Tee","taxable":true,"style_number":"ST360","color":"Vintage Heather","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":2,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27984194,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"YST350LS","color":"Neon Pink","size_other":null,"size_xs":null,"size_s":null,"size_m":1,"size_l":1,"size_xl":1,"size_2xl":null,"size_3xl":null,"total_quantities":3,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27984198,"style_description":"Shields on Pink Pennies","taxable":true,"style_number"
:"","color":"","size_other":10,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":10,"goods_status":"","category":" 2-Transfer Services","unit_cost":5.0},{"id":27984597,"style_description":"Sport-Tek - Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"ST350LS","color":"Neon Pink","size_other":null,"size_xs":null,"size_s":1,"size_m":1,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":2,"goods_status":"","category":" 3-Apparel","unit_cost":17.0}],"order_fees_attributes":[],"id":7111180,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoic
es/7111180","amount_paid":0.0,"amount_outstanding":181.675,"public_url":"https://www.printavo.com/invoice/683549bd86c6bfd24c8aa7a7aa7f5027","pdf":"https://www.printavo.com/invoice/683549bd86c6bfd24c8aa7a7aa7f5027.pdf","workorder":"https://www.printavo.com/invoices/7111180/workorder","packaging_slip":"https://www.printavo.com/invoices/7111180/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4534205,"user_id":39097,"orderstatus_id":188580,"public_hash":"d1a737dd4c904f11260f47de919af1ad","production_notes":"","order_nickname":"Ben's Bag","approved":false,"approved_name":null,"visual_id":20517,"stats":{"paid":true,"paid_date":"2021-08-19"},"notes":"
Thanks Connie!
I forgot to sent this over to you!
Best of luck this season!!!
","created_at":"2021-08-19T15:38:36.221-04:00","updated_at":"2021-08-22T18:36:05.852-04:00","due_date":"2021-08-19T15:45:00.000-04:00","order_total":40.3125,"order_subtotal":37.5,"payment_term_id":1780,"de
livery_method_id":null,"visual_po_number":"","customer":{"full_name":"Ben Buckley #21 U13","first_name":"Ben","last_name":"Buckley #21 U13","company":"Alder FC Uniform Account","email":"constance.buckley@gmail.com","customer_id":4431525},"order_addresses_attributes":[{"id":20703197,"name":"Customer Billing","customer_name":"Ben Buckley #21 U13","company_name":"Alder FC Uniform Account","address1":"1011 weather vane way","address2":"","city":"plain city","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43064"},{"id":20703198,"name":"Customer Shipping","customer_name":"Ben Buckley #21 U13","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27983079,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":tru
e,"style_number":"YST350","color":"White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27983080,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"True Red","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27983081,"style_description":"Sport-Tek - Youth Heather Contender Tee","taxable":true,"style_number":"YST360","color":"Vintage Heather","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27983082,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee
","taxable":true,"style_number":"YST350LS","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27983083,"style_description":"WICKING SOCCER SHORTS WITH PIPING","taxable":true,"style_number":"460461","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":13.5},{"id":27983084,"style_description":"High 5 Heavy Duty Backpack","taxable":true,"style_number":"327850","color":"Red / Black","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":37.5},{"id":27983085,"style_description":"Preformance Socks","taxable":true,"style_number":"329110","color":"Blac
k / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":9.0},{"id":27983086,"style_description":"YOUTH MEDALIST JACKET 2.0","taxable":true,"style_number":"4396","color":"Red / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.0},{"id":27983207,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.5}],"order_fees_attributes":[],"id":7110921,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08
-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110921","amount_paid":40.31,"amount_outstanding":0.002499999999997726,"public_url":"https://www.printavo.com/invoice/d1a737dd4c904f11260f47de919af1ad","pdf":"https://www.printavo.com/invoice/d1a737dd4c904f11260f47de919af1ad.pdf","workorder":"https://www.printavo.com/invoices/7110921/workorder","packaging_slip":"https://www.printavo.com/invoices/7110921/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4885896,"user_id":39097,"orderstatus_id":188579,"public_hash":"af313a196ac826d4402108678e00e8e3","production_notes":"","order_nickname":"Ian Extras","approved":false,"approved_name":null,"visual_id":20516,"stats":{"paid":true,"paid_date":"2021-08-21"},"notes":"","crea
ted_at":"2021-08-19T15:34:31.514-04:00","updated_at":"2021-08-23T10:02:05.464-04:00","due_date":"2021-08-19T15:30:00.000-04:00","order_total":42.4625,"order_subtotal":39.5,"payment_term_id":1780,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Ian Yoder","first_name":"Ian","last_name":"Yoder","company":"Alder FC Uniform Account","email":"deca8500@gmail.com","customer_id":4431525},"order_addresses_attributes":[{"id":20703083,"name":"Customer Billing","customer_name":"Ian Yoder","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":"OH","country":"US","country_iso":"US","zip":""},{"id":20703084,"name":"Customer Shipping","customer_name":"Ian Yoder","company_name":"Alder FC Uniform Account","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Final Payment","color":"#D413ED"},"user":{"name":"Mags Monograms"},"lineitems_a
ttributes":[{"id":27982856,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27982857,"style_description":"Sport-Tek - Youth PosiCharge Competitor Tee","taxable":true,"style_number":"YST350","color":"True Red","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":16.0},{"id":27982858,"style_description":"Sport-Tek - Youth Heather Contender Tee","taxable":true,"style_number":"YST360","color":"Vintage Heather","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goodsstatus":"","category":" 3-Apparel","unit
cost":17.0},{"id":27982859,"style_description":"Sport-Tek - Youth Long Sleeve PosiCharge Competitor Tee","taxable":true,"style_number":"YST350LS","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":17.0},{"id":27982860,"style_description":"WICKING SOCCER SHORTS WITH PIPING","taxable":true,"style_number":"460461","color":"Black","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":13.5},{"id":27982861,"style_description":"High 5 Heavy Duty Backpack","taxable":true,"style_number":"327850","color":"Red / Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.5},{"id
":27982862,"style_description":"Preformance Socks","taxable":true,"style_number":"329110","color":"Black / White","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 3-Apparel","unit_cost":9.0},{"id":27982863,"style_description":"YOUTH MEDALIST JACKET 2.0","taxable":true,"style_number":"4396","color":"Red / White","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":" 3-Apparel","unit_cost":37.0},{"id":27982942,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":1.58}],"order_fees_attributes":[],"id":7110864,"customer_due_date":"2021-
08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110864","amount_paid":42.46,"amount_outstanding":0.002499999999997726,"public_url":"https://www.printavo.com/invoice/af313a196ac826d4402108678e00e8e3","pdf":"https://www.printavo.com/invoice/af313a196ac826d4402108678e00e8e3.pdf","workorder":"https://www.printavo.com/invoices/7110864/workorder","packaging_slip":"https://www.printavo.com/invoices/7110864/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4453693,"user_id":39097,"orderstatus_id":188580,"public_hash":"d5727f9a50eebad110afb4c638e1d332","production_notes":"","order_nickname":"Name on warm up pants","approv
ed":false,"approved_name":null,"visual_id":20515,"stats":{"paid":true,"paid_date":"2021-07-06"},"notes":"","created_at":"2021-08-19T14:45:50.390-04:00","updated_at":"2021-08-27T18:04:22.397-04:00","due_date":"2021-08-19T14:45:00.000-04:00","order_total":4.5,"order_subtotal":4.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Norma Egelhoff","first_name":"Norma","last_name":"Egelhoff","company":"Egelhoff Sports Inc","email":"egelhoffsports@sbcglobal.net","customer_id":0},"order_addresses_attributes":[{"id":20701535,"name":"Customer Billing","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20701536,"name":"Customer Shipping","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country
":"US","country_iso":"US","zip":"43235"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979688,"style_description":"Hershey","taxable":true,"style_number":"Pants","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":4.5}],"order_fees_attributes":[],"id":7110086,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-09-03T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"09/03/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110086","amount_paid":4.5,"amount_outstanding"
:0.0,"public_url":"https://www.printavo.com/invoice/d5727f9a50eebad110afb4c638e1d332","pdf":"https://www.printavo.com/invoice/d5727f9a50eebad110afb4c638e1d332.pdf","workorder":"https://www.printavo.com/invoices/7110086/workorder","packaging_slip":"https://www.printavo.com/invoices/7110086/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4453693,"user_id":39097,"orderstatus_id":188580,"public_hash":"375001d4880973f92cccf905a4ee1dfa","production_notes":"","order_nickname":"K Cheer Headband","approved":false,"approved_name":null,"visual_id":20514,"stats":{"paid":true,"paid_date":"2021-05-27"},"notes":"","created_at":"2021-08-19T14:45:47.289-04:00","updated_at":"2021-08-27T18:04:47.560-04:00","due_date":"2021-08-19T14:45:00.000-04:00","order_total":3.5,"order_subtotal":3.5,"payment_term_id":1817,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Norma Egelhoff","first_name":"Norma","last_name":"Egelhoff","company":"Egelhoff Spor
ts Inc","email":"egelhoffsports@sbcglobal.net","customer_id":0},"order_addresses_attributes":[{"id":20701531,"name":"Customer Billing","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"},{"id":20701532,"name":"Customer Shipping","customer_name":"Norma Egelhoff","company_name":"Egelhoff Sports Inc","address1":"50 Dillmont Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43235"}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Thank You Note","color":"#EB7B70"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979683,"style_description":"K\r\nCheer\r\n(Royal with white outline - Cheer is also white)","taxable":true,"style_number":"Logo","color":"Left Chest","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null
,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":3.5}],"order_fees_attributes":[],"id":7110084,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-09-03T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"09/03/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110084","amount_paid":3.5,"amount_outstanding":0.0,"public_url":"https://www.printavo.com/invoice/375001d4880973f92cccf905a4ee1dfa","pdf":"https://www.printavo.com/invoice/375001d4880973f92cccf905a4ee1dfa.pdf","workorder":"https://www.printavo.com/invoices/7110084/workorder","packaging_slip":"https://www.printavo.com/invoices/7110084/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"custom
er_id":4389442,"user_id":39097,"orderstatus_id":185903,"public_hash":"058fffedc10e97dd8e3f18190021fa3c","production_notes":"","order_nickname":"White's Funeral & Cremation Services","approved":false,"approved_name":null,"visual_id":20513,"stats":{"paid":false},"notes":"","created_at":"2021-08-19T14:45:24.383-04:00","updated_at":"2021-08-19T14:45:31.365-04:00","due_date":"2021-08-19T10:00:00.000-04:00","order_total":241.875,"order_subtotal":225.0,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Roy Buckley","first_name":"Roy","last_name":"Buckley","company":"Buckley Trophies and Embroidery","email":"noemail@nomail.com","customer_id":0},"order_addresses_attributes":[{"id":20701517,"name":"Customer Billing","customer_name":"Roy Buckley","company_name":"Buckley Trophies and Embroidery","address1":"1365 Community Park Drive","address2":"","city":"Columbus","state":"Ohio","state_iso":"OH","country":"US","country_iso":"US","zip":"43229"},{"id":20701518,"name":"Customer
Shipping","customer_name":"Roy Buckley","company_name":"Buckley Trophies and Embroidery","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Ready for Production","color":"#85F29B"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27979650,"style_description":"White's Funeral & Cremation Services","taxable":true,"style_number":"Logo","color":"","size_other":30,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":30,"goods_status":"","category":" 1-Embroidery on Customer Supplied Item","unit_cost":7.5}],"order_fees_attributes":[],"id":7110077,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date
":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7110077","amount_paid":0.0,"amount_outstanding":241.875,"public_url":"https://www.printavo.com/invoice/058fffedc10e97dd8e3f18190021fa3c","pdf":"https://www.printavo.com/invoice/058fffedc10e97dd8e3f18190021fa3c.pdf","workorder":"https://www.printavo.com/invoices/7110077/workorder","packaging_slip":"https://www.printavo.com/invoices/7110077/packing_slip"},{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4768252,"user_id":39097,"orderstatus_id":185898,"public_hash":"bf8d6e7fffb19f003279c3f53cbe1f35","production_notes":"","order_nickname":"Sweatshirts","approved":false,"approved_name":null,"visual_id":20512,"stats":{"paid":false},"notes":"
Sport-Tek - Super Heavyweight Pullover Hooded Sweatshirt is our most popular heavyweight sweatshirt. It is 12-ounce, cross-grain 80/20 ring spun combed cotton/poly fleece.
Another option is Gildan - Heavy Blend Crewneck Sweatshirt. it is only 8-ounce, and 50/50 cotton/poly blend.
Let me know which one you would prefer!
As far as the polos, we can purchase Nike and other similar brands but there is currently a huge inventory shortage on black polos. Sounds strange, but it's true :(Â
","created_at":"2021-08-19T13:21:01.309-04:00","updated_at":"2021-08-19T13:21:07.859-04:00","due_date":"2021-08-19T10:00:00.000-04:00","order_total":1156.184,"order_subtotal":1075.52,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"Shae White","first_name":"Shae","last_name":"White","company":"","email":"supremeshaee@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20698972,"name":"Customer Billing","customer_name":"Shae White","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""},{"id":20698973,"name":"Customer Shipping","cust
omer_name":"Shae White","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"**Quote Out for Approval","color":"#3B86B8"},"user":{"name":"Mags Monograms"},"lineitems_attributes":[{"id":27973655,"style_description":"Sport-Tek - Super Heavyweight Pullover Hooded Sweatshirt","taxable":true,"style_number":"F281","color":"Black","size_other":null,"size_xs":2,"size_s":2,"size_m":2,"size_l":4,"size_xl":4,"size_2xl":2,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 3-Apparel","unit_cost":43.98},{"id":27973656,"style_description":"Gildan - Heavy Blend Crewneck Sweatshirt","taxable":true,"style_number":"18000","color":"Black","size_other":null,"size_xs":2,"size_s":2,"size_m":2,"size_l":4,"size_xl":4,"size_2xl":2,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 3-Apparel","unit_cost":15.74},{"id":27973657,"style_description":"Bulldog","taxabl
e":true,"style_number":"Logo","color":"","size_other":16,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":16,"goods_status":"","category":" 1-Embroidery","unit_cost":7.5}],"order_fees_attributes":[],"id":7108794,"customer_due_date":"2021-08-19T00:00:00.000-04:00","custom_created_at":"2021-08-19T00:00:00.000-04:00","invoice_date":"2021-08-19T00:00:00.000-04:00","payment_due_date":"2021-08-19T00:00:00.000-04:00","formatted_invoice_date":"08/19/2021","formatted_customer_due_date":"08/19/2021","formatted_payment_due_date":"08/19/2021","formatted_custom_created_at_date":"08/19/2021","url":"https://www.printavo.com/invoices/7108794","amount_paid":0.0,"amount_outstanding":1156.184,"public_url":"https://www.printavo.com/invoice/bf8d6e7fffb19f003279c3f53cbe1f35","pdf":"https://www.printavo.com/invoice/bf8d6e7fffb19f003279c3f53cbe1f35.pdf","workorder":"https://www.printavo.com/invoices/7108794/workorder","packaging_slip":"https://www.printavo.co
m/invoices/7108794/packing_slip"}]}
Excel O365 VBA Imported Jsonconverter.bas, Imported Dictionary.cls Reference add for MS Runtime scripting
Can see data in my .ResponseText, but as soon as the program calls "Set Json = JsonConverter.ParseJson(http.responseText)", I get the compile error.
My first go around with parsing JSON data... do I need to do anything with the Dictionary other than importing it? Is there ANY reference to it in the main sub() of my script? Code is below. Error Function is below that and http.responsetext is below that
Sure appreciate the help on the (i'm sure) very simple fix to my error. Learning a lot with this 1st time parsing project :=)
Sub getdata() Dim inJson As Object Dim ws As Worksheet: Set ws = Worksheets("Sheet1") Dim http As Object Set http = CreateObject("WinHttp.WinHttprequest.5.1") Url = "https://www.printavo.com/api/v1/orders?email=info%40magsmonograms.com&token=UNlIykfMAuTEaghEtR0KGg" & "&query=1005" http.Open "Get", Url, False http.send Set Json = JsonConverter.ParseJson(http.responseText) Stop . . . End Sub
===.> error get thrown and highlights the first "Set" statement after the : (never gets to the Stop)
Public Function ParseJson(ByVal JsonString As String) As Object Stop Dim json_Index As Long json_Index = 1
End Function
/\/\/\/\/\ -- FYI http.response.text = ? http.responsetext {"meta":{"page":1,"per_page":25,"total_count":531,"total_pages":22},"data":[{"sales_tax":7.5,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4902516,"user_id":37796,"orderstatus_id":185896,"public_hash":"a995e8b4d28ae3a530f53b0a62430e69","production_notes":"","order_nickname":"Augusta Shirts","approved":false,"approved_name":null,"visual_id":20535,"stats":{"paid":false},"notes":"","created_at":"2021-08-26T16:19:16.309-04:00","updated_at":"2021-08-29T15:09:56.930-04:00","due_date":"2021-08-26T10:00:00.000-04:00","order_total":71.0575,"order_subtotal":66.1,"payment_term_id":null,"delivery_method_id":null,"visual_po_number":"","customer":{"full_name":"James Wilson","first_name":"James","last_name":"Wilson","company":"","email":"jxwilson1011@gmail.com","customer_id":0},"order_addresses_attributes":[{"id":20803016,"name":"Customer Billing","customer_name":"James Wilson","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso": "US","zip":""},{"id":20803017,"name":"Customer Shipping","customer_name":"James Wilson","company_name":"","address1":"","address2":"","city":"","state":"","state_iso":null,"country":"US","country_iso":"US","zip":""}],"contractor_profile":null,"expenses":[],"orderstatus":{"name":"Quote","color":"#47A0D9"},"user":{"name":"Chic"},"lineitems_attributes":[{"id":28200912,"style_description":"Augusta Sportswear - Adult Attain Wicking Short-Sleeve T-Shirt","taxable":true,"style_number":"2790","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":3,"total_quantities":3,"goods_status":"","category":" 3-Apparel","unit_cost":15.66},{"id":28200913,"style_description":"Augusta Sportswear - Attain Color Secure® Performance Long Sleeve T-Shirt","taxable":true,"style_number":"2795","color":"Black","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":1,"total_quantities":1,"goods_stat us":"","category":" 3-Apparel","unit_cost":19.1},{"id":28200914,"style_description":"Sherriff","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 2-Transfer Services","unit_cost":0.01},{"id":28200915,"style_description":"Franklin Badge","taxable":true,"style_number":"","color":"","size_other":1,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":1,"goods_status":"","category":" 1-Embroidery","unit_cost":0.01},{"id":28200916,"style_description":"","taxable":false,"style_number":"","color":"","size_other":null,"size_xs":null,"size_s":null,"size_m":null,"size_l":null,"size_xl":null,"size_2xl":null,"size_3xl":null,"total_quantities":0,"goods_status":"","category":"0-Convenience fee if paying by credit card","unit_cost":0.01}],"order_fees_attributes":[],"id":7161334,"customer_due_d ate":"2021-08-26T00:00:00.000-04:00","custom_created_at":"2021-08-26T00:00:00.000-04:00","invoice_date":"2021-08-26T00:00:00.000-04:00","payment_due_date":"2021-08-26T00:00:00.000-04:00","formatted_invoice_date":"08/26/2021","formatted_customer_due_date":"08/26/2021","formatted_payment_due_date":"08/26/2021","formatted_custom_created_at_date":"08/26/2021","url":"https://www.printavo.com/invoices/7161334","amount_paid":0.0,"amount_outstanding":71.0575,"public_url":"https://www.printavo.com/invoice/a995e8b4d28ae3a530f53b0a62430e69","pdf":"https://www.printavo.com/invoice/a995e8b4d28ae3a530f53b0a62430e69.pdf","workorder":"https://www.printavo.com/invoices/7161334/workorder","packaging_slip":"https://www.printavo.com/invoices/7161334/packing_slip"},{"sales_tax":0.0,"total_untaxed":0.0,"discount_as_percentage":false,"discount":0.0,"customer_id":4352599,"user_id":39097,"orderstatus_id":196994,"public_hash":"0cc5f3192dc20c2c59b0c46d75d88ea4","production_notes":"
Garments coming from Sanmar on PO P329029476B:Â
TLJ763 Cornerstone Duck Cloth Work Jacket:Â
Navy: XLT-1, 2XLT-1Â
Garment coming from TriMountain on PO P329029476A:Â
6000 Lightweight jacketÂ
Navy: 2XLT-1Â
Left chest, all garments: SDG Security logoÂ
Thread colors:Â
Red 1147, WhiteÂ
Please let me know if you have any questions regarding the logo.Â
I'll pick up when completed.Â
Thanks! TeresaÂ
Shirts coming from Sanmar on PO P329028863A:Â
L5200 Ladies Interlock Performance polo:Â
Brilliant Blue: S-1Â
White: S-1Â
Left chest, both shirts: Sterigenics logoÂ
Brilliant Blue shirt: All White threadÂ
White shirt: Multi-color logoÂ
Thread sequence for multi-color logo:Â
Dark Blue: 1167Â
Light Blue: 1095 Green:Â
1049 BlackÂ
I'll pick up when completed.Â
Thanks! TeresaÂ
I forgot to sent this over to you!
Best of luck this season!!!
Another option is Gildan - Heavy Blend Crewneck Sweatshirt. it is only 8-ounce, and 50/50 cotton/poly blend.
Let me know which one you would prefer!
As far as the polos, we can purchase Nike and other similar brands but there is currently a huge inventory shortage on black polos. Sounds strange, but it's true :(Â