MSO&ISales Integration Sample JSON

 

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.

 

{

  "ConnectorIdentifier": "736A165F835D4C20B999620F0FDB4B8A",

  "Order": {

    "OrderNumber": {

      "EstimateNo": "TESTING-05",

      "ExternalID": "a8a75075ceee4c43a4c1f3403d031405"

    },

    "Commodity": "O\u0026I",

    "LastName": "Bob",

    "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": "External Download",

      "QuoteGroups": [

        {

          "SourceChargeId": "7927af4e08ab4b88ba7e3692b839a13c",

          "Description": "One ",

          "Charge": 624.0,

          "QuoteDetails": [

            {

              "SourceChargeId": "a71795a0f1d445d29bb621c995d86de2",

              "ItemCodeMapping": "d55e869d-3088-4117-84d8-c1d979e083d4",

              "RateType": "PerEachPerHour",

              "Description": "26\u0027 Straight Truck",

              "Rate": 30.0,

              "Quantity": 4,

              "Quantity2": 1,

              "Charge": 120.0,

              "NoteText": "1 26\u0027 Straight Truck @ $30.00/Hour/Truck for 4:00 Hours"

            },

            {

              "SourceChargeId": "14325b0872e649ab9b8df56bc35f30ea",

              "ItemCodeMapping": "d3e6a508-0fea-48ef-89f1-7fa6c362000a",

              "RateType": "PerManPerHour",

              "Description": "Driver",

              "Rate": 30.0,

              "Quantity": 4,

              "Quantity2": 1,

              "Charge": 120.0,

              "NoteText": "1 Driver @ $30.00/Hour for 4:00 Hours"

            },

            {

              "SourceChargeId": "f53be106a24142cf991ea4594eb1c3ea",

              "ItemCodeMapping": "24002e71-ff17-4ea5-97db-bceaa5a6cabe",

              "RateType": "PerManPerHour",

              "Description": "Mover",

              "Rate": 30.0,

              "Quantity": 4,

              "Quantity2": 2,

              "Charge": 240.0,

              "NoteText": "2 Mover(s) @ $30.00/Hour for 4:00 Hours"

            },

            {

              "SourceChargeId": "c14c829b9f2c479097683248de3b806b",

              "ItemCodeMapping": "61b64cc4-d601-4d60-9f0e-a61a7153ea9e",

              "RateType": "PerManPerHour",

              "Description": "Supervisor/Foreman",

              "Rate": 35.0,

              "Quantity": 4,

              "Quantity2": 1,

              "Charge": 140.0,

              "NoteText": "1 Supervisor/Foreman @ $35.00/Hour for 4:00 Hours"

            },

            {

              "SourceChargeId": "ee1157d7ce4c4b0eb38c05b4bef7ea17",

              "ItemCodeMapping": "c03980e1-6183-4554-ac08-5cb1f2c27733",

              "RateType": "PerEach",

              "Description": "Box - Standard Autofold",

              "Rate": 2.0,

              "Quantity": null,

              "Quantity2": 2,

              "Charge": 4.0,

              "NoteText": "2 Box - Standard Autofold(s) @ $2.00/Each"

            },

            {

              "SourceChargeId": "c331a3818b64408db01932175e215324",

              "ItemCodeMapping": "9ec5ab70-400f-4b70-bf0d-44cc6b078978",

              "RateType": "PerEachPerWeek",

              "Description": "4-Wheel Dolly",

              "Rate": 5.0,

              "Quantity": 0,

              "Quantity2": 7,

              "Charge": 0.0,

              "NoteText": "7 4-Wheel Dolly(s) @ $5.00/Week for 0 Week (Rented)"

            }

          ]

        },

        {

          "SourceChargeId": "5eff420a4383f63614ef7a4861e16b92",

          "Description": "Aggregates",

          "Charge": 0.0,

          "QuoteDetails": [

            {

              "SourceChargeId": "ac419b9a970b5b08a3afeb200aed90cf",

              "ItemCodeMapping": "Markup",

              "RateType": "Flat",

              "Description": "Markup",

              "Rate": null,

              "Quantity": null,

              "Quantity2": null,

              "Charge": 0.0,

              "NoteText": "Markup"

            }

          ]

        }

      ]

    },

    "ChargeEstimate": 624.0

  }

}