This section displays a sample of the JSON input that would come from MSO&ISales. This information could be helpful when troubleshooting issues involved with the data exchange.
The following is a sample JSON file and includes objects and properties for adding/updating Office & Industrial orders and Local Services, as well as the Sales Quote. There are many settings that may not be needed or required. Refer to MSO&ISales Integration Content for specifics on each property.
{
"ConnectorIdentifier": "736A165F835D4C20B999620F0FDB4B8A",
"Order": {
"OrderNumber": {
"OrderSeg":"311-7921-4",
"PSeg": null,
"OSeg": null,
"SSeg": null,
"VanLineID":"U",
"ExternalID": "XX-000000001"
},
"LastName": "Roberts",
"FirstName": "Bob",
"Commodity": "O\u0026I",
"AllowEmptyOrderCreate": true,
"OfficeIndustrial": {
"JobStartDate": "2024-08-01T00:00:00+00:00",
"JobEndDate": "2024-08-02T00:00:00+00:00",
"HeadCount": 12,
"OperationalNote": "INformation",
"Contacts": [
{
"ExternalID": "9beb2d44c4a4470fab68ad7f06ec157c",
"Contact": "Bob Jones",
"Title": null,
"Email": null,
"Address": null,
"Phones": []
},
{
"ExternalID": "f54653e0b25e4ccca328dc200f39e84d",
"Contact": "Bill Jones",
"Title": "Branch Manager",
"Email": null,
"Address": null,
"Phones": []
}
],
"Locations": [
{
"ExternalID": "3668364f48be458ab2c417db1ab275b9",
"ContactExternalID": "9beb2d44c4a4470fab68ad7f06ec157c",
"Name": "Bobs Office",
"Type": "ORIG",
"Address": {
"Address1": null,
"Address2": null,
"Address3": null,
"City": null,
"State": null,
"Postal": null,
"Country": "United States of America"
}
},
{
"ExternalID": "92fd5012043347679caa5f1ac493e07d",
"ContactExternalID": "f54653e0b25e4ccca328dc200f39e84d",
"Name": "Bills Office",
"Type": "DEST",
"Address": {
"Address1": "123 Any street",
"Address2": null,
"Address3": null,
"City": "Irvine",
"State": "CA",
"Postal": "92612",
"Country": "United States of America"
}
}
],
"LocalServices": [
{
"ExternalID": "f306f64470d14e60b760310544eb9807",
"OperationalPlan": "One ",
"LocalServiceType": "Standard (Shuttle)",
"Location": "O",
"ServiceDate": "2024-08-01T00:00:00",
"ServiceTime": "2024-08-01T09:00:00",
"HoursPerMan": 4,
"ServiceInstructions": "Information Origin",
"OriginLocationExternalID": "3668364f48be458ab2c417db1ab275b9",
"DestinationLocationExternalID": "92fd5012043347679caa5f1ac493e07d",
"EquipmentRequests": [
{
"EquipmentType": "4-Wheel Dolly",
"Quantity": 7
},
{
"EquipmentType": "26\u0027 Straight Truck",
"Quantity": 1
}
],
"LaborRequests": [
{
"LaborType": "Driver",
"Quantity": 1
},
{
"LaborType": "Mover",
"Quantity": 2
},
{
"LaborType": "Supervisor/Foreman",
"Quantity": 1
}
]
}
]
},
"SalesQuote": {
"QuoteStatus": "STATUS",
"QuoteGroups": [
{
"IsTransportationCharge": false,
"ItemCode": "CODE",
"ItemCodeMapping": "CODEMAPPING",
"RateType": "RateType",
"Description": "Item Description",
"Rate": "15.25",
"Quantity": "100",
"Quantity2": "1",
"Charge": "1525.00",
"ServiceProviderType": "Origin Agent",
"ServiceProviderName": "XYZ Moving & Stg",
"ServiceProviderCode": "U1234",
"VendorQuotedCharge": "1400.00",
"VendorActualCharge": "1500.00",
"PoNumber": "Charge PO Num",
"InvoiceNumber": "INV999999",
"ServiceDate": "2020-05-01",
"NoteText": "Some notes about this charge",
"ServiceProviderBillToType": "SHIPPER",
"SourceChargeId": "711B286A1CC64A22904FABA2D49FE0C8"
"Details": [
{
"IsTransportationCharge": false,
"ItemCode": "CODE",
"ItemCodeMapping": "CODEMAPPING",
"RateType": "RateType",
"Description": "Item Description",
"Rate": "10.00",
"Quantity": "100",
"Quantity2": "1",
"Charge": "1000.00",
"ServiceProviderType": "Carrier",
"ServiceProviderName": "XYZ Moving & Stg",
"ServiceProviderCode": "U1234",
"VendorQuotedCharge": "900.00",
"VendorActualCharge": "1000.00",
"PoNumber": "Charge PO Num",
"InvoiceNumber": "INV999999",
"ServiceDate": "2024-05-01",
"NoteText": "Some notes about this charge",
"ServiceProviderBillToType": "SHIPPER",
"SourceChargeId": "5D418DFC7E9E488DA8FB3DE1CC7D909D"
},
{
"IsTransportationCharge": false,
"ItemCode": "CODE",
"ItemCodeMapping": "CODEMAPPING",
"RateType": "RateType",
"Description": "Item Description",
"Rate": "525.00",
"Quantity": "100",
"Quantity2": "1",
"Charge": "525.00",
"ServiceProviderType": "Booking Agent",
"ServiceProviderName": "XYZ Moving & Stg",
"ServiceProviderCode": "U1234",
"VendorQuotedCharge": "400.00",
"VendorActualCharge": "525.00",
"PoNumber": "Charge PO Num",
"InvoiceNumber": "INV999999",
"ServiceDate": "2024-05-01",
"NoteText": "Some notes about this charge",
"ServiceProviderBillToType": "SHIPPER",
"SourceChargeId": "59AD39C22A254464AF3920E4BC89FCB5"
}
]
},
{
"IsTransportationCharge": false,
"ItemCode": "CODE",
"ItemCodeMapping": "CODEMAPPING",
"RateType": "RateType",
"Description": "Item Description",
"Rate": "20.00",
"Quantity": "100",
"Quantity2": "1",
"Charge": "200.00",
"ServiceProviderType": "Origin Agent",
"ServiceProviderName": "XYZ Moving & Stg",
"ServiceProviderCode": "U1234",
"VendorQuotedCharge": "1400.00",
"VendorActualCharge": "1500.00",
"PoNumber": "Charge PO Num",
"InvoiceNumber": "INV999999",
"ServiceDate": "2024-05-01",
"NoteText": "Some notes about this charge",
"ServiceProviderBillToType": "SHIPPER",
"SourceChargeId": "70308FD547C448DBBE7F0451B2AEB449"
}
]
}
}
}