Skip to main content

Microsoft Dynamics 365 Business Central Connector

Microsoft Dynamics 365 Business Central Microsoft Dynamics 365 Business Central is a comprehensive enterprise resource planning (ERP) solution with capabilities including finance, manufacturing, customer relationship management (CRM), supply chains, analytics, and e-commerce.

This component manages Sales Orders, Customers, Invoices, Vendors, and Shipments in Microsoft Dynamics 365 Business Central.

API Documentation

This component was built using the Microsoft Dynamics v2.0 REST API.

Connections

OAuth 2.0 Authorization Code

Authenticate using OAuth 2.0 Authorization Code

The OAuth 2.0 Authorization Code flow allows users to grant permission for integrations to interact with Business Central on their behalf. For more information, refer to the Microsoft Business Central OAuth Documentation.

Prerequisites

  • A Microsoft Azure account with administrator access
  • Access to the Azure Portal

Register an Application in Azure

  1. Log in to Azure Portal
  2. Select App registrations
  3. Click + New registration
    • Supported account types should be Multi-tenant for customers authenticating with their own Business Central instance, or Single-tenant for authenticating with a specific Business Central instance
    • Under Redirect URI enter https://oauth2.integrations.acme.com/callback
    • Click Register

Configure API Permissions

  1. Under API permissions click + Add a permission
  2. Select Business Central
  3. Check the following permissions:
    • user_impersonation
    • offline_access
    • Financials.ReadWrite.All
  4. Click Add permissions

Create a Client Secret

  1. Under Certificates & secrets click + New client secret
  2. Provide a description and expiration date
  3. Take note of the Value (not the Secret ID) of the client secret

Retrieve the Client ID

  1. Return to the Overview page
  2. Take note of the Application (client) ID

Configure the Connection

Create a connection of type OAuth 2.0 Authorization Code and enter:

  • Web API URL: The Business Central API URL in the format https://api.businesscentral.dynamics.com/v2.0/<TENANT_DOMAIN>/<ENVIRONMENT>
  • Scopes: Use https://api.businesscentral.dynamics.com/.default offline_access
  • Client ID: The Application (client) ID from the Azure app registration
  • Client Secret: The secret value created above

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Web API URLYour organization's Microsoft Business Central Web API URL.
ScopesA space-delimited set of one or more scopes to get the user's permission to access.https://api.businesscentral.dynamics.com/.default offline_access
Client IDThe Client ID from your Azure AD application registration. Found in Azure Portal > App registrations > Overview.
Client SecretThe Client Secret from your Azure AD application registration. Found in Azure Portal > App registrations > Certificates & secrets.

OAuth 2.0 Client Credentials

Authenticate using OAuth 2.0 Client Credentials

The OAuth 2.0 Client Credentials flow allows applications to send requests to Business Central without user interaction. This requires creating an Application User in Business Central. For more information, refer to the Microsoft Business Central OAuth Documentation.

Setting up a client credentials connection is a two-step process:

  1. Create an app in Azure
  2. Create an Application User in Business Central

Prerequisites

  • A Microsoft Azure account with administrator access
  • Access to the Power Platform admin center

Create an App in Microsoft Azure

  1. Log in to Azure Portal
  2. Select App registrations
  3. Click + New registration
    • Supported account types can be Single tenant
    • No Redirect URI is necessary
    • Click Register

Configure API Permissions

  1. Under API permissions click + Add a permission
  2. Select Business Central
  3. Check the following permissions:
    • user_impersonation
    • offline_access
    • Financials.ReadWrite.All
  4. Click Add permissions
  5. Click Grant admin consent for (organization name)

Create a Client Secret

  1. Under Certificates & secrets click + New client secret
  2. Provide a description and expiration date
  3. Take note of the Value (not the Secret ID) of the client secret

Retrieve the Client ID and Token Endpoint

  1. Return to the Overview page and take note of the Application (client) ID
  2. Click Endpoints and take note of the OAuth 2.0 token endpoint (v2)

Add the App as an Application User in Business Central

  1. Log in to Power Platform admin center
  2. Select Environments and choose the Business Central environment
  3. Select S2S Apps
  4. Click + New app user
    • Click + Add an app
    • Choose the app created in Azure Portal (search by client ID)
    • Select the Business Central tenant as the Business unit
    • Under Security Roles select System Administrator
    • Click Create

Configure the Connection

Create a connection of type OAuth 2.0 Client Credentials and enter:

  • Web API URL: The Business Central API URL in the format https://api.businesscentral.dynamics.com/v2.0/<TENANT_DOMAIN>/<ENVIRONMENT>
  • Token URL: The OAuth 2.0 token endpoint (v2) from Azure
  • Scopes: Use https://api.businesscentral.dynamics.com/.default
  • Client ID: The Application (client) ID from the Azure app registration
  • Client Secret: The secret value created above

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

InputCommentsDefault
Web API URLYour organization's Microsoft Business Central Web API URL.
Token URLThe OAuth 2.0 Token URL. Found in Azure Portal > App registrations > Endpoints.
ScopesThis should be your Business Central URL with '/.default' appended to it.https://api.businesscentral.dynamics.com/.default
Client IDThe Client ID generated when you register an app in Azure Portal. Found in App registrations > Overview.
Client Secret ValueThe Client Secret value from Azure Portal. Found in App registrations > Certificates & secrets.

Triggers

Managed Subscription Events

Automatically registers and manages webhook subscriptions for resource changes in Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
ResourceResource to subscribe to.

Manual Webhook

Receive and validate webhook requests from Business Central for manually configured webhooks.

Actions

Create Attachment

Create a new attachment

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Parent IDThe ID of the parent object that the attachment is associated with
File NameThe name of the file
Parent TypeThe type of the parent object

Create Customer

Creates a customer object in Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to create the customer in.
Display NameSpecifies the customer's name.
Customer TypeSpecifies the type of customer.
Address Line 1Specifies the first line of the customer's address.
Address Line 2Specifies the second line of the customer's address.
CitySpecifies the city of the customer's address.
StateSpecifies the state of the customer's address.
CountrySpecifies the country of the customer's address.
Postal CodeSpecifies the postal code of the customer's address.
Phone NumberSpecifies the customer's phone number.
EmailSpecifies the customer's email address.
WebsiteSpecifies the customer's website.
Tax LiableWhen true, the customer is liable for sales tax.false
Tax Area IdSpecifies which tax area the customer belongs to.
Tax Registration NumberSpecifies the customer's tax registration number.
Currency IdSpecifies the currency used by the customer.
Currency CodeSpecifies the currency code used by the customer.
Payment Terms IdSpecifies the payment terms used by the customer.
Shipment Method IdSpecifies the shipment method used by the customer.
Payment Method IdSpecifies the payment method used by the customer.
Actions BlockedSpecifies which transactions with the customer cannot be posted. It can be empty, 'Ship', 'Invoice' or 'All'

Create Event Subscription

Create an Event subscription for Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Notification URLURL to send events of this Subscription to.
ResourceResource to subscribe to.
Allow DuplicatesWhen true, allows more than one webhook per endpoint.false

Create Item

Creates a new item object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
NumberThe number of the item.
Display NameThe display name of the item.

Create Purchase Invoice

Creates a purchase invoice object in Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to create the purchase invoice in.
Vendor NumberSpecifies the vendor's number.
Vendor IDThe unique identifier of the vendor for this invoice.
Invoice DateThe date of the invoice.
Posting DateThe posting date of the invoice.
Due DateThe due date of the invoice.
Vendor Invoice NumberThe vendor's invoice number.
Pay To Vendor IDThe unique identifier of the vendor to pay to.
Pay To Vendor NumberSpecifies the number of the vendor to pay to.
Ship To NameThe name for the ship-to address.
Ship To ContactThe contact name for the ship-to address.
Buy From Address Line 1The first line of the buy-from address.
Buy From Address Line 2The second line of the buy-from address.
Buy From CityThe city of the buy-from address.
Buy From StateThe state of the buy-from address.
Buy From CountryThe country of the buy-from address.
Buy From Post CodeThe postal code of the buy-from address.
Currency IDThe unique identifier of the currency.
Currency CodeThe currency code.
Prices Include TaxSpecifies if prices include tax.false
Discount AmountThe discount amount for the invoice.

Create Purchase Order

Creates a purchase order object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Vendor NumberSpecifies vendor's number.
Ship To Address Line 1The first line of the ship to address.
Ship To NameThe name of the ship to customer.
Currency CodeThe currency code for the sales order.
Order DateThe order date.
Pay To Vendor IDThe unique ID of the vendor to pay to.
Pay To Vendor NumberSpecifies the number of the vendor to pay to.
PurchaserThe purchaser in the purchase order.
Discount AmountThe discount amount.
Additional PropertiesAdditional 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.
Debug RequestEnabling this flag will log out the current request.false

Create Purchase Order Line

Creates a purchase order line object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Document IDThe ID of the parent purchase order line.
Item IDThe ID of the item in the purchase order line.
Account IDThe id of the account that the purchase order line is related to.
Line TypeThe type of the purchase order line.
Line Object NumberThe number of the object (account or item) of the purchase order line.
DescriptionSpecifies the description of the purchase order line.
QuantityThe quantity of the item in the purchase order line.
Direct Unit CostThe direct cost per unit.
Additional PropertiesAdditional 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.
Debug RequestEnabling this flag will log out the current request.false

Create Sales Invoice

Creates a sales invoice object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Customer IDThe unique identifier of the customer.
Customer NumberThe customer number for the sales invoice.
Bill To Customer IDThe customer ID for the invoice to the customer.
Ship To NameThe name of the ship to customer.
Sell To Address Line 1The first line of the sell to address.
Ship To Address Line 1The first line of the ship to address.
Currency CodeThe currency code for the sales invoice.
Customer Email AddressThe email address for the sales invoice.
Additional PropertiesAdditional 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.

Create Sales Order

Creates a sales order object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Customer IDThe unique identifier of the customer.
Customer NumberThe customer number for the sales order.
Bill To Customer IDThe customer ID for the bill to customer.
Ship To NameThe name of the ship to customer.
Sell To Address Line 1The first line of the sell to address.
Ship To Address Line 1The first line of the ship to address.
Currency CodeThe currency code for the sales order.
Customer Email AddressThe email address for the sales order.
Additional PropertiesAdditional 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.

Create Shipment Method

Create a new shipment method

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Shipment Method NameThe display name for the shipment method.
Shipment CodeThe unique code for the shipment method.

Create Vendor

Creates a vendor object in Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to create the vendor in.
Display NameSpecifies the vendor's name.
Address Line 1Specifies the first line of the vendor's address.
Address Line 2Specifies the second line of the vendor's address.
CitySpecifies the city of the vendor's address.
StateSpecifies the state of the vendor's address.
CountrySpecifies the country of the vendor's address.
Postal CodeSpecifies the postal code of the vendor's address.
Phone NumberSpecifies the vendor's phone number.
EmailSpecifies the vendor's email address.
WebsiteSpecifies the vendor's website.
Tax LiableWhen true, the vendor is liable for sales tax.false
Tax Registration NumberSpecifies the vendor's tax registration number.
Currency IDSpecifies the currency used by the vendor.
Currency CodeSpecifies the currency code used by the vendor.
IRS 1099 CodeSpecifies the IRS 1099 code for the vendor.
Payment Terms IDSpecifies the payment terms used by the vendor.
Payment Method IDSpecifies the payment method used by the vendor.
BlockedSpecifies which transactions with the vendor cannot be posted. It can be empty, 'Payment', or 'All'.

Delete All Instance Subscriptions

Delete all subscriptions pointed at this instance.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.

Delete Attachment

Delete an attachment object in Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Attachment IDThe ID of the attachment to update.

Delete Customer

Deletes a customer object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Customer IDThe unique identifier of the customer.

Delete Item

Deletes an item object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Item IdThe id of the item.

Delete Purchase Invoice

Deletes a purchase invoice object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Invoice IDThe unique identifier of the purchase invoice.

Delete Purchase Order

Deletes a purchase order object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Order IDThe unique ID of the purchase order to delete.
Debug RequestEnabling this flag will log out the current request.false

Delete Purchase Order Line

Deletes a purchase order line object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Order Line IDThe unique ID of the purchase order line to delete.
Debug RequestEnabling this flag will log out the current request.false

Delete Sales Invoice

Deletes a sales invoice object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Invoice IDThe unique identifier of the sales invoice object.

Delete Sales Order

Deletes a sales order object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Order IDThe unique identifier of the sales order.

Delete Shipment Method

Deletes a shipment method object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Shipment Method IdSpecifies the shipment method used by the customer.

Delete Subscription

Delete existing subscription for Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Subscription IDSubscription ID to manage.
EtagEtag value for the subscription to delete.

Delete Vendor

Deletes a vendor object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Vendor IDThe unique identifier of the vendor.

Get Account

Retrieve the properties and relationships of an account object in Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Account IDThe ID of the account you want to retrieve data from.

Get Attachment

Gets an attachment object

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Parent IDThe ID of the parent object that the attachment is associated with
Parent TypeThe type of the parent object

Get Company Information

Get information about a company in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.

Get Customer

Retrieve the properties and relationships of a customer object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Customer IDThe unique identifier of the customer.

Get General Ledger Entry

Retrieve the properties and relationships of a general ledger entry object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
General Ledger Entry IDThe unique identifier of the general ledger entry.

Get Item

Retrieves an item object from your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Item IdThe id of the item.

Get Item Ledger Entry

Retrieve the properties and relationships of an item ledger entry object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Item Ledger Entry IDThe unique identifier of the item ledger entry.

Get Purchase Invoice

Retrieve the properties and relationships of a purchase invoice object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Invoice IDThe unique identifier of the purchase invoice.

Get Purchase Order

Retrieves a purchase order object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Order IDThe unique ID of the purchase order to retrieve.
Debug RequestEnabling this flag will log out the current request.false

Get Purchase Order Line

Retrieves a purchase order line object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Order Line IDThe unique ID of the purchase order line to retrieve.
Debug RequestEnabling this flag will log out the current request.false

Get Purchase Receipt

Retrieves a purchase receipt object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Receipt IDThe unique identifier of the purchase receipt.
Debug RequestEnabling this flag will log out the current request.false

Get Purchase Receipt Line

Retrieves a purchase receipt line object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Receipt Line IDThe unique identifier of the purchase receipt line.
Debug RequestEnabling this flag will log out the current request.false

Get Sales Invoice

Retrieves a sales invoice object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Invoice IDThe unique identifier of the sales invoice object.

Get Sales Order

Retrieves a sales order object in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Order IDThe unique identifier of the sales order.

Get Sales Shipment

Retrieves a sales shipment object from your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sale Shipment IDThe ID of the sale shipment you want to retrieve.

Get Sales Shipment Line Item

Gets a sales shipment line object

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Shipment Line IDThe ID of the sales shipment line object.

Get Shipment Method

Retrieves a shipment method object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Shipment Method IdSpecifies the shipment method used by the customer.

Get Vendor

Retrieve the properties and relationships of a vendor object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Vendor IDThe unique identifier of the vendor.

List Accounts

Retrieve the properties and relationships of all account objects in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Companies

Retrieve the properties and relationships of companies in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Customers

Retrieve the properties and relationships of all customer objects in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List General Ledger Entries

Retrieve all general ledger entries in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Item Ledger Entries

Retrieve all item ledger entries in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Items

List all item objects from your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Debug RequestEnabling this flag will log out the current request.false

List Purchase Invoices

Retrieve all purchase invoices in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Purchase Order Lines

List all purchase order line objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Order IDThe unique ID of the purchase order.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Debug RequestEnabling this flag will log out the current request.false

List Purchase Orders

List all purchase order objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Debug RequestEnabling this flag will log out the current request.false

List Purchase Receipt Lines

List all purchase receipt line objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Debug RequestEnabling this flag will log out the current request.false

List Purchase Receipts

List all purchase receipt objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Debug RequestEnabling this flag will log out the current request.false

List Sales Invoices

List all sales invoices objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Sales Orders

List all sales orders objects in your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Sales Shipment Line Items

Lists all sales shipment line objects in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.
Company IDThe ID of the company you want to interact with.

List Sales Shipments

List all sales shipments objects from your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

List Subscriptions

List all subscriptions for Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Show Instance WebhooksWhen true, shows only subscriptions for this Instance's webhooks.false

List Vendors

Retrieve all vendors in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
FilterFilters results (rows).
SelectFilters properties (columns).
ExpandRetrieves related resources.
Order ByOrders results.
TopSets the page size of results.
SkipIndexes into a result set. Also used by some APIs to implement paging and can be used together with $top to manually page results.
CountWhen true, retrieves the total count of matching resources.false
SearchReturns results based on search criteria.
FormatReturns the results in the specified media format.
Skip TokenRetrieves the next page of results from result sets that span multiple pages.

Post Purchase Invoice

Posts a purchase invoice in your Business Central organization. This will finalize the invoice and create ledger entries.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Purchase Invoice IDThe unique identifier of the purchase invoice.

Raw Request

Send a raw HTTP request to Microsoft's Business Central API

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
URLInput the path only (/companies(companyId), the base URL along with the version is already included
MethodThe HTTP method to use.
DataThe HTTP body payload to send to the URL.
Form DataThe Form Data to be sent as a multipart form upload.
File DataFile Data to be sent as a multipart form upload.
File Data File NamesFile names to apply to the file data inputs. Keys must match the file data keys above.
Query ParameterA 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.
HeaderA list of headers to send with the request.
Response TypeThe type of data you expect in the response. You can request json, text, or binary data.json
TimeoutThe maximum time that a client will await a response to its request
Debug RequestEnable this to log the request and responsefalse
Retry Delay (ms)The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.0
Retry On All ErrorsIf 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.false
Max Retry CountThe maximum number of retries to attempt. Specify 0 for no retries.0
Use Exponential BackoffSpecifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.false

Update Attachment

Update the attachment content in Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Attachment IDThe ID of the attachment to update.
Attachment ContentThe content of the attachment.

Update Company Information

Update the properties of a company information object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Company Information IDThe unique identifier of the company information object.
Display NameThe name of the company as it should be displayed to users.
Address Line 1The first line of the company's address.
Address Line 2The second line of the company's address.
CityThe city where the company is located.
StateThe state where the company is located.
CountryThe country where the company is located.
Postal CodeThe postal code of the company's address.
Phone NumberThe company's phone number.
Fax NumberThe company's fax number.
EmailThe company's email address.
WebsiteThe company's website URL.
Tax Registration NumberThe company's tax registration number.
Currency CodeThe currency code used by the company.
Current Fiscal Year Start DateThe start date of the company's current fiscal year.
IndustryThe industry in which the company operates.

Update Customer

Update a customer object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company to which the customer belongs.
Customer IDThe unique identifier of the customer.
Display NameSpecifies the customer's name.
Customer TypeSpecifies the type of customer.
Address Line 1Specifies the first line of the customer's address.
Address Line 2Specifies the second line of the customer's address.
CitySpecifies the city of the customer's address.
StateSpecifies the state of the customer's address.
CountrySpecifies the country of the customer's address.
Postal CodeSpecifies the postal code of the customer's address.
Phone NumberSpecifies the customer's phone number.
EmailSpecifies the customer's email address.
WebsiteSpecifies the customer's website.
Tax Area IdSpecifies which tax area the customer belongs to.
Tax Registration NumberSpecifies the customer's tax registration number.
Currency IdSpecifies the currency used by the customer.
Currency CodeSpecifies the currency code used by the customer.
Payment Terms IdSpecifies the payment terms used by the customer.
Shipment Method IdSpecifies the shipment method used by the customer.
Payment Method IdSpecifies the payment method used by the customer.
Actions BlockedSpecifies which transactions with the customer cannot be posted. It can be empty, 'Ship', 'Invoice' or 'All'
Tax LiableWhen true, the customer is liable for sales tax.

Update Event Subscription

Update existing Event subscription for Microsoft Business Central.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Subscription IDSubscription ID to manage.
EtagEtag value for the subscription to delete.
Notification URLURL to send events of this Subscription to.
ResourceResource to subscribe to.

Update Item

Updates an item object from your Business Central Organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Item IdThe id of the item.
Display NameThe display name of the item.
TypeThe type of the item.
Item Category IdThe id of the item category in the item.
Item Category CodeThe code of the item category in the item.
BlockedSpecifies that entries cannot be posted to the item. True indicates account is blocked and posting is not allowed.false
Global Trade Item NumberThe Global Trade Item Number (GTIN) of the item.
Unit PriceThe unit price of the item.
Unit CostThe unit cost of the item.
Price Includes TaxSpecifies whether the price includes tax.false
Tax Group IdThe id of the tax group in the item.
Tax Group CodeThe code of the tax group in the item.
Base Unit Of Measure CodeThe item's base unit of measure code.
Base Unit Of Measure IdSpecifies the ID of the unit of measure.

Update Purchase Invoice

Update a purchase invoice object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company to which the purchase invoice belongs.
Purchase Invoice IDThe unique identifier of the purchase invoice.
Vendor IDThe unique identifier of the vendor for this invoice.
Vendor NumberSpecifies the vendor's number.
Invoice DateThe date of the invoice.
Posting DateThe posting date of the invoice.
Due DateThe due date of the invoice.
Vendor Invoice NumberThe vendor's invoice number.
Pay To Vendor IDThe unique identifier of the vendor to pay to.
Pay To Vendor NumberSpecifies the number of the vendor to pay to.
Ship To NameThe name for the ship-to address.
Ship To ContactThe contact name for the ship-to address.
Buy From Address Line 1The first line of the buy-from address.
Buy From Address Line 2The second line of the buy-from address.
Buy From CityThe city of the buy-from address.
Buy From StateThe state of the buy-from address.
Buy From CountryThe country of the buy-from address.
Buy From Post CodeThe postal code of the buy-from address.
Currency IDThe unique identifier of the currency.
Currency CodeThe currency code.
Prices Include TaxSpecifies if prices include tax.
Discount AmountThe discount amount for the invoice.

Update Purchase Order

Updates a purchase order object in your Business Central organization.

InputCommentsDefault
Purchase Order IDThe ID of the purchase order to update.
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Vendor NumberSpecifies vendor's number.
Ship To Address Line 1The first line of the ship to address.
Ship To NameThe name of the ship to customer.
Currency CodeThe currency code for the sales order.
Order DateThe order date.
Pay To Vendor IDThe unique ID of the vendor to pay to.
Pay To Vendor NumberSpecifies the number of the vendor to pay to.
PurchaserThe purchaser in the purchase order.
Discount AmountThe discount amount.
Additional PropertiesAdditional 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.
Debug RequestEnabling this flag will log out the current request.false

Update Purchase Order Line

Updates a purchase order line object in your Business Central organization.

InputCommentsDefault
Purchase Order Line IDThe ID of the purchase order line to update.
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Document IDThe ID of the parent purchase order line.
Item IDThe ID of the item in the purchase order line.
Account IDThe id of the account that the purchase order line is related to.
Line TypeThe type of the purchase order line.
Line Object NumberThe number of the object (account or item) of the purchase order line.
DescriptionSpecifies the description of the purchase order line.
QuantityThe quantity of the item in the purchase order line.
Direct Unit CostThe direct cost per unit.
Additional PropertiesAdditional 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.
Debug RequestEnabling this flag will log out the current request.false

Update Sales Invoice

Updates a sales invoice object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Invoice IDThe unique identifier of the sales invoice object.
Customer IDThe unique identifier of the customer.
Customer NumberThe customer number for the sales invoice.
Bill To Customer IDThe customer ID for the invoice to the customer.
Ship To NameThe name of the ship to customer.
Sell To Address Line 1The first line of the sell to address.
Ship To Address Line 1The first line of the ship to address.
Currency CodeThe currency code for the sales invoice.
Customer Email AddressThe email address for the sales invoice.
Additional PropertiesAdditional 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.

Update Sales Order

Updates a sales order object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Sales Order IDThe unique identifier of the sales order.
Customer IDThe unique identifier of the customer.
Customer NumberThe customer number for the sales order.
Bill To Customer IDThe customer ID for the bill to customer.
Ship To NameThe name of the ship to customer.
Sell To Address Line 1The first line of the sell to address.
Ship To Address Line 1The first line of the ship to address.
Currency CodeThe currency code for the sales order.
Customer Email AddressThe email address for the sales order.
Additional PropertiesAdditional 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.

Update Shipment Method

Update a shipment method object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company you want to interact with.
Shipment Method IdSpecifies the shipment method used by the customer.
Shipment Method NameThe display name for the shipment method.
Shipment CodeThe unique code for the shipment method.

Update Vendor

Update a vendor object in your Business Central organization.

InputCommentsDefault
ConnectionThe Microsoft Business Central connection to use.
Company IDThe ID of the company to which the vendor belongs.
Vendor IDThe unique identifier of the vendor.
Display NameSpecifies the vendor's name.
Address Line 1Specifies the first line of the vendor's address.
Address Line 2Specifies the second line of the vendor's address.
CitySpecifies the city of the vendor's address.
StateSpecifies the state of the vendor's address.
CountrySpecifies the country of the vendor's address.
Postal CodeSpecifies the postal code of the vendor's address.
Phone NumberSpecifies the vendor's phone number.
EmailSpecifies the vendor's email address.
WebsiteSpecifies the vendor's website.
Tax LiableWhen true, the vendor is liable for sales tax.
Tax Registration NumberSpecifies the vendor's tax registration number.
Currency IDSpecifies the currency used by the vendor.
Currency CodeSpecifies the currency code used by the vendor.
IRS 1099 CodeSpecifies the IRS 1099 code for the vendor.
Payment Terms IDSpecifies the payment terms used by the vendor.
Payment Method IDSpecifies the payment method used by the vendor.
BlockedSpecifies which transactions with the vendor cannot be posted. It can be empty, 'Payment', or 'All'.