so: 2251
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2251 | 4300 44th St. SE | Kentwood | 2 | X-Rite Inc | 25 | 49512 | 8 | 12 | 0.0 | 9 | 1.0 | X-Rite Inc | 75 | 2048514 | 2024-12-31 00:00:00.000000 | 2024-12-31 00:15:00.000000 | 2025-02-20 15:35:08.892000 | 2024-12-23 00:00:00.000000 | 2024-12-31 00:00:00.000000 | 2024-12-23 12:08:34.079000 | 2025-02-20 15:35:08.908000 | xrinvoice@xrite.com | 0.0 | 10 | 1 | 0.0 | PO was cancelled due to redesign conversations. If they place an order for redesign a new SO # will be pulled. | 115571 | 4 | 888-800-9580 | 30 | 1 | _binary | 8 | MLaShombe | 9 | ML | 30 | 4300 44th St. SE | Kentwood | 2 | X-Rite Inc | 25 | 49512 | 70 | 0.0 | 1 | None | _binary | _binary | _binary | 0.0 | 2575.0 | 2575.0 | 10 | MLaShombe | {"33": {"name": "Commission?", "type": "Checkbox", "value": "true"}, "35": {"name": "Project Number", "type": "Text", "value": ""}, "38": {"name": "Budget Amount", "type": "Money"}} |