Skip to main content

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-central

Description

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:

  1. Create an "App" in Azure
  2. Create an "Application User" in Business Central

Create an app in Microsoft Azure

  1. Log in to Azure Portal
  2. Select App registrations
  3. Click + New registration
  • Supported account types can be Single tenant
  • No Redirect URI is necessary
  • Click Register
  1. Under API permissions click +Add a permission
  • Select Business Central
  • Check the following permissions
  • user_impersonation
  • offline_access
  • Financials.ReadWrite.All
  • Click Add permissions
  1. Under API permissions click Grant admin concent for (your org)
  2. 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.
  1. Returning to the Overview page, take note of Application (client) ID
  2. 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

  1. Log in to Power Platform admin center
  2. Select Environments and choose your Business Central Environments
  3. Select S2S Apps
  4. 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.
InputDefaultNotesExample
Client ID
string
/ Required
clientId
Generated when you register an app in Azure portal
 
Client secret value
password
/ Required
clientSecret
Generated when you register an app in Azure portal
 
Scopes
string
/ Required
scopes
https://api.businesscentral.dynamics.com/.default
This should be your Business Central URL with '/.default' appened to it
https://api.businesscentral.dynamics.com/.default
Token URL
string
/ Required
tokenUrl
This can be found by visiting your app in Azure portal and selecting 'Endpoints'
https://login.microsoftonline.com/00000000-0000-0000-0000-000000000000/oauth2/v2.0/token
Web API URL
string
/ Required
webApiUrl
Your organization's Microsoft Business Central Web API URL.
https://api.businesscentral.dynamics.com/v2.0/<TENANT_DOMAIN>/<ENVIRONMENT>

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

  1. Log in to Azure Portal
  2. Select App registrations
  3. 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
  1. Under API permissions click +Add a permission
  • Select Business Central
  • Check the following permissions
  • user_impersonation
  • offline_access
  • Financials.ReadWrite.All
  • Click Add permissions
  1. 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.
  1. 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.
InputDefaultNotesExample
Authorize URL
string
/ Required
Hidden Field
authorizeUrl
https://login.microsoftonline.com/organizations/oauth2/v2.0/authorize
The OAuth 2.0 Authorization URL for Microsoft Business Central
 
Client ID
string
/ Required
clientId
 
 
Client Secret
password
/ Required
clientSecret
 
 
Scopes
string
scopes
https://api.businesscentral.dynamics.com/.default offline_access
A space-delimited set of one or more scopes to get the user's permission to access.
https://api.businesscentral.dynamics.com/.default offline_access
Token URL
string
/ Required
Hidden Field
tokenUrl
https://login.microsoftonline.com/organizations/oauth2/v2.0/token
The OAuth 2.0 Token URL for Microsoft Business central
 
Web API URL
string
/ Required
webApiUrl
Your organization's Microsoft Business Central Web API URL.
https://api.businesscentral.dynamics.com/v2.0/<TENANT_DOMAIN>/<ENVIRONMENT>

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

InputNotes
Connection
connection
/ Required
connection
 

Select Customers

A picklist of customer objects in your Business Central organization. | key: listCustomers | type: picklist

InputNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 

Select Items

A picklist of item objects in your Business Central organization. | key: listItems | type: picklist

InputNotesExample
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 

Select Sales Invoices

A picklist of sales invoices objects in your Business Central organization. | key: listSalesInvoices | type: picklist

InputNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 

Select Sales Orders

A picklist of sales orders objects in your Business Central organization. | key: listSalesOrders | type: picklist

InputNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 

Select Sales Shipments

A picklist of sales shipment objects in your Business Central organization. | key: listSalesShipment | type: picklist

InputNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 

Actions

Create Attachment

Create a new attachment | key: createAttachment

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
File Name
string
/ Required
fileName
The name of the file
example.pdf
Parent ID
string
/ Required
parentId
The ID of the parent object that the attachment is associated with
0a077d18-45e3-ea11-bb43-000d3a2feca1
Parent Type
string
/ Required
parentType
The type of the parent object
contact

{
"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

InputDefaultNotesExample
Address Line 1
string
/ Required
addressLine1
Specifies the first line of the customer's address.
192 Market Square
Address Line 2
string
addressLine2
Specifies the second line of the customer's address.
192 Market Square
Actions Blocked
string
blocked
Specifies which transactions with the customer cannot be posted.It can be empty, 'Ship', 'Invoice' or 'All'
Ship
City
string
/ Required
city
Specifies the city of the customer's address.
Atlanta
Company ID
string
/ Required
companyId
The ID of the company you want to create the customer in.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Country
string
/ Required
country
Specifies the country of the customer's address.
US
Currency Code
string
/ Required
currencyCode
Specifies the currency code used by the customer.
USD
Currency Id
string
/ Required
currencyId
Specifies the currency used by the customer.
00000000-0000-0000-0000-000000000000
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Display Name
string
/ Required
displayName
Specifies the customer's name.
Adatum Corporation
Email
string
/ Required
email
Specifies the customer's email address.
robert.townes@contoso.com
Payment Method Id
string
/ Required
paymentMethodId
Specifies the payment method used by the customer.
3b196a90-44e3-ea11-bb43-000d3a2feca1
Payment Terms Id
string
/ Required
paymentTermsId
Specifies the payment terms used by the customer.
04a5738a-44e3-ea11-bb43-000d3a2feca1
Phone Number
string
phoneNumber
Specifies the customer's phone number.
+1 555-555-5555
Postal Code
string
/ Required
postalCode
Specifies the postal code of the customer's address.
31772
Shipment Method Id
string
/ Required
shipmentMethodId
Specifies the shipment method used by the customer.
00000000-0000-0000-0000-000000000000
State
string
/ Required
state
Specifies the state of the customer's address.
GA
Tax Area Id
string
/ Required
taxAreaId
Specifies which tax area the customer belongs to.
90196a90-44e3-ea11-bb43-000d3a2feca1
Tax Liable
boolean
/ Required
taxLiable
false
specifies if the customer or vendor is liable for sales tax. Set to true if the customer is tax liable.
 
Tax Registration Number
string
taxRegistrationNumber
Specifies the customer's tax registration number.
 
Customer Type
string
/ Required
type
Specifies the type of customer.
Company
Website
string
website
Specifies the customer's website.
www.sample.com

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Display Name
string
/ Required
displayName
The display name of the item.
ATHENS Desk
Number
string
/ Required
number
The number of the item.
1896-S

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales order.
USD
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Discount Amount
string
discountAmount
The discount amount.
0.10
Order Date
string
orderDate
The order date.
2022-01-01
Pay To Vendor ID
string
payToVendorId
The unique ID of the vendor to pay to.
00000000-0000-0000-0000-000000000000
Pay To Vendor Number
string
payToVendorNumber
Specifies the number of the vendor to pay to.
10000
Purchaser
string
purchaser
The purchaser in the purchase order.
John Doe
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address.
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer.
John Doe
Vendor Number
string
/ Required
vendorNumber
Specifies vendor's number.
10000

{
"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

InputDefaultNotesExample
Account ID
string
accountId
The id of the account that the purchase order line is related to.
00000000-0000-0000-0000-000000000000
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Description
string
description
Specifies the description of the purchase order line.
ATLANTA Whiteboard, base
Direct Unit Cost
string
directUnitCost
The direct cost per unit.
1397.3
Document ID
string
/ Required
documentId
The ID of the parent purchase order line.
00000000-0000-0000-0000-000000000000
Item ID
string
itemId
The ID of the item in the purchase order line.
00000000-0000-0000-0000-000000000000
Line Object Number
string
lineObjectNumber
The number of the object (account or item) of the purchase order line.
1996-S
Line Type
string
lineType
The type of the purchase order line.
Item
Quantity
string
quantity
The quantity of the item in the purchase order line.
12

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Bill To Customer ID
string
billToCustomerId
The customer ID for the invoice to the customer
12345
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales invoice
USD
Customer ID
string
/ Required
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Customer Number
string
customerNumber
The customer number for the sales invoice
10000
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Customer Email Address
string
email
The email address for the sales invoice
robert.jr@sample.cm
Sell To Address Line 1
string
sellToAddressLine1
The first line of the sell to address
123 Main St
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer
John Doe

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Bill To Customer ID
string
billToCustomerId
The customer ID for the bill to customer.
12345
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales order.
USD
Customer ID
string
/ Required
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Customer Number
string
customerNumber
The customer number for the sales order.
10000
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Customer Email Address
string
email
The email address for the sales order.
robert.jr@sample.cm
Sell To Address Line 1
string
sellToAddressLine1
The first line of the sell to address.
123 Main St
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address.
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer.
John Doe

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Shipment Code
string
/ Required
shipmentCode
 
UPS
Shipment Method Name
string
/ Required
shipmentMethodName
 
Fedex

{
"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

InputDefaultNotesExample
Attachment ID
string
/ Required
attachmentId
The ID of the attachment to update.
25b8238e-f034-ef11-840b-002248241214
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"data": {
"message": "Success"
}
}

Delete Customer

Deletes a customer object in your Business Central organization. | key: deleteCustomer

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Customer ID
string
/ Required
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"data": {
"message": "Success"
}
}

Delete Item

Deletes an item object in your Business Central Organization. | key: deleteItem

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Item Id
string
/ Required
itemId
The id of the item.
e21a6a90-44e3-ea11-bb43-000d3a2feca1

{
"data": {
"message": "Success"
}
}

Delete Purchase Order

Deletes a purchase order object in your Business Central Organization. | key: deletePurchaseOrder

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Order ID
string
/ Required
purchaseOrderId
The unique ID of the purchase order to delete.
00000000-0000-0000-0000-000000000000

{
"data": {
"message": "Success"
}
}

Delete Purchase Order Line

Deletes a purchase order line object in your Business Central Organization. | key: deletePurchaseOrderLine

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Order Line ID
string
/ Required
purchaseOrderLineId
The unique ID of the purchase order line to delete.
00000000-0000-0000-0000-000000000000

{
"data": {
"message": "Success"
}
}

Delete Sales Invoice

Deletes a sales invoice object in your Business Central Organization. | key: deleteSalesInvoice

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Invoice ID
string
/ Required
salesInvoiceId
The unique identifier of the sales invoice object.
0ba5738a-44e3-ea11-bb43-000d3a2feca1

{
"data": {
"message": "Success"
}
}

Delete Sales Order

Deletes a sales order object in your Business Central Organization. | key: deleteSalesOrder

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Order ID
string
/ Required
salesOrderId
The unique identifier of the sales order.
f1678e37-e50b-ef11-9f8e-6045bdc8c192

{
"data": {
"message": "Success"
}
}

Delete Shipment Method

Deletes a shipment method object in your Business Central organization. | key: deleteShipmentMethod

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Shipment Method Id
string
/ Required
shipmentMethodId
Specifies the shipment method used by the customer.
00000000-0000-0000-0000-000000000000

{
"data": {
"message": "Success"
}
}

Get Account

Retrieve the properties and relationships of an account object in Microsoft Business Central. | key: getAccount

InputDefaultNotesExample
Account ID
string
/ Required
accountId
The ID of the account you want to retrieve data from.
someAccountId
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Parent ID
string
/ Required
parentId
The ID of the parent object that the attachment is associated with
0a077d18-45e3-ea11-bb43-000d3a2feca1
Parent Type
string
/ Required
parentType
The type of the parent object
contact

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Customer ID
string
/ Required
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Item Id
string
/ Required
itemId
The id of the item.
e21a6a90-44e3-ea11-bb43-000d3a2feca1

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Order ID
string
/ Required
purchaseOrderId
The unique ID of the purchase order to retrieve.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Order Line ID
string
/ Required
purchaseOrderLineId
The unique ID of the purchase order line to retrieve.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Receipt ID
string
/ Required
purchaseReceiptId
The unique identifier of the purchase receipt.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Receipt Line ID
string
/ Required
purchaseReceiptLineId
The unique identifier of the purchase receipt line.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sale Shipment ID
string
/ Required
saleShipmentId
The ID of the sale shipment you want to retrieve.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Invoice ID
string
/ Required
salesInvoiceId
The unique identifier of the sales invoice object.
0ba5738a-44e3-ea11-bb43-000d3a2feca1

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Order ID
string
/ Required
salesOrderId
The unique identifier of the sales order.
f1678e37-e50b-ef11-9f8e-6045bdc8c192

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Sales Shipment Line ID
string
/ Required
salesShipmentLineId
The ID of the sales shipment line object.
be90f4f2-1735-ef11-8409-6045bdfedf9a

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Shipment Method Id
string
/ Required
shipmentMethodId
Specifies the shipment method used by the customer.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

List Purchase Order Lines

List all purchase order line objects in your Business Central Organization. | key: listPurchaseOrderLines

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Purchase Order ID
string
/ Required
purchaseOrderId
The unique ID of the purchase order.
00000000-0000-0000-0000-000000000000

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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"
}
]
}
}

List Sales Orders

List all sales orders objects in your Business Central Organization. | key: listSalesOrders

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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"
}
]
}
}

List Sales Shipment Line Items

Lists all sales shipment line objects in your Business Central organization. | key: listSalesShipmentLines

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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"
}
]
}
}

List Sales Shipments

List all sales shipments objects from your Business Central organization. | key: listSaleShipments

InputDefaultNotesExample
Count
boolean
$count
false
Retrieves the total count of matching resources.
 
Expand
string
$expand
Retrieves related resources.
members
Filter
string
$filter
Filters results (rows).
startswith(givenName,'J')
Format
string
$format
Returns the results in the specified media format.
json
Order By
string
$orderBy
Orders results.
displayName desc
Search
string
$search
Returns results based on search criteria.
pizza
Select
string
$select
Filters properties (columns).
givenName,surname
Skip
string
$skip
Indexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
10
Skip Token
string
$skipToken
Retrieves the next page of results from result sets that span multiple pages.
X%274453707402000100000017...
Top
string
$top
Sets the page size of results.
10
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Connection
connection
/ Required
connection
 
 
 
Data
string
data
The HTTP body payload to send to the URL.
{"exampleKey": "Example Data"}
Debug Request
boolean
debugRequest
false
Enable this to log the request and response
 
File Data
string
Key Value List
fileData
File Data to be sent as a multipart form upload.
[{key: "example.txt", value: "My File Contents"}]
File Data File Names
string
Key Value List
fileDataFileNames
File names to apply to the file data inputs. Keys must match the file data keys above.
 
Form Data
string
Key Value List
formData
The Form Data to be sent as a multipart form upload.
[{"key": "Example Key", "value": new Buffer("Hello World")}]
Header
string
Key Value List
headers
A list of headers to send with the request.
User-Agent: curl/7.64.1
Max Retry Count
string
maxRetries
0
The maximum number of retries to attempt. Specify 0 for no retries.
 
Method
string
/ Required
method
The HTTP method to use.
 
Query Parameter
string
Key Value List
queryParams
A list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1&key2=value2.
 
Response Type
string
/ Required
responseType
json
The type of data you expect in the response. You can request json, text, or binary data.
 
Retry On All Errors
boolean
retryAllErrors
false
If true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors.
 
Retry Delay (ms)
string
retryDelayMS
0
The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.
 
Timeout
string
timeout
The maximum time that a client will await a response to its request
2000
URL
string
/ Required
url
Input the path only (/companies(companyId), the base URL along with the version is already included
/sobjects/Account
Use Exponential Backoff
boolean
useExponentialBackoff
false
Specifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.
 

Update Attachment

Update the attachment content in Business Central. | key: updateAttachment

InputDefaultNotesExample
Attachment Content
string
/ Required
attachmentContent
The content of the attachment.
<binary data>
Attachment ID
string
/ Required
attachmentId
The ID of the attachment to update.
25b8238e-f034-ef11-840b-002248241214
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"data": {
"message": "Success"
}
}

Update Company Information

Update the properties of a company information object in your Business Central organization. | key: updateCompanyInformation

InputDefaultNotesExample
Address Line 1
string
companyAddressLine1
The first line of the company's address.
7122 South Ashford Street
Address Line 2
string
companyAddressLine2
The second line of the company's address.
Westminster
City
string
companyCity
The city where the company is located.
Atlanta
Country
string
companyCountry
The country where the company is located.
US
Currency Code
string
companyCurrencyCode
The currency code used by the company.
USD
Current Fiscal Year Start Date
string
companyCurrentFiscalYearStartDate
The start date of the company's current fiscal year.
2021-01-01
Display Name
string
companyDisplayName
The name of the company as it should be displayed to users.
CRONUS USA, Inc.
Email
string
companyEmail
The company's email address.
example@gmail.com
Fax Number
string
companyFaxNumber
The company's fax number.
+1 425 555 0101
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Industry
string
companyIndustry
The industry in which the company operates.
yourIndustryHere
Company Information ID
string
/ Required
companyInformationId
The unique identifier of the company information object.
f80b7995-6869-4958-ac60-25e4fcdeeada
Phone Number
string
companyPhoneNumber
The company's phone number.
+1 425 555 0100
Postal Code
string
companyPostalCode
The postal code of the company's address.
31772
State
string
companyState
The state where the company is located.
GA
Tax Registration Number
string
companyTaxRegistrationNumber
The company's tax registration number.
f80b7995-6869-4958-ac60-25e4fcdeeada
Website
string
companyWebsite
The company's website URL.
www.sample.com
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 

{
"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

InputDefaultNotesExample
Address Line 1
string
addressLine1
Specifies the first line of the customer's address.
192 Market Square
Address Line 2
string
addressLine2
Specifies the second line of the customer's address.
192 Market Square
Actions Blocked
string
blocked
Specifies which transactions with the customer cannot be posted.It can be empty, 'Ship', 'Invoice' or 'All'
Ship
City
string
city
Specifies the city of the customer's address.
Atlanta
Company ID
string
/ Required
companyId
The ID of the company to which the customer belongs.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Country
string
country
Specifies the country of the customer's address.
US
Currency Code
string
currencyCode
Specifies the currency code used by the customer.
USD
Currency Id
string
currencyId
Specifies the currency used by the customer.
00000000-0000-0000-0000-000000000000
Customer ID
string
/ Required
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Customer Type
string
customerType
Specifies the type of customer.
Company
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Display Name
string
displayName
Specifies the customer's name.
Adatum Corporation
Email
string
email
Specifies the customer's email address.
robert.townes@contoso.com
Payment Method Id
string
paymentMethodId
Specifies the payment method used by the customer.
3b196a90-44e3-ea11-bb43-000d3a2feca1
Payment Terms Id
string
paymentTermsId
Specifies the payment terms used by the customer.
04a5738a-44e3-ea11-bb43-000d3a2feca1
Phone Number
string
phoneNumber
Specifies the customer's phone number.
+1 555-555-5555
Postal Code
string
postalCode
Specifies the postal code of the customer's address.
31772
Shipment Method Id
string
shipmentMethodId
Specifies the shipment method used by the customer.
00000000-0000-0000-0000-000000000000
State
string
state
Specifies the state of the customer's address.
GA
Tax Area Id
string
taxAreaId
Specifies which tax area the customer belongs to.
90196a90-44e3-ea11-bb43-000d3a2feca1
Tax Liable
string
taxLiable
specifies if the customer or vendor is liable for sales tax. Set to true if the customer is tax liable.
 
Tax Registration Number
string
taxRegistrationNumber
Specifies the customer's tax registration number.
 
Website
string
website
Specifies the customer's website.
www.sample.com

{
"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

InputDefaultNotesExample
Base Unit Of Measure Code
string
baseUnitOfMeasureCode
The item's base unit of measure code.
PCS
Base Unit Of Measure Id
string
baseUnitOfMeasureId
Specifies the ID of the unit of measure.
5ca6738a-44e3-ea11-bb43-000d3a2feca1
Blocked
string
blocked
false
Specifies that entries cannot be posted to the item. True indicates account is blocked and posting is not allowed.
 
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Display Name
string
displayName
The display name of the item.
ATHENS Desk
Global Trade Item Number
string
gtin
The Global Trade Item Number (GTIN) of the item.
1234567890123
Item Category Code
string
itemCategoryCode
The code of the item category in the item.
TABLE
Item Category Id
string
itemCategoryId
The id of the item category in the item.
e21a6a90-44e3-ea11-bb43-000d3a2feca1
Item Id
string
/ Required
itemId
The id of the item.
e21a6a90-44e3-ea11-bb43-000d3a2feca1
Price Includes Tax
string
priceIncludesTax
false
Specifies whether the price includes tax.
 
Tax Group Code
string
taxGroupCode
The code of the tax group in the item.
FURNITURE
Tax Group Id
string
taxGroupId
The id of the tax group in the item.
9f196a90-44e3-ea11-bb43-000d3a2feca1
Type
string
type
The type of the item.
Inventory
Unit Cost
string
unitCost
The unit cost of the item.
780.7
Unit Price
string
unitPrice
The unit price of the item.
1000.8

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales order.
USD
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Discount Amount
string
discountAmount
The discount amount.
0.10
Order Date
string
orderDate
The order date.
2022-01-01
Pay To Vendor ID
string
payToVendorId
The unique ID of the vendor to pay to.
00000000-0000-0000-0000-000000000000
Pay To Vendor Number
string
payToVendorNumber
Specifies the number of the vendor to pay to.
10000
Purchase Order ID
string
/ Required
purchaseOrderId
The ID of the purchase order to update.
00000000-0000-0000-0000-000000000000
Purchaser
string
purchaser
The purchaser in the purchase order.
John Doe
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address.
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer.
John Doe
Vendor Number
string
vendorNumber
Specifies vendor's number.
10000

{
"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

InputDefaultNotesExample
Account ID
string
accountId
The id of the account that the purchase order line is related to.
00000000-0000-0000-0000-000000000000
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Description
string
description
Specifies the description of the purchase order line.
ATLANTA Whiteboard, base
Direct Unit Cost
string
directUnitCost
The direct cost per unit.
1397.3
Document ID
string
documentId
The ID of the parent purchase order line.
00000000-0000-0000-0000-000000000000
Item ID
string
itemId
The ID of the item in the purchase order line.
00000000-0000-0000-0000-000000000000
Line Object Number
string
lineObjectNumber
The number of the object (account or item) of the purchase order line.
1996-S
Line Type
string
lineType
The type of the purchase order line.
Item
Purchase Order Line ID
string
/ Required
purchaseOrderLineId
The ID of the purchase order line to update.
00000000-0000-0000-0000-000000000000
Quantity
string
quantity
The quantity of the item in the purchase order line.
12

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Bill To Customer ID
string
billToCustomerId
The customer ID for the invoice to the customer
12345
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales invoice
USD
Customer ID
string
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Customer Number
string
customerNumber
The customer number for the sales invoice
10000
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Customer Email Address
string
email
The email address for the sales invoice
robert.jr@sample.cm
Sales Invoice ID
string
/ Required
salesInvoiceId
The unique identifier of the sales invoice object.
0ba5738a-44e3-ea11-bb43-000d3a2feca1
Sell To Address Line 1
string
sellToAddressLine1
The first line of the sell to address
123 Main St
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer
John Doe

{
"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

InputDefaultNotesExample
Additional Properties
code
additionalProperties
Additional properties to include in the request body. In case of supplying a property that is already defined as an input, the input value will be used.
Bill To Customer ID
string
billToCustomerId
The customer ID for the bill to customer.
12345
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Currency Code
string
currencyCode
The currency code for the sales order.
USD
Customer ID
string
customerId
The unique identifier of the customer.
8ba01a7a-5734-ef11-8409-7c1e5213ec0e
Customer Number
string
customerNumber
The customer number for the sales order.
10000
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Customer Email Address
string
email
The email address for the sales order.
robert.jr@sample.cm
Sales Order ID
string
/ Required
salesOrderId
The unique identifier of the sales order.
f1678e37-e50b-ef11-9f8e-6045bdc8c192
Sell To Address Line 1
string
sellToAddressLine1
The first line of the sell to address.
123 Main St
Ship To Address Line 1
string
shipToAddressLine1
The first line of the ship to address.
123 Main St
Ship To Name
string
shipToName
The name of the ship to customer.
John Doe

{
"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

InputDefaultNotesExample
Company ID
string
/ Required
companyId
The ID of the company you want to interact with.
00000000-0000-0000-0000-000000000000
Connection
connection
/ Required
connection
 
 
 
Debug Request
boolean
debug
false
Enabling this flag will log out the current request.
 
Shipment Code
string
shipmentCode
 
UPS
Shipment Method Id
string
/ Required
shipmentMethodId
Specifies the shipment method used by the customer.
00000000-0000-0000-0000-000000000000
Shipment Method Name
string
shipmentMethodName
 
Fedex

{
"data": {
"id": "be90f4f2-1735-ef11-8409-6045bdfedf9a",
"code": "TEST",
"displayName": "test",
"lastModifiedDateTime": "2024-06-28T06:30:46.263Z"
}
}