so: 1709
This data as json
| id | billToAddress | billToCity | billToCountryId | billToName | billToStateId | billToZip | calCategoryId | carrierId | carrierServiceId | cost | createdByUserId | currencyId | currencyRate | customerContact | customerId | customerPO | dateCalStart | dateCalEnd | dateCompleted | dateCreated | dateExpired | dateFirstShip | dateIssued | dateLastModified | dateRevision | estimatedTax | fobPointId | locationGroupId | mcTotalTax | note | num | paymentTermsId | phone | priorityId | qbClassId | registerId | shipToResidential | revisionNum | salesman | salesmanId | salesmanInitials | shipTermsId | shipToAddress | shipToCity | shipToCountryId | shipToName | shipToStateId | shipToZip | statusId | taxRate | taxRateId | taxRateName | toBeEmailed | toBePrinted | totalIncludesTax | totalTax | subTotal | totalPrice | typeId | url | username | vendorPO | customFields | paymentLink | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1709 | 501 County Rd E2 Extension | New Brighton | 2 | Donatelle Plastics | 26 | 55112 | 3 | 5022.822837847 | 9 | 1.0 | Donatelle Plastics | 70 | 106363-DPI | 2024-08-16 00:00:00.000000 | 2024-08-16 00:15:00.000000 | 2025-06-30 12:02:32.005000 | 2024-06-24 00:00:00.000000 | 2024-08-16 00:00:00.000000 | 2024-09-23 10:14:31.670000 | 2025-06-30 12:02:50.147000 | accounting@donatelle.net | 0.0 | 10 | 1 | 0.0 | Schedule is based upon receipt of all materials supplied by the end of July 2024. Updated: Oct 2024 | 115007 | 4 | 651-633-4200 | 30 | 1 | _binary | 31 | TOlivero | 6 | TO | 10 | 501 County Rd E2 Extension | New Brighton | 2 | Donatelle Plastics | 26 | 55112 | 70 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 133725.0 | 133725.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "true"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}} |