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 v2.0 REST API
Connections
OAuth 2.0 Client Credentials
The OAuth 2.0 client credentials flow allows your user to create an Application User to send requests to Business Central on their behalf. Refer to the following Documentation for more information. Setting up a client credentials connection is a two-step process:
- Create an "App" in Azure
- Create an "Application User" in Business Central
Create an app in Microsoft Azure
- Log in to Azure Portal
- Select App registrations
- Click + New registration
- Supported account types can be Single tenant
- No Redirect URI is necessary
- Click Register
- Under API permissions click +Add a permission
- Select Business Central
- Check the following permissions
- user_impersonation
- offline_access
- Financials.ReadWrite.All
- Click Add permissions
- Under API permissions click Grant admin concent for (your org)
- Under Certificates & secrets click + New client secret
- Give your certificate a description and expiration date
- Take note of the value (not the Secret ID) of the client secret.
- Returning to the Overview page, take note of Application (client) ID
- From the Overview page, click Endpoints and take note of the OAuth 2.0 token endpoint (v2)
You will use the Secret Value, Client ID and Token Endpoint in a moment.
Add the app as an App User to Business Central
- Log in to Power Platform admin center
- Select Environments and choose your Business Central Environments
- Select S2S Apps
- Click +New app user
- Click +Add an app
- Choose the app you created in Azure portal (above). You can search for your app by entering the client ID you noted.
- Select your Business Central tenant as your Business unit
- Under Security Roles select System Administrator
- Click Create
Configure the connection in Prismatic
Within Prismatic, create a connection of type MS Business Central OAuth 2.0 Client Credentials.
- Enter the Token Endpoint you noted as your Token URL.
- Enter the Client ID and Secret Value you noted above.
Input | Default | Notes | Example |
---|---|---|---|
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
- Log in to Azure Portal
- Select App registrations
- Click + New registration
- Supported account types should be Multi-tenant if you intend for customers to authenticate with their own Business Central instance, or Single-tenant if you intend to authenticate with your own Business Central instance.
- Under Redirect URI enter https://oauth2.prismatic.io/callback
- Click Register
- Under API permissions click +Add a permission
- Select Business Central
- Check the following permissions
- user_impersonation
- offline_access
- Financials.ReadWrite.All
- Click Add permissions
- Under Certificates & secrets click + New client secret
- Give your certificate a description and expiration date
- Take note of the value (not the Secret ID) of the client secret.
- Returning to the Overview page, take note of Application (client) ID
Within Prismatic, create a connection of type OAuth 2.0 Auth Code.
- Enter the Client ID and Secret Value you noted above.
Input | Default | Notes | Example |
---|---|---|---|
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
Input | Notes |
---|---|
Connection connection / Required connection |
Select Customers
A picklist of customer objects in your Business Central organization. | key: listCustomers | type: picklist
Input | Notes | Example |
---|---|---|
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
Input | Notes | Example |
---|---|---|
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
Input | Notes | Example |
---|---|---|
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
Input | Notes | Example |
---|---|---|
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
Input | Notes | Example |
---|---|---|
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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Attachment
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Customer
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Item
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Purchase Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Purchase Order Line
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Sales Invoice
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Sales Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Create Shipment Method
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Delete Attachment
{
"data": {
"message": "Success"
}
}
Delete Customer
Deletes a customer object in your Business Central organization. | key: deleteCustomer
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Delete Customer
{
"data": {
"message": "Success"
}
}
Delete Item
Deletes an item object in your Business Central Organization. | key: deleteItem
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Item
{
"data": {
"message": "Success"
}
}
Delete Purchase Order
Deletes a purchase order object in your Business Central Organization. | key: deletePurchaseOrder
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Purchase Order
{
"data": {
"message": "Success"
}
}
Delete Purchase Order Line
Deletes a purchase order line object in your Business Central Organization. | key: deletePurchaseOrderLine
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Purchase Order Line
{
"data": {
"message": "Success"
}
}
Delete Sales Invoice
Deletes a sales invoice object in your Business Central Organization. | key: deleteSalesInvoice
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Sales Invoice
{
"data": {
"message": "Success"
}
}
Delete Sales Order
Deletes a sales order object in your Business Central Organization. | key: deleteSalesOrder
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Sales Order
{
"data": {
"message": "Success"
}
}
Delete Shipment Method
Deletes a shipment method object in your Business Central organization. | key: deleteShipmentMethod
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Delete Shipment Method
{
"data": {
"message": "Success"
}
}
Get Account
Retrieve the properties and relationships of an account object in Microsoft Business Central. | key: getAccount
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Get Account
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Attachment
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Get Company Information
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Get Customer
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Item
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Purchase Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Purchase Order Line
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Purchase Receipt
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Purchase Receipt Line
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Sale Shipment
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Sales Invoice
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Sales Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Sales Shipment Line Item
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Get Shipment Method
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Accounts
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Companies
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Customers
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for List Purchase Order Lines
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Purchase Orders
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Purchase Receipt Lines
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Purchase Receipts
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Sales Invoices
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Sales Orders
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Sales Shipment Line Items
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for List Sales Shipments
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Update Attachment
{
"data": {
"message": "Success"
}
}
Update Company Information
Update the properties of a company information object in your Business Central organization. | key: updateCompanyInformation
Input | Default | Notes | Example |
---|---|---|---|
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. |
Example Payload for Update Company Information
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Customer
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Item
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Purchase Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Purchase Order Line
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Sales Invoice
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Sales Order
{
"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
Input | Default | Notes | Example |
---|---|---|---|
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 |
Example Payload for Update Shipment Method
{
"data": {
"id": "be90f4f2-1735-ef11-8409-6045bdfedf9a",
"code": "TEST",
"displayName": "test",
"lastModifiedDateTime": "2024-06-28T06:30:46.263Z"
}
}