Dynamics 365 Business Central

Dynamics 365 Business Central is a business management solution for small and mid-sized organizations that automates and streamlines business processes and helps you manage your business.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Microsoft
URL https://dynamics.microsoft.com/en-us/business-central/overview/
Connector Metadata
Publisher Microsoft
Publisher Microsoft
Website https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/powerplatform/automate-workflows
Privacy policy https://www.microsoft.com/trust-center/privacy

The Microsoft Dynamics 365 Business Central connector makes it possible for users to run Power Automate flows inside Business Central, and admins can build powerful Power Apps or flows that uses Business Central data.

Limitations

For all actions that interact with records (such as "Create record (V3)" and "Get record (V3)"), the size of the record must be under 8 MB. Otherwise, you will get the error "The response from the Business Central service is too large".

The Business Central APIs provided by Microsoft are all under this limit, but APIs provided by partners might not be.

Manual trigger "For a selected record (V3)"

When you create an instant flow using the manual trigger "For a selected record (V3)", it will show up in the Automate menu when you use Business Central in a browser. This way, you can run a flow in the context of a specific Business Central record.

Learn more at aka.ms/bcautomate.

Parameters

You can set any parameter in the trigger definition to limit where the flow will be visible in Business Central; all parameters are optional. Filtering on a company without filtering on an environment is not supported.

Name Key Required Type Description
Environment name (optional) bcenvironment False string The name of the Business Central environment where this flow can be run (leave it empty to let the flow run in any environment).
Company name (optional) company False string The name of the Business Central company where this flow can be run (leave it empty to let the flow run in any company).
Page or table (optional) context False string The Business Central page or table that this flow will run against, such as "TABLE18" or "PAGE21,PAGE22" (see also https://aka.ms/bcautomate).

Returns

Name Path Type Description
Environment name EnvironmentName string The name of the Business Central environment where the flow was triggered.
Company CompanyId string The name of the Business Central company where this flow can be run (leave it empty to let the flow run in any company).
Table Id TableId string The Business Central table that stores the record that triggered the flow.
System Id SystemId string The System ID of the Business Central record that triggered the flow.
Page Id PageId string The Business Central page where the flow was triggered.
Web Client URL WebClientUrl string The URL to reach the record that triggered the flow from the browser.

Throttling Limits

Name Calls Renewal Period
API calls per connection 300 60 seconds

Actions

Create record (V3)

Creates a Dynamics 365 Business Central record

Delete record (V3)

Deletes a Dynamics 365 Business Central record

Find records (V3)

Retrieves Dynamics 365 Business Central records of a certain type (for example, customers or items)

Get adaptive card (V3)

Retrieves an adaptive card for a Dynamics 365 Business Central url.

Get an image, file or document (V3)

Retrieves the content of an image, file or document in Dynamics 365 Business Central.

Get record (V3)

Retrieves a Dynamics 365 Business Central record

Get url (V3)

Generates a URL to access the specified Dynamics 365 Business Central record in the browser.

List companies (V3)

Retrieves all companies available in the specified Dynamics 365 Business Central environment.

Run action (V3)

Runs a Dynamics 365 Business Central action.

Update an image, file or document (V3)

Updates the content of an image, file or document in Dynamics 365 Business Central.

Update record (V3)

Updates an existing Dynamics 365 Business Central record

Create record (V3)

Creates a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table

Row
item True dynamic

Row to insert into the specified table in Dynamics 365 Business Central

Returns

The outputs of this operation are dynamic.

Delete record (V3)

Deletes a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table

Row id
id True string

Unique identifier of the row to delete

Find records (V3)

Retrieves Dynamics 365 Business Central records of a certain type (for example, customers or items)

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route)

Table name
table True string

Name of the Dynamics 365 Business Central table

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By
$orderby string

An ODATA orderBy query for specifying the order of entries.

Top Count
$top integer

Total number of entries to retrieve (default without pagination = 1000).

Skip Count
$skip integer

The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

Get adaptive card (V3)

Retrieves an adaptive card for a Dynamics 365 Business Central url.

Parameters

Name Key Required Type Description
Url
targeturl True string

Business Central web client url to get the adaptive card for. You can generate a URL using the "Get URL (V3)" action.

Target App
targetapp True string

The app where you want to use the adaptive card.

Returns

A response containing a Dynamics 365 Business Central adaptive card

Get an image, file or document (V3)

Retrieves the content of an image, file or document in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Path
blobnavigationpath True string

The OData path to the image, file or document, not including the IDs (use the picker for a better experience).

pathParameters
pathParameters True dynamic

Returns

response
binary

Get record (V3)

Retrieves a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table

Row id
id True string

Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get url (V3)

Generates a URL to access the specified Dynamics 365 Business Central record in the browser.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

Page
page True string

The Business Central page to retrieve the url for, such as "21" or "22".

Row id
id True string

Unique identifier of the row to retrieve the url for.

Returns

A response containing a URL to Dynamics 365 Business Central

List companies (V3)

Retrieves all companies available in the specified Dynamics 365 Business Central environment.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Returns

The list of companies.

Run action (V3)

Runs a Dynamics 365 Business Central action.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Action name
procedure True string

Name of the OData procedure

Parameters list
parameters True dynamic

Input parameters for the procedure

Returns

The outputs of this operation are dynamic.

Update an image, file or document (V3)

Updates the content of an image, file or document in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Path
blobnavigationpath True string

The OData path to the image, file or document, not including the IDs (use the picker for a better experience).

pathParameters
pathParameters True dynamic

Update record (V3)

Updates an existing Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Triggers

For a selected record (V3)

Triggers a flow for a selected Dynamics 365 Business Central record. (Available only for Power Automate.)

When a business event occurs (V3) (Preview)

Triggers a flow when a certain business event occurs in Dynamics 365 Business Central.

When a customer approval is requested (V3)

Triggers a flow when a customer approval request occurs in Dynamics 365 Business Central.

When a general journal batch approval is requested (V3)

Triggers a flow when a general journal batch approval request occurs in Dynamics 365 Business Central.

When a general journal line approval is requested (V3)

Triggers a flow when a general journal line approval request occurs in Dynamics 365 Business Central.

When a purchase document approval is requested (V3)

Triggers a flow when a purchase document approval request occurs in Dynamics 365 Business Central.

When a record is changed (V3)

Triggers a flow when a record is created, modified or deleted in Dynamics 365 Business Central.

When a record is created (V3)

Triggers a flow when a record is created in Dynamics 365 Business Central.

When a record is deleted (V3)

Triggers a flow when a record is deleted in Dynamics 365 Business Central.

When a record is modified (V3)

Triggers a flow when a record is modified in Dynamics 365 Business Central.

When a sales document approval is requested (V3)

Triggers a flow when a sales document approval request occurs in Dynamics 365 Business Central.

When a vendor approval is requested (V3)

Triggers a flow when a vendor approval request occurs in Dynamics 365 Business Central.

When an item approval is requested (V3)

Triggers a flow when an item approval request occurs in Dynamics 365 Business Central.

For a selected record (V3)

Triggers a flow for a selected Dynamics 365 Business Central record. (Available only for Power Automate.)

Returns

The outputs of this operation are dynamic.

When a business event occurs (V3) (Preview)

Triggers a flow when a certain business event occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Event
businessevent True string

The business event in Dynamics 365 Business Central.

Company (optional)
company string

The Dynamics 365 Business Central company. Leave this empty to subscribe to business events from all companies.

Returns

The outputs of this operation are dynamic.

When a customer approval is requested (V3)

Triggers a flow when a customer approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

First condition
FirstConditionField string

Select the field for the first condition

First condition is
FirstConditionFieldValue string

Enter a value for the first condition

Second condition
SecondConditionField string

Select the field for the second condition

Second condition is
SecondConditionFieldValue string

Enter a value for the second condition

Third condition
ThirdConditionField string

Select the field for the third condition

Third condition is
ThirdConditionFieldValue string

Enter a value for the third condition

Fourth condition
FourthConditionField string

Select the field for the fourth condition

Fourth condition is
FourthConditionFieldValue string

Enter a value for the fourth condition

Returns

The response which includes information about an approval workflow webhook.

When a general journal batch approval is requested (V3)

Triggers a flow when a general journal batch approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

First condition
FirstConditionField string

Select the field for the first condition

First condition is
FirstConditionFieldValue string

Enter a value for the first condition

Second condition
SecondConditionField string

Select the field for the second condition

Second condition is
SecondConditionFieldValue string

Enter a value for the second condition

Third condition
ThirdConditionField string

Select the field for the third condition

Third condition is
ThirdConditionFieldValue string

Enter a value for the third condition

Fourth condition
FourthConditionField string

Select the field for the fourth condition

Fourth condition is
FourthConditionFieldValue string

Enter a value for the fourth condition

Returns

The response which includes information about an approval workflow webhook.

When a general journal line approval is requested (V3)

Triggers a flow when a general journal line approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

First condition
FirstConditionField string

Select the field for the first condition

First condition is
FirstConditionFieldValue string

Enter a value for the first condition

Second condition
SecondConditionField string

Select the field for the second condition

Second condition is
SecondConditionFieldValue string

Enter a value for the second condition

Third condition
ThirdConditionField string

Select the field for the third condition

Third condition is
ThirdConditionFieldValue string

Enter a value for the third condition

Fourth condition
FourthConditionField string

Select the field for the fourth condition

Fourth condition is
FourthConditionFieldValue string

Enter a value for the fourth condition

Returns

The response which includes information about an approval workflow webhook.

When a purchase document approval is requested (V3)

Triggers a flow when a purchase document approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

Header first condition
HeaderFirstConditionField string

Select the field for the first header condition

Header first condition is
HeaderFirstConditionFieldValue string

Enter a value for the first header condition

Header second condition
HeaderSecondConditionField string

Select the field for the second header condition

Header second condition is
HeaderSecondConditionFieldValue string

Enter a value for the second header condition

Header third condition
HeaderThirdConditionField string

Select the field for the third header condition

Header third condition is
HeaderThirdConditionFieldValue string

Enter a value for the third header condition

Header fourth condition
HeaderFourthConditionField string

Select the field for the fourth header condition

Header fourth condition is
HeaderFourthConditionFieldValue string

Enter a value for the fourth header condition

Line first condition
LineFirstConditionField string

Select the field for the first line condition

Line first condition is
LineFirstConditionFieldValue string

Enter a value for the first line condition

Line second condition
LineSecondConditionField string

Select the field for the second line condition

Line second condition is
LineSecondConditionFieldValue string

Enter a value for the second line condition

Line third condition
LineThirdConditionField string

Select the field for the third line condition

Line third condition is
LineThirdConditionFieldValue string

Enter a value for the third line condition

Line fourth condition
LineFourthConditionField string

Select the field for the fourth line condition

Line fourth condition is
LineFourthConditionFieldValue string

Enter a value for the fourth line condition

Returns

The response which includes information about an approval workflow webhook.

When a record is changed (V3)

Triggers a flow when a record is created, modified or deleted in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table.

Returns

Represents a wrapper object for batch trigger response

When a record is created (V3)

Triggers a flow when a record is created in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table.

Returns

Represents a wrapper object for batch trigger response

When a record is deleted (V3)

Triggers a flow when a record is deleted in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table.

Returns

Represents a wrapper object for batch trigger response

When a record is modified (V3)

Triggers a flow when a record is modified in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

API category
dataset True string

Name of the Dynamics 365 Business Central API category (also called API route).

Table name
table True string

Name of the Dynamics 365 Business Central table.

Returns

Represents a wrapper object for batch trigger response

When a sales document approval is requested (V3)

Triggers a flow when a sales document approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

Header first condition
HeaderFirstConditionField string

Select the field for the first header condition

Header first condition is
HeaderFirstConditionFieldValue string

Enter a value for the first header condition

Header second condition
HeaderSecondConditionField string

Select the field for the second header condition

Header second condition is
HeaderSecondConditionFieldValue string

Enter a value for the second header condition

Header third condition
HeaderThirdConditionField string

Select the field for the third header condition

Header third condition is
HeaderThirdConditionFieldValue string

Enter a value for the third header condition

Header fourth condition
HeaderFourthConditionField string

Select the field for the fourth header condition

Header fourth condition is
HeaderFourthConditionFieldValue string

Enter a value for the fourth header condition

Line first condition
LineFirstConditionField string

Select the field for the first line condition

Line first condition is
LineFirstConditionFieldValue string

Enter a value for the first line condition

Line second condition
LineSecondConditionField string

Select the field for the second line condition

Line second condition is
LineSecondConditionFieldValue string

Enter a value for the second line condition

Line third condition
LineThirdConditionField string

Select the field for the third line condition

Line third condition is
LineThirdConditionFieldValue string

Enter a value for the third line condition

Line fourth condition
LineFourthConditionField string

Select the field for the fourth line condition

Line fourth condition is
LineFourthConditionFieldValue string

Enter a value for the fourth line condition

Returns

The response which includes information about an approval workflow webhook.

When a vendor approval is requested (V3)

Triggers a flow when a vendor approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

First condition
FirstConditionField string

Select the field for the first condition

First condition is
FirstConditionFieldValue string

Enter a value for the first condition

Second condition
SecondConditionField string

Select the field for the second condition

Second condition is
SecondConditionFieldValue string

Enter a value for the second condition

Third condition
ThirdConditionField string

Select the field for the third condition

Third condition is
ThirdConditionFieldValue string

Enter a value for the third condition

Fourth condition
FourthConditionField string

Select the field for the fourth condition

Fourth condition is
FourthConditionFieldValue string

Enter a value for the fourth condition

Returns

The response which includes information about an approval workflow webhook.

When an item approval is requested (V3)

Triggers a flow when an item approval request occurs in Dynamics 365 Business Central.

Parameters

Name Key Required Type Description
Environment
bcenvironment True string

The Dynamics 365 Business Central environment.

Company
company True string

The Dynamics 365 Business Central company.

First condition
FirstConditionField string

Select the field for the first condition

First condition is
FirstConditionFieldValue string

Enter a value for the first condition

Second condition
SecondConditionField string

Select the field for the second condition

Second condition is
SecondConditionFieldValue string

Enter a value for the second condition

Third condition
ThirdConditionField string

Select the field for the third condition

Third condition is
ThirdConditionFieldValue string

Enter a value for the third condition

Fourth condition
FourthConditionField string

Select the field for the fourth condition

Fourth condition is
FourthConditionFieldValue string

Enter a value for the fourth condition

Returns

The response which includes information about an approval workflow webhook.

Definitions

ApprovalWebHookResponse

The response which includes information about an approval workflow webhook.

Name Path Type Description
Row Id
Row Id string

Identifier for the data record.

Environment Name
Environment Name string

The name of the environment where the record is.

Company Id
Company Id string

The ID of the company where the record is.

Workflow Step Id
Workflow Step Id string

System ID of the Business Central workflow step.

Requested By User Email
Requested By User Email string

Email address for the user requesting the approval.

Company

Company data contract

Name Path Type Description
Id
Id string

The ID of the Business Central company.

Display name
DisplayName string

The name of the Business Central company.

datasets
datasets array of DataSet

Datasets contained in the company.

CompanyList

The list of companies.

Name Path Type Description
value
value array of Company

Gets or sets the list of companies.

DataSet

Dataset

Name Path Type Description
Name
Name string

Dataset name

DisplayName
DisplayName string

Dataset display name

query
query array of PassThroughNativeQuery

Pass-through Native Queries

GetAdaptiveCardV3Response

A response containing a Dynamics 365 Business Central adaptive card

Name Path Type Description
Adaptive card
AdaptiveCardJsonString string

The content of the adaptive card in JSON string format.

GetUrlV3Response

A response containing a URL to Dynamics 365 Business Central

Name Path Type Description
Web Client URL
WebClientUrl string

The Dynamics 365 Business Central web client url.

IdResponse

The response which includes the Business Central system ID of the record.

Name Path Type Description
Environment Name
Environment Name string

The name of the environment where the record is (only supported for V3 actions and triggers).

Company Id
Company Id string

The ID of the company where the record is (only supported for V3 actions and triggers).

Row Id
Row Id string

The system ID of the Business Central record.

PassThroughNativeQuery

static schema for pass-through native query execution

Name Path Type Description
Language
Language string

Query language

TriggerBatchResponse[IdResponse]

Represents a wrapper object for batch trigger response

Name Path Type Description
value
value array of IdResponse

A list of the response objects

binary

This is the basic data type 'binary'.