Microsoft Dynamics 365 Business Central Component
Microsoft Dynamics 365 Business Central is a comprehensive enterprise resource planning (ERP) with capabilities including finance, manufacturing, customer relationship management (CRM), supply chains, analytics, and e-commerce.
Component key: ms-business-centralDescription
Microsoft Dynamics 365 Business Central is a comprehensive enterprise resource planning (ERP) with capabilities including finance, manufacturing, customer relationship management (CRM), supply chains, analytics, and e-commerce.
Use the Microsoft Dynamics 365 Business Central component to manage Sales Orders, Customers, Invoices, and Shipments.
API Documentation:
This component was built using the Microsoft Dynamics v.20 REST API
Connections
OAuth 2.0 Client Credentials
The OAuth 2.0 client credentials flow allows your user to create an Application User to send requests to Business Central on their behalf. Refer to the following Documentation for more information. Setting up a client credentials connection is a two-step process:
- Create an "App" in Azure
- Create an "Application User" in Business Central
Create an app in Microsoft Azure
- Log in to Azure Portal
- Select App registrations
- Click + New registration
- Supported account types can be Single tenant
- No Redirect URI is necessary
- Click Register
- Under API permissions click +Add a permission
- Select Business Central
- Check the following permissions
- user_impersonation
- offline_access
- Financials.ReadWrite.All
- Click Add permissions
- Under API permissions click Grant admin concent for (your org)
- Under Certificates & secrets click + New client secret
- Give your certificate a description and expiration date
- Take note of the value (not the Secret ID) of the client secret.
- Returning to the Overview page, take note of Application (client) ID
- From the Overview page, click Endpoints and take note of the OAuth 2.0 token endpoint (v2)
You will use the Secret Value, Client ID and Token Endpoint in a moment.
Add the app as an App User to Business Central
- Log in to Power Platform admin center
- Select Environments and choose your Business Central Environments
- Select S2S Apps
- Click +New app user
- Click +Add an app
- Choose the app you created in Azure portal (above). You can search for your app by entering the client ID you noted.
- Select your Business Central tenant as your Business unit
- Under Security Roles select System Administrator
- Click Create
Configure the connection in Prismatic
Within Prismatic, create a connection of type MS Business Central OAuth 2.0 Client Credentials.
- Enter the Token Endpoint you noted as your Token URL.
- Enter the Client ID and Secret Value you noted above.
OAuth 2.0 Auth Code
The OAuth 2.0 auth code flow allows your user grant permission to your integration to interact with Business Central on their behalf. Please refer to the following Documentation for more information
- Log in to Azure Portal
- Select App registrations
- Click + New registration
- Supported account types should be Multi-tenant if you intend for customers to authenticate with their own Business Central instance, or Single-tenant if you intend to authenticate with your own Business Central instance.
- Under Redirect URI enter https://oauth2.prismatic.io/callback
- Click Register
- Under API permissions click +Add a permission
- Select Business Central
- Check the following permissions
- user_impersonation
- offline_access
- Financials.ReadWrite.All
- Click Add permissions
- Under Certificates & secrets click + New client secret
- Give your certificate a description and expiration date
- Take note of the value (not the Secret ID) of the client secret.
- Returning to the Overview page, take note of Application (client) ID
Within Prismatic, create a connection of type OAuth 2.0 Auth Code.
- Enter the Client ID and Secret Value you noted above.
Triggers
Webhook Receiver
Receive a webhook payload from an external service. | key: webhookReceiver
Data Sources
Select Companies
A picklist of company objects in your Business Central organization. | key: listCompanies | type: picklist
Select Customers
A picklist of customer objects in your Business Central organization. | key: listCustomers | type: picklist
Select Items
A picklist of item objects in your Business Central organization. | key: listItems | type: picklist
Select Sales Invoices
A picklist of sales invoices objects in your Business Central organization. | key: listSalesInvoices | type: picklist
Select Sales Orders
A picklist of sales orders objects in your Business Central organization. | key: listSalesOrders | type: picklist
Select Sales Shipments
A picklist of sales shipment objects in your Business Central organization. | key: listSalesShipment | type: picklist
Actions
Create Attachment
Create a new attachment | key: createAttachment
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/$metadata#companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/attachments/$entity",
"@odata.etag": "W/\"JzE5OzMyMTg5ODE2ODE1NzUzODQ2NDcxOzAwOyc=\"",
"id": "25b8238e-f034-ef11-840b-002248241214",
"parentId": "a84eb92b-e60b-ef11-9f8e-6045bdc8c192",
"fileName": "test.pdf",
"byteSize": 0,
"lastModifiedDateTime": "2024-06-28T01:48:51Z",
"parentType": "Sales_x0020_Invoice",
"attachmentContent@odata.mediaEditLink": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/attachments(25b8238e-f034-ef11-840b-002248241214)/attachmentContent",
"attachmentContent@odata.mediaReadLink": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/attachments(25b8238e-f034-ef11-840b-002248241214)/attachmentContent"
}
}
Create Customer
Creates a customer object in Microsoft Business Central. | key: createCustomer
{
"data": {
"id": "8ba01a7a-5734-ef11-8409-7c1e5213ec0e",
"number": "C00020",
"displayName": "Customer Test 1",
"type": "Person",
"addressLine1": "192 Market square",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "robert.townes@gmailfake.com",
"website": "www.sample.com",
"salespersonCode": "",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "8955e220-e60b-ef11-9f8e-6045bdc8c192",
"currencyCode": "EUR",
"paymentTermsId": "7d55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"paymentMethodId": "a840ba25-e60b-ef11-9f8e-6045bdc8c192",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-06-27T07:33:02.2Z"
}
}
Create Item
Creates a new item object in your Business Central Organization. | key: createItem
{
"data": {
"id": "5247fc6c-2f35-ef11-840b-002248241214",
"number": "TESTO-001",
"displayName": "TEST",
"displayName2": "",
"type": "Inventory",
"itemCategoryId": "00000000-0000-0000-0000-000000000000",
"itemCategoryCode": "",
"blocked": false,
"gtin": "",
"inventory": 0,
"unitPrice": 0,
"priceIncludesTax": false,
"unitCost": 0,
"taxGroupId": "00000000-0000-0000-0000-000000000000",
"taxGroupCode": "",
"baseUnitOfMeasureId": "f957e220-e60b-ef11-9f8e-6045bdc8c192",
"baseUnitOfMeasureCode": "PCS",
"generalProductPostingGroupId": "9240ba25-e60b-ef11-9f8e-6045bdc8c192",
"generalProductPostingGroupCode": "RETAIL",
"inventoryPostingGroupId": "e557e220-e60b-ef11-9f8e-6045bdc8c192",
"inventoryPostingGroupCode": "RESALE",
"lastModifiedDateTime": "2024-06-28T09:18:58.05Z"
}
}
Create Purchase Order
Creates a purchase order object in your Business Central organization. | key: createPurchaseOrder
{
"data": {
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"orderDate": "2021-01-01T00:00:00.000Z",
"postingDate": "2021-01-01T00:00:00.000Z",
"dueDate": "2021-01-01T00:00:00.000Z",
"vendorId": "",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToVendorId": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "04a5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"purchaser": "First Up Consultants",
"requestedReceiptDate": "2021-01-01T00:00:00.000Z",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyReceived": false,
"status": "Draft",
"lastModifiedDateTime": "2021-01-01T00:26:53.793Z",
"shortcutDimension1Code": "",
"shortcutDimension2Code": ""
}
}
Create Purchase Order Line
Creates a purchase order line object in your Business Central organization. | key: createPurchaseOrderLine
{
"data": {
"id": "1e8cb9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "960f5c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"itemId": "0ea6738a-44e3-ea11-bb43-000d3a2feca1",
"accountId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"lineType": "Item",
"lineObjectNumber": "1996-S",
"description": "ATLANTA Whiteboard, base",
"unitOfMeasureId": "5ca6738a-44e3-ea11-bb43-000d3a2feca1",
"unitOfMeasureCode": "PCS",
"quantity": 12,
"directUnitCost": 1397.3,
"discountAmount": 0,
"discountPercent": 0,
"discountAppliedBeforeTax": false,
"amountExcludingTax": 16767.6,
"taxCode": "FURNITURE",
"taxPercent": 6.00002,
"totalTaxAmount": 1006.06,
"amountIncludingTax": 17773.66,
"invoiceDiscountAllocation": 0,
"netAmount": 16767.6,
"netTaxAmount": 1006.06,
"netAmountIncludingTax": 17773.66,
"expectedReceiptDate": "2020-04-02T00:00:00.000Z",
"receivedQuantity": 0,
"invoicedQuantity": 0,
"invoiceQuantity": 12,
"receiveQuantity": 12,
"itemVariantId": "00000000-0000-0000-0000-000000000000",
"locationId": "00000000-0000-0000-0000-000000000000"
}
}
Create Sales Invoice
Creates a sales invoice object in your Business Central organization. | key: createSalesInvoice
{
"data": {
"id": "b353895e-5635-ef11-8409-6045bdfedf9a",
"number": "PS-INV103001",
"externalDocumentNumber": "",
"invoiceDate": "2019-01-15",
"postingDate": "2019-01-15",
"dueDate": "2019-01-15",
"customerPurchaseOrderReference": "",
"customerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"customerNumber": "20000",
"customerName": "Trey Research",
"billToCustomerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"billToCustomerNumber": "20000",
"shipToName": "Trey Research",
"shipToContact": "Helen Ray",
"sellToAddressLine1": "153 Thomas Drive",
"sellToAddressLine2": "",
"sellToCity": "Chicago",
"sellToCountry": "US",
"sellToState": "IL",
"sellToPostCode": "61236",
"shipToAddressLine1": "153 Thomas Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "0ba5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "PS",
"discountAmount": 0,
"phoneNumber": "",
"email": "helen.ray@contoso.com"
}
}
Create Sales Order
Creates a sales order object in your Business Central organization. | key: createSalesOrder
{
"data": {
"id": "54a53ee8-3835-ef11-840b-00224820d4a6",
"number": "S-ORD101010",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:26:43.957Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
}
Create Shipment Method
Create a new shipment method | key: createShipmentMethod
{
"data": {
"id": "be90f4f2-1735-ef11-8409-6045bdfedf9a",
"code": "TEST",
"displayName": "test",
"lastModifiedDateTime": "2024-06-28T06:30:46.263Z"
}
}
Delete Attachment
Delete an attachment object in Business Central. | key: deleteAttachment
{
"data": {
"message": "Success"
}
}
Delete Customer
Deletes a customer object in your Business Central organization. | key: deleteCustomer
{
"data": {
"message": "Success"
}
}
Delete Item
Deletes an item object in your Business Central Organization. | key: deleteItem
{
"data": {
"message": "Success"
}
}
Delete Purchase Order
Deletes a purchase order object in your Business Central Organization. | key: deletePurchaseOrder
{
"data": {
"message": "Success"
}
}
Delete Purchase Order Line
Deletes a purchase order line object in your Business Central Organization. | key: deletePurchaseOrderLine
{
"data": {
"message": "Success"
}
}
Delete Sales Invoice
Deletes a sales invoice object in your Business Central Organization. | key: deleteSalesInvoice
{
"data": {
"message": "Success"
}
}
Delete Sales Order
Deletes a sales order object in your Business Central Organization. | key: deleteSalesOrder
{
"data": {
"message": "Success"
}
}
Delete Shipment Method
Deletes a shipment method object in your Business Central organization. | key: deleteShipmentMethod
{
"data": {
"message": "Success"
}
}
Get Account
Retrieve the properties and relationships of an account object in Microsoft Business Central. | key: getAccount
{
"data": {
"id": "2256e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "10000",
"displayName": "Balance Sheet",
"category": "Assets",
"subCategory": "Assets",
"blocked": false,
"accountType": "Heading",
"directPosting": false,
"netChange": 0,
"consolidationTranslationMethod": "Average Rate (Manual)",
"consolidationDebitAccount": "",
"consolidationCreditAccount": "",
"excludeFromConsolidation": false,
"lastModifiedDateTime": "2024-05-06T20:21:22.54Z"
}
}
Get Attachment
Gets an attachment object | key: getAttachment
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/$metadata#companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/attachments",
"value": [
{
"id": "25b8238e-f034-ef11-840b-002248241214",
"parentId": "a84eb92b-e60b-ef11-9f8e-6045bdc8c192",
"fileName": "test.pdf",
"byteSize": 0,
"lastModifiedDateTime": "2024-06-28T01:48:51Z",
"parentType": "Sales_x0020_Invoice"
}
]
}
}
Get Company Information
Get information about a company in your Business Central organization. | key: getCompanyInformation
{
"data": {
"displayName": "CRONUS USA, Inc.",
"addressLine1": "7122 South Ashford Street",
"addressLine2": "Westminster",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "+1 425 555 0100",
"faxNumber": "+1 425 555 0101",
"email": "",
"website": "",
"taxRegistrationNumber": "",
"currencyCode": "USD",
"currentFiscalYearStartDate": "2021-01-01"
}
}
Get Customer
Retrieve the properties and relationships of a customer object in your Business Central organization. | key: getCustomer
{
"id": "8ba01a7a-5734-ef11-8409-7c1e5213ec0e",
"number": "C00020",
"displayName": "Customer Test 1",
"type": "Person",
"addressLine1": "192 Market square",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "robert.townes@gmailfake.com",
"website": "www.sample.com",
"salespersonCode": "",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "8955e220-e60b-ef11-9f8e-6045bdc8c192",
"currencyCode": "EUR",
"paymentTermsId": "7d55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"paymentMethodId": "a840ba25-e60b-ef11-9f8e-6045bdc8c192",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-06-27T07:33:02.2Z"
}
Get Item
Retrieves an item object from your Business Central Organization. | key: getItem
{
"data": {
"id": "5247fc6c-2f35-ef11-840b-002248241214",
"number": "TESTO-001",
"displayName": "TEST",
"displayName2": "",
"type": "Inventory",
"itemCategoryId": "00000000-0000-0000-0000-000000000000",
"itemCategoryCode": "",
"blocked": false,
"gtin": "",
"inventory": 0,
"unitPrice": 0,
"priceIncludesTax": false,
"unitCost": 0,
"taxGroupId": "00000000-0000-0000-0000-000000000000",
"taxGroupCode": "",
"baseUnitOfMeasureId": "f957e220-e60b-ef11-9f8e-6045bdc8c192",
"baseUnitOfMeasureCode": "PCS",
"generalProductPostingGroupId": "9240ba25-e60b-ef11-9f8e-6045bdc8c192",
"generalProductPostingGroupCode": "RETAIL",
"inventoryPostingGroupId": "e557e220-e60b-ef11-9f8e-6045bdc8c192",
"inventoryPostingGroupCode": "RESALE",
"lastModifiedDateTime": "2024-06-28T09:18:58.05Z"
}
}
Get Purchase Order
Retrieves a purchase order object in your Business Central Organization. | key: getPurchaseOrder
{
"data": {
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"orderDate": "2021-01-01T00:00:00.000Z",
"postingDate": "2021-01-01T00:00:00.000Z",
"dueDate": "2021-01-01T00:00:00.000Z",
"vendorId": "",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToVendorId": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "04a5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"purchaser": "First Up Consultants",
"requestedReceiptDate": "2021-01-01T00:00:00.000Z",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyReceived": false,
"status": "Draft",
"lastModifiedDateTime": "2021-01-01T00:26:53.793Z",
"shortcutDimension1Code": "",
"shortcutDimension2Code": ""
}
}
Get Purchase Order Line
Retrieves a purchase order line object in your Business Central Organization. | key: getPurchaseOrderLine
{
"data": {
"id": "1e8cb9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "960f5c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"itemId": "0ea6738a-44e3-ea11-bb43-000d3a2feca1",
"accountId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"lineType": "Item",
"lineObjectNumber": "1996-S",
"description": "ATLANTA Whiteboard, base",
"unitOfMeasureId": "5ca6738a-44e3-ea11-bb43-000d3a2feca1",
"unitOfMeasureCode": "PCS",
"quantity": 12,
"directUnitCost": 1397.3,
"discountAmount": 0,
"discountPercent": 0,
"discountAppliedBeforeTax": false,
"amountExcludingTax": 16767.6,
"taxCode": "FURNITURE",
"taxPercent": 6.00002,
"totalTaxAmount": 1006.06,
"amountIncludingTax": 17773.66,
"invoiceDiscountAllocation": 0,
"netAmount": 16767.6,
"netTaxAmount": 1006.06,
"netAmountIncludingTax": 17773.66,
"expectedReceiptDate": "2020-04-02T00:00:00.000Z",
"receivedQuantity": 0,
"invoicedQuantity": 0,
"invoiceQuantity": 12,
"receiveQuantity": 12,
"itemVariantId": "00000000-0000-0000-0000-000000000000",
"locationId": "00000000-0000-0000-0000-000000000000"
}
}
Get Purchase Receipt
Retrieves a purchase receipt object in your Business Central Organization. | key: getPurchaseReceipt
{
"data": {
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"invoiceDate": "2019-01-01T00:00:00.000Z",
"postingDate": "2019-01-01T00:00:00.000Z",
"dueDate": "2019-01-01T00:00:00.000Z",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToContact": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyCode": "USD",
"lastModifiedDateTime": "2019-01-01T00:00:00.000Z"
}
}
Get Purchase Receipt Line
Retrieves a purchase receipt line object in your Business Central Organization. | key: getPurchaseReceiptLine
{
"data": {
"id": "dd8db9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"lineType": "Item",
"lineObjectNumber": "1896-S",
"description": "ATHENS Desk",
"unitOfMeasureCode": "PCS",
"unitCost": 780.7,
"quantity": 4,
"discountPercent": 5,
"taxPercent": 10,
"expectedReceiptDate": "2021-01-01T00:00:00.000Z"
}
}
Get Sale Shipment
Retrieves a sale shipment object from your Business Central organization. | key: getSaleShipment
{
"data": {
"id": "647a3456-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-SHPT102002",
"externalDocumentNumber": "",
"invoiceDate": "2023-01-18",
"postingDate": "2023-01-18",
"dueDate": "2023-01-18",
"customerPurchaseOrderReference": "",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToName": "Adatum Corporation",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"currencyCode": "USD",
"orderNumber": "",
"paymentTermsCode": "COD",
"shipmentMethodCode": "",
"salesperson": "JO",
"pricesIncludeTax": false,
"lastModifiedDateTime": "2024-05-06T20:22:23.263Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
}
Get Sales Invoice
Retrieves a sales invoice object in your Business Central Organization. | key: getSalesInvoice
{
"data": {
"id": "b353895e-5635-ef11-8409-6045bdfedf9a",
"number": "PS-INV103001",
"externalDocumentNumber": "",
"invoiceDate": "2019-01-15",
"postingDate": "2019-01-15",
"dueDate": "2019-01-15",
"customerPurchaseOrderReference": "",
"customerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"customerNumber": "20000",
"customerName": "Trey Research",
"billToCustomerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"billToCustomerNumber": "20000",
"shipToName": "Trey Research",
"shipToContact": "Helen Ray",
"sellToAddressLine1": "153 Thomas Drive",
"sellToAddressLine2": "",
"sellToCity": "Chicago",
"sellToCountry": "US",
"sellToState": "IL",
"sellToPostCode": "61236",
"shipToAddressLine1": "153 Thomas Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "0ba5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "PS",
"discountAmount": 0,
"phoneNumber": "",
"email": "helen.ray@contoso.com"
}
}
Get Sales Order
Retrieves a sales order object in your Business Central Organization. | key: getSalesOrder
{
"data": {
"id": "54a53ee8-3835-ef11-840b-00224820d4a6",
"number": "S-ORD101010",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:26:43.957Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
}
Get Sales Shipment Line Item
Gets a sales shipment line object | key: getSalesShipmentLines
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/$metadata#companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/salesShipmentLines/$entity",
"@odata.etag": "W/\"JzE4Ozg0ODEwNzQxNDUwODk0NjY5MzE7MDA7Jw==\"",
"id": "4f7a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentId": "437a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentNo": "S-SHPT102001",
"sequence": 10000,
"lineType": "Item",
"lineObjectNumber": "1928-S",
"description": "AMSTERDAM Lamp",
"description2": "",
"unitOfMeasureCode": "PCS",
"unitPrice": 54.9,
"quantity": 3,
"discountPercent": 0,
"taxPercent": 5,
"shipmentDate": "2024-05-06"
}
}
Get Shipment Method
Retrieves a shipment method object in your Business Central organization. | key: getShipmentMethod
{
"data": {
"id": "be90f4f2-1735-ef11-8409-6045bdfedf9a",
"code": "TEST",
"displayName": "test",
"lastModifiedDateTime": "2024-06-28T06:30:46.263Z"
}
}
List Accounts
Retrieve the properties and relationships of all account objects in your Business Central organization. | key: listAccounts
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/$metadata#companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/accounts",
"value": [
{
"id": "2256e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "10000",
"displayName": "Balance Sheet",
"category": "Assets",
"subCategory": "Assets",
"blocked": false,
"accountType": "Heading",
"directPosting": false,
"netChange": 0,
"consolidationTranslationMethod": "Average Rate (Manual)",
"consolidationDebitAccount": "",
"consolidationCreditAccount": "",
"excludeFromConsolidation": false,
"lastModifiedDateTime": "2024-05-06T20:21:22.54Z"
}
]
}
}
List Companies
Retrieve the properties and relationships of companies in your Business Central organization. | key: listCompanies
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/production/api/data/$metadata#companies",
"value": [
{
"id": "f1678e37-e50b-ef11-9f8e-6045bdc8c192",
"systemVersion": "24.1.18927.19282",
"timestamp": 4070,
"name": "CRONUS USA, Inc.",
"displayName": "",
"businessProfileId": "",
"systemCreatedAt": "2024-05-06T20:14:23.247Z",
"systemCreatedBy": "00000000-0000-0000-0000-000000000001",
"systemModifiedAt": "2024-05-06T20:14:23.247Z",
"systemModifiedBy": "00000000-0000-0000-0000-000000000001"
}
]
}
}
List Customers
Retrieve the properties and relationships of all customer objects in your Business Central organization. | key: listCustomers
{
"data": {
"value": [
{
"id": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "10000",
"displayName": "Adatum Corporation",
"type": "Company",
"addressLine1": "192 Market Square",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "robert.townes@contoso.com",
"website": "",
"salespersonCode": "JO",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": true,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "00000000-0000-0000-0000-000000000000",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-05-06T20:21:41.53Z"
},
{
"id": "7f57e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "20000",
"displayName": "Trey Research",
"type": "Company",
"addressLine1": "153 Thomas Drive",
"addressLine2": "",
"city": "Chicago",
"state": "IL",
"country": "US",
"postalCode": "61236",
"phoneNumber": "",
"email": "helen.ray@contoso.com",
"website": "",
"salespersonCode": "JO",
"balanceDue": 3036.6,
"creditLimit": 0,
"taxLiable": true,
"taxAreaId": "0341ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "CHICAGO, IL",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "00000000-0000-0000-0000-000000000000",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-05-06T20:21:41.543Z"
},
{
"id": "8057e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "30000",
"displayName": "School of Fine Art",
"type": "Company",
"addressLine1": "10 High Tower Green",
"addressLine2": "",
"city": "Miami",
"state": "FL",
"country": "US",
"postalCode": "37125",
"phoneNumber": "",
"email": "meagan.bond@contoso.com",
"website": "",
"salespersonCode": "JO",
"balanceDue": 53833.52,
"creditLimit": 0,
"taxLiable": true,
"taxAreaId": "0441ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "MIAMI, FL",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "8655e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "00000000-0000-0000-0000-000000000000",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-05-06T20:21:41.607Z"
},
{
"id": "8157e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "40000",
"displayName": "Alpine Ski House",
"type": "Company",
"addressLine1": "10 Deerfield Road",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "ian.deberry@contoso.com",
"website": "",
"salespersonCode": "JO",
"balanceDue": 4316.92,
"creditLimit": 0,
"taxLiable": true,
"taxAreaId": "0541ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "Atlanta, GA - North",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "00000000-0000-0000-0000-000000000000",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-05-06T20:21:41.62Z"
},
{
"id": "8257e220-e60b-ef11-9f8e-6045bdc8c192",
"number": "50000",
"displayName": "Relecloud",
"type": "Company",
"addressLine1": "25 Water Way",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "jesse.homer@contoso.com",
"website": "",
"salespersonCode": "JO",
"balanceDue": 8836.8,
"creditLimit": 0,
"taxLiable": true,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "00000000-0000-0000-0000-000000000000",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-05-06T20:21:41.637Z"
},
{
"id": "83800c53-4227-ef11-9f88-002248241214",
"number": "C00010",
"displayName": "Prismatic",
"type": "Company",
"addressLine1": "",
"addressLine2": "",
"city": "",
"state": "",
"country": "US",
"postalCode": "",
"phoneNumber": "",
"email": "",
"website": "",
"salespersonCode": "",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "0341ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "CHICAGO, IL",
"taxRegistrationNumber": "",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"paymentMethodId": "a940ba25-e60b-ef11-9f8e-6045bdc8c192",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-06-10T15:59:01.273Z"
},
{
"id": "8ba01a7a-5734-ef11-8409-7c1e5213ec0e",
"number": "C00020",
"displayName": "Customer Test 1",
"type": "Person",
"addressLine1": "192 Market square",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "robert.townes@gmailfake.com",
"website": "www.sample.com",
"salespersonCode": "",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "8955e220-e60b-ef11-9f8e-6045bdc8c192",
"currencyCode": "EUR",
"paymentTermsId": "7d55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"paymentMethodId": "a840ba25-e60b-ef11-9f8e-6045bdc8c192",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-06-27T07:33:02.2Z"
}
]
}
}
List Items
List all item objects from your Business Central Organization. | key: listItems
List Purchase Order Lines
List all purchase order line objects in your Business Central Organization. | key: listPurchaseOrderLines
{
"data": {
"value": [
{
"id": "1e8cb9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "960f5c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"itemId": "0ea6738a-44e3-ea11-bb43-000d3a2feca1",
"accountId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"lineType": "Item",
"lineObjectNumber": "1996-S",
"description": "ATLANTA Whiteboard, base",
"unitOfMeasureId": "5ca6738a-44e3-ea11-bb43-000d3a2feca1",
"unitOfMeasureCode": "PCS",
"quantity": 12,
"directUnitCost": 1397.3,
"discountAmount": 0,
"discountPercent": 0,
"discountAppliedBeforeTax": false,
"amountExcludingTax": 16767.6,
"taxCode": "FURNITURE",
"taxPercent": 6.00002,
"totalTaxAmount": 1006.06,
"amountIncludingTax": 17773.66,
"invoiceDiscountAllocation": 0,
"netAmount": 16767.6,
"netTaxAmount": 1006.06,
"netAmountIncludingTax": 17773.66,
"expectedReceiptDate": "2020-04-02T00:00:00.000Z",
"receivedQuantity": 0,
"invoicedQuantity": 0,
"invoiceQuantity": 12,
"receiveQuantity": 12,
"itemVariantId": "00000000-0000-0000-0000-000000000000",
"locationId": "00000000-0000-0000-0000-000000000000"
}
]
}
}
List Purchase Orders
List all purchase order objects in your Business Central Organization. | key: listPurchaseOrders
{
"data": {
"value": [
{
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"orderDate": "2021-01-01T00:00:00.000Z",
"postingDate": "2021-01-01T00:00:00.000Z",
"dueDate": "2021-01-01T00:00:00.000Z",
"vendorId": "",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToVendorId": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "04a5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"purchaser": "First Up Consultants",
"requestedReceiptDate": "2021-01-01T00:00:00.000Z",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyReceived": false,
"status": "Draft",
"lastModifiedDateTime": "2021-01-01T00:26:53.793Z",
"shortcutDimension1Code": "",
"shortcutDimension2Code": ""
}
]
}
}
List Purchase Receipt Lines
List all purchase receipt line objects in your Business Central Organization. | key: listPurchaseReceiptLines
{
"data": {
"value": [
{
"id": "dd8db9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"lineType": "Item",
"lineObjectNumber": "1896-S",
"description": "ATHENS Desk",
"unitOfMeasureCode": "PCS",
"unitCost": 780.7,
"quantity": 4,
"discountPercent": 5,
"taxPercent": 10,
"expectedReceiptDate": "2021-01-01T00:00:00.000Z"
}
]
}
}
List Purchase Receipts
List all purchase receipt objects in your Business Central Organization. | key: listPurchaseReceipts
{
"data": {
"value": [
{
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"invoiceDate": "2019-01-01T00:00:00.000Z",
"postingDate": "2019-01-01T00:00:00.000Z",
"dueDate": "2019-01-01T00:00:00.000Z",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToContact": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyCode": "USD",
"lastModifiedDateTime": "2019-01-01T00:00:00.000Z"
}
]
}
}
List Sales Invoices
List all sales invoices objects in your Business Central Organization. | key: listSalesInvoices
{
"data": {
"value": [
{
"id": "a84eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "PS-INV103001",
"externalDocumentNumber": "",
"invoiceDate": "2023-01-17",
"postingDate": "2023-01-17",
"dueDate": "2023-01-17",
"promisedPayDate": "0001-01-01",
"customerPurchaseOrderReference": "",
"customerId": "7f57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "20000",
"customerName": "Trey Research",
"billToName": "Trey Research",
"billToCustomerId": "7f57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "20000",
"shipToName": "Trey Research",
"shipToContact": "Helen Ray",
"sellToAddressLine1": "153 Thomas Drive",
"sellToAddressLine2": "",
"sellToCity": "Chicago",
"sellToCountry": "US",
"sellToState": "IL",
"sellToPostCode": "61236",
"billToAddressLine1": "153 Thomas Drive",
"billToAddressLine2": "",
"billToCity": "Chicago",
"billToCountry": "US",
"billToState": "IL",
"billToPostCode": "61236",
"shipToAddressLine1": "153 Thomas Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "MEDIUM",
"currencyCode": "USD",
"orderId": "00000000-0000-0000-0000-000000000000",
"orderNumber": "",
"paymentTermsId": "8755e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"disputeStatusId": "00000000-0000-0000-0000-000000000000",
"disputeStatus": "",
"pricesIncludeTax": false,
"remainingAmount": 0,
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 164.7,
"totalTaxAmount": 8.24,
"totalAmountIncludingTax": 172.94,
"status": "Paid",
"lastModifiedDateTime": "2024-05-06T20:22:22.897Z",
"phoneNumber": "",
"email": "helen.ray@contoso.com"
},
{
"id": "aa4eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "PS-INV103002",
"externalDocumentNumber": "",
"invoiceDate": "2023-01-18",
"postingDate": "2023-01-18",
"dueDate": "2023-01-18",
"promisedPayDate": "0001-01-01",
"customerPurchaseOrderReference": "",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"currencyId": "00000000-0000-0000-0000-000000000000",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyCode": "USD",
"orderId": "00000000-0000-0000-0000-000000000000",
"orderNumber": "",
"paymentTermsId": "8755e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"disputeStatusId": "00000000-0000-0000-0000-000000000000",
"disputeStatus": "",
"pricesIncludeTax": false,
"remainingAmount": 0,
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 771.2,
"totalTaxAmount": 46.27,
"totalAmountIncludingTax": 817.47,
"status": "Paid",
"lastModifiedDateTime": "2024-05-06T20:22:23.4Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
]
}
}
List Sales Orders
List all sales orders objects in your Business Central Organization. | key: listSalesOrders
{
"data": {
"value": [
{
"id": "a04eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101001",
"externalDocumentNumber": "",
"orderDate": "2024-04-02",
"postingDate": "2024-04-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "2024-04-03",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 16767.6,
"totalTaxAmount": 1006.06,
"totalAmountIncludingTax": 17773.66,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.077Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzIwMTAyNTQxNjYyNjI0MTc1MzQxOzAwOyc=\"",
"id": "a24eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101002",
"externalDocumentNumber": "",
"orderDate": "2024-05-01",
"postingDate": "2024-05-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "2024-05-02",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 2285.3,
"totalTaxAmount": 137.12,
"totalAmountIncludingTax": 2422.42,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.127Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzE4MjgwODI3MDgwNTc3NjM3NDk0MTswMDsn\"",
"id": "a44eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101003",
"externalDocumentNumber": "",
"orderDate": "2024-04-22",
"postingDate": "2024-04-22",
"customerId": "8057e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "30000",
"customerName": "School of Fine Art",
"billToName": "School of Fine Art",
"billToCustomerId": "8057e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "30000",
"shipToName": "School of Fine Art",
"shipToContact": "Meagan Bond",
"sellToAddressLine1": "10 High Tower Green",
"sellToAddressLine2": "",
"sellToCity": "Miami",
"sellToCountry": "US",
"sellToState": "FL",
"sellToPostCode": "37125",
"billToAddressLine1": "10 High Tower Green",
"billToAddressLine2": "",
"billToCity": "Miami",
"billToCountry": "US",
"billToState": "FL",
"billToPostCode": "37125",
"shipToAddressLine1": "10 High Tower Green",
"shipToAddressLine2": "",
"shipToCity": "Miami",
"shipToCountry": "US",
"shipToState": "FL",
"shipToPostCode": "37125",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "LARGE",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8655e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "2024-04-23",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 5182.4,
"totalTaxAmount": 362.77,
"totalAmountIncludingTax": 5545.17,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.157Z",
"phoneNumber": "",
"email": "meagan.bond@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzEyMzUwMTIzNDM1Mjg5MDUxNjI2MTswMDsn\"",
"id": "a64eb92b-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101004",
"externalDocumentNumber": "",
"orderDate": "2024-05-13",
"postingDate": "2024-05-13",
"customerId": "8157e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "40000",
"customerName": "Alpine Ski House",
"billToName": "Alpine Ski House",
"billToCustomerId": "8157e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "40000",
"shipToName": "Alpine Ski House",
"shipToContact": "Ian Deberry",
"sellToAddressLine1": "10 Deerfield Road",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "10 Deerfield Road",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "10 Deerfield Road",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "2024-05-14",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 570.3,
"totalTaxAmount": 39.92,
"totalAmountIncludingTax": 610.22,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.227Z",
"phoneNumber": "",
"email": "ian.deberry@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzE4MzQ0OTY2MDczODE5MjM3NzI0MTswMDsn\"",
"id": "8eb5fa9a-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101005",
"externalDocumentNumber": "Y-3",
"orderDate": "2023-06-01",
"postingDate": "2023-06-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 150,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 150,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.25Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzE3MDUwNjY4MDEzMjY1NDY2NjYwMTswMDsn\"",
"id": "91b5fa9a-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101006",
"externalDocumentNumber": "Y-4",
"orderDate": "2023-06-01",
"postingDate": "2023-06-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 600,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 600,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.277Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzEwMTI4OTk4NTA2NjczNTMzOTAwMTswMDsn\"",
"id": "95b5fa9a-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101007",
"externalDocumentNumber": "Y-5",
"orderDate": "2023-06-01",
"postingDate": "2023-06-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 450,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 450,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.297Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzI2MzQ1MDIwMzc3NDU4MTA1NzUxOzAwOyc=\"",
"id": "9cb5fa9a-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101008",
"externalDocumentNumber": "W-1",
"orderDate": "2023-06-01",
"postingDate": "2023-06-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 60,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 60,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.343Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzEwMjk5MjA5NDU3OTk1MjEzNzYwMTswMDsn\"",
"id": "a1b5fa9a-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-ORD101009",
"externalDocumentNumber": "SVC-1",
"orderDate": "2023-06-01",
"postingDate": "2023-06-01",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Atlanta",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Atlanta",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Atlanta",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": true,
"totalAmountExcludingTax": 2400,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 2400,
"fullyShipped": true,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T12:31:52.363Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzE3MzI2NDg3MTg0MDQ2MjQzMjA5MTswMDsn\"",
"id": "54a53ee8-3835-ef11-840b-00224820d4a6",
"number": "S-ORD101010",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:26:43.957Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzUzNzEwNTgxMjkxMTI4MzA3MDYxOzAwOyc=\"",
"id": "cf703b0e-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101011",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:27:45.23Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5Ozg3NDkzOTQ4MTkxNDc0MTg3ODkxOzAwOyc=\"",
"id": "32713b0e-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101012",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:27:52.563Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzY4MzQ5MjMwMDM2OTI3NzE4NzAxOzAwOyc=\"",
"id": "3da43814-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101013",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:28:04.22Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzgxODQ2NzU2MzYzOTIyMzkyMzAxOzAwOyc=\"",
"id": "baf49a20-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101014",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:28:15.887Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE4Ozk0MzE5MzIwOTM0MjI4MTQ3NDE7MDA7Jw==\"",
"id": "cfc9b426-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101015",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:28:26.11Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5Ozc5MzgxMzg0MzQxODQ2MDUwNDYxOzAwOyc=\"",
"id": "65c0aa32-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101016",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:28:51.803Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzM0NjQ4Mjc5NDQzODEyOTk1NTQxOzAwOyc=\"",
"id": "f3f1ae38-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101017",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:29:01.517Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5OzcxNjUzNDU4Mjk5NTI2NDk0NDQxOzAwOyc=\"",
"id": "23742241-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101018",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:29:12.63Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzIwOzEzMjIzNTMyNzIzNzcwNjkyMjYxMTswMDsn\"",
"id": "e12e3047-3935-ef11-840b-00224820d4a6",
"number": "S-ORD101019",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "192 Market Square",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "192 Market Square",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "192 Market Square",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:29:22.56Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
},
{
"@odata.etag": "W/\"JzE5Ozk1NjYxMDY3OTE0NDg5NzQ0MTYxOzAwOyc=\"",
"id": "cd0a9fbb-4135-ef11-8409-6045bdfedf9a",
"number": "S-ORD101020",
"externalDocumentNumber": "",
"orderDate": "2024-06-28",
"postingDate": "2024-06-28",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "SALES",
"shortcutDimension2Code": "SMALL",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "8055e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T11:29:52.907Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
]
}
}
List Sales Shipment Line Items
Lists all sales shipment line objects in your Business Central organization. | key: listSalesShipmentLines
{
"data": {
"value": [
{
"id": "4f7a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentId": "437a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentNo": "S-SHPT102001",
"sequence": 10000,
"lineType": "Item",
"lineObjectNumber": "1928-S",
"description": "AMSTERDAM Lamp",
"description2": "",
"unitOfMeasureCode": "PCS",
"unitPrice": 54.9,
"quantity": 3,
"discountPercent": 0,
"taxPercent": 5,
"shipmentDate": "2024-05-06"
},
{
"id": "6f7a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentId": "647a3456-e60b-ef11-9f8e-6045bdc8c192",
"documentNo": "S-SHPT102002",
"sequence": 10000,
"lineType": "Item",
"lineObjectNumber": "1960-S",
"description": "ROME Guest Chair, green",
"description2": "",
"unitOfMeasureCode": "PCS",
"unitPrice": 192.8,
"quantity": 4,
"discountPercent": 0,
"taxPercent": 6,
"shipmentDate": "2024-05-06"
}
]
}
}
List Sales Shipments
List all sales shipments objects from your Business Central organization. | key: listSaleShipments
{
"data": {
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/29dd78b9-6d0d-47ab-9427-2a49d9a1deb1/Production/api/v2.0/$metadata#companies(f1678e37-e50b-ef11-9f8e-6045bdc8c192)/salesShipments",
"value": [
{
"id": "437a3456-e60b-ef11-9f8e-6045bdc8c192",
"number": "S-SHPT102001",
"externalDocumentNumber": "",
"invoiceDate": "2023-01-17",
"postingDate": "2023-01-17",
"dueDate": "2023-01-17",
"customerPurchaseOrderReference": "",
"customerId": "7f57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "20000",
"customerName": "Trey Research",
"billToCustomerId": "7f57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToName": "Trey Research",
"billToCustomerNumber": "20000",
"shipToName": "Trey Research",
"shipToContact": "Helen Ray",
"sellToAddressLine1": "153 Thomas Drive",
"sellToAddressLine2": "",
"sellToCity": "Chicago",
"sellToCountry": "US",
"sellToState": "IL",
"sellToPostCode": "61236",
"billToAddressLine1": "153 Thomas Drive",
"billToAddressLine2": "",
"billToCity": "Chicago",
"billToCountry": "US",
"billToState": "IL",
"billToPostCode": "61236",
"shipToAddressLine1": "153 Thomas Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"currencyCode": "USD",
"orderNumber": "",
"paymentTermsCode": "COD",
"shipmentMethodCode": "",
"salesperson": "JO",
"pricesIncludeTax": false,
"lastModifiedDateTime": "2024-05-06T20:22:21.69Z",
"phoneNumber": "",
"email": "helen.ray@contoso.com"
}
]
}
}
Raw Request
Send a raw HTTP request to Microsoft's Business Central API | key: rawRequest
Update Attachment
Update the attachment content in Business Central. | key: updateAttachment
{
"data": {
"message": "Success"
}
}
Update Company Information
Update the properties of a company information object in your Business Central organization. | key: updateCompanyInformation
{
"displayName": "CRONUS USA, Inc.",
"addressLine1": "7122 South Ashford Street",
"addressLine2": "Westminster",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "+1 425 555 0100",
"faxNumber": "+1 425 555 0101",
"email": "",
"website": "",
"taxRegistrationNumber": "",
"currencyCode": "USD",
"currentFiscalYearStartDate": "2021-01-01",
"industry": ""
}
Update Customer
Update a customer object in your Business Central organization. | key: updateCustomer
{
"data": {
"id": "8ba01a7a-5734-ef11-8409-7c1e5213ec0e",
"number": "C00020",
"displayName": "Customer Test 1",
"type": "Person",
"addressLine1": "192 Market square",
"addressLine2": "",
"city": "Atlanta",
"state": "GA",
"country": "US",
"postalCode": "31772",
"phoneNumber": "",
"email": "robert.townes@gmailfake.com",
"website": "www.sample.com",
"salespersonCode": "",
"balanceDue": 0,
"creditLimit": 0,
"taxLiable": false,
"taxAreaId": "0241ba25-e60b-ef11-9f8e-6045bdc8c192",
"taxAreaDisplayName": "ATLANTA, GA",
"taxRegistrationNumber": "",
"currencyId": "8955e220-e60b-ef11-9f8e-6045bdc8c192",
"currencyCode": "EUR",
"paymentTermsId": "7d55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"paymentMethodId": "a840ba25-e60b-ef11-9f8e-6045bdc8c192",
"blocked": "_x0020_",
"lastModifiedDateTime": "2024-06-27T07:33:02.2Z"
}
}
Update Item
Updates an item object from your Business Central Organization. | key: updateItem
{
"data": {
"id": "5247fc6c-2f35-ef11-840b-002248241214",
"number": "TESTO-001",
"displayName": "TEST",
"displayName2": "",
"type": "Inventory",
"itemCategoryId": "00000000-0000-0000-0000-000000000000",
"itemCategoryCode": "",
"blocked": false,
"gtin": "",
"inventory": 0,
"unitPrice": 0,
"priceIncludesTax": false,
"unitCost": 0,
"taxGroupId": "00000000-0000-0000-0000-000000000000",
"taxGroupCode": "",
"baseUnitOfMeasureId": "f957e220-e60b-ef11-9f8e-6045bdc8c192",
"baseUnitOfMeasureCode": "PCS",
"generalProductPostingGroupId": "9240ba25-e60b-ef11-9f8e-6045bdc8c192",
"generalProductPostingGroupCode": "RETAIL",
"inventoryPostingGroupId": "e557e220-e60b-ef11-9f8e-6045bdc8c192",
"inventoryPostingGroupCode": "RESALE",
"lastModifiedDateTime": "2024-06-28T09:18:58.05Z"
}
}
Update Purchase Order
Updates a purchase order object in your Business Central organization. | key: updatePurchaseOrder
{
"data": {
"id": "5d115c9c-44e3-ea11-bb43-000d3a2feca1",
"number": "108001",
"orderDate": "2021-01-01T00:00:00.000Z",
"postingDate": "2021-01-01T00:00:00.000Z",
"dueDate": "2021-01-01T00:00:00.000Z",
"vendorId": "",
"vendorNumber": "20000",
"vendorName": "First Up Consultants",
"payToName": "First Up Consultants",
"payToVendorId": "Evan McIntosh",
"payToVendorNumber": "20000",
"shipToName": "First Up Consultants",
"shipToContact": "Evan McIntosh",
"buyFromAddressLine1": "100 Day Drive",
"buyFromAddressLine2": "",
"buyFromCity": "Chicago",
"buyFromCountry": "US",
"buyFromState": "IL",
"buyFromPostCode": "61236",
"shipToAddressLine1": "100 Day Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"payToAddressLine1": "100 Day Drive",
"payToAddressLine2": "",
"payToCity": "Chicago",
"payToCountry": "US",
"payToState": "IL",
"payToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "04a5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"purchaser": "First Up Consultants",
"requestedReceiptDate": "2021-01-01T00:00:00.000Z",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyReceived": false,
"status": "Draft",
"lastModifiedDateTime": "2021-01-01T00:26:53.793Z",
"shortcutDimension1Code": "",
"shortcutDimension2Code": ""
}
}
Update Purchase Order Line
Updates a purchase order line object in your Business Central organization. | key: updatePurchaseOrderLine
{
"data": {
"id": "1e8cb9c0-44e3-ea11-bb43-000d3a2feca1",
"documentId": "960f5c9c-44e3-ea11-bb43-000d3a2feca1",
"sequence": 10000,
"itemId": "0ea6738a-44e3-ea11-bb43-000d3a2feca1",
"accountId": "93f5638a-55e3-jk22-aa32-211d3a2fdce5",
"lineType": "Item",
"lineObjectNumber": "1996-S",
"description": "ATLANTA Whiteboard, base",
"unitOfMeasureId": "5ca6738a-44e3-ea11-bb43-000d3a2feca1",
"unitOfMeasureCode": "PCS",
"quantity": 12,
"directUnitCost": 1397.3,
"discountAmount": 0,
"discountPercent": 0,
"discountAppliedBeforeTax": false,
"amountExcludingTax": 16767.6,
"taxCode": "FURNITURE",
"taxPercent": 6.00002,
"totalTaxAmount": 1006.06,
"amountIncludingTax": 17773.66,
"invoiceDiscountAllocation": 0,
"netAmount": 16767.6,
"netTaxAmount": 1006.06,
"netAmountIncludingTax": 17773.66,
"expectedReceiptDate": "2020-04-02T00:00:00.000Z",
"receivedQuantity": 0,
"invoicedQuantity": 0,
"invoiceQuantity": 12,
"receiveQuantity": 12,
"itemVariantId": "00000000-0000-0000-0000-000000000000",
"locationId": "00000000-0000-0000-0000-000000000000"
}
}
Update Sales Invoice
Updates a sales invoice object in your Business Central organization. | key: updateSalesInvoice
{
"data": {
"id": "b353895e-5635-ef11-8409-6045bdfedf9a",
"number": "PS-INV103001",
"externalDocumentNumber": "",
"invoiceDate": "2019-01-15",
"postingDate": "2019-01-15",
"dueDate": "2019-01-15",
"customerPurchaseOrderReference": "",
"customerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"customerNumber": "20000",
"customerName": "Trey Research",
"billToCustomerId": "f3a5738a-44e3-ea11-bb43-000d3a2feca1",
"billToCustomerNumber": "20000",
"shipToName": "Trey Research",
"shipToContact": "Helen Ray",
"sellToAddressLine1": "153 Thomas Drive",
"sellToAddressLine2": "",
"sellToCity": "Chicago",
"sellToCountry": "US",
"sellToState": "IL",
"sellToPostCode": "61236",
"shipToAddressLine1": "153 Thomas Drive",
"shipToAddressLine2": "",
"shipToCity": "Chicago",
"shipToCountry": "US",
"shipToState": "IL",
"shipToPostCode": "61236",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"paymentTermsId": "0ba5738a-44e3-ea11-bb43-000d3a2feca1",
"shipmentMethodId": "00000000-0000-0000-0000-000000000000",
"salesperson": "PS",
"discountAmount": 0,
"phoneNumber": "",
"email": "helen.ray@contoso.com"
}
}
Update Sales Order
Updates a sales order object in your Business Central organization. | key: updateSalesOrder
{
"data": {
"id": "54a53ee8-3835-ef11-840b-00224820d4a6",
"number": "S-ORD101010",
"externalDocumentNumber": "",
"orderDate": "2023-09-01",
"postingDate": "2023-09-02",
"customerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"customerNumber": "10000",
"customerName": "Adatum Corporation",
"billToName": "Adatum Corporation",
"billToCustomerId": "7e57e220-e60b-ef11-9f8e-6045bdc8c192",
"billToCustomerNumber": "10000",
"shipToName": "Adatum Corporation",
"shipToContact": "Robert Townes",
"sellToAddressLine1": "Station Road, 21",
"sellToAddressLine2": "",
"sellToCity": "Georgia",
"sellToCountry": "US",
"sellToState": "GA",
"sellToPostCode": "31772",
"billToAddressLine1": "Station Road, 21",
"billToAddressLine2": "",
"billToCity": "Georgia",
"billToCountry": "US",
"billToState": "GA",
"billToPostCode": "31772",
"shipToAddressLine1": "Station Road, 21",
"shipToAddressLine2": "",
"shipToCity": "Georgia",
"shipToCountry": "US",
"shipToState": "GA",
"shipToPostCode": "31772",
"shortcutDimension1Code": "",
"shortcutDimension2Code": "MEDIUM",
"currencyId": "00000000-0000-0000-0000-000000000000",
"currencyCode": "USD",
"pricesIncludeTax": false,
"paymentTermsId": "7e55e220-e60b-ef11-9f8e-6045bdc8c192",
"shipmentMethodId": "0756e220-e60b-ef11-9f8e-6045bdc8c192",
"salesperson": "JO",
"partialShipping": true,
"requestedDeliveryDate": "0001-01-01",
"discountAmount": 0,
"discountAppliedBeforeTax": false,
"totalAmountExcludingTax": 0,
"totalTaxAmount": 0,
"totalAmountIncludingTax": 0,
"fullyShipped": false,
"status": "Draft",
"lastModifiedDateTime": "2024-06-28T10:26:43.957Z",
"phoneNumber": "",
"email": "robert.townes@contoso.com"
}
}
Update Shipment Method
Update a shipment method object in your Business Central organization. | key: updateShipmentMethod
{
"data": {
"id": "be90f4f2-1735-ef11-8409-6045bdfedf9a",
"code": "TEST",
"displayName": "test",
"lastModifiedDateTime": "2024-06-28T06:30:46.263Z"
}
}