Business Central (Preview)

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
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Connector Metadata
Publisher Microsoft

Throttling Limits

Name Calls Renewal Period
API calls per connection10060 seconds

Actions

Create record

Creates a Dynamics 365 Business Central record
Delete record

Deletes a Dynamics 365 Business Central record
Execute action

Executes a Dynamics 365 Business Central action.
Get record

Retrieves a Dynamics 365 Business Central record
Get record types

Retrieves Dynamics 365 Business Central record types
Update record

Updates an existing Dynamics 365 Business Central record

Create record

Operation ID:
PostItemV2

Creates a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
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

Operation ID:
DeleteItemV2

Deletes a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
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

Execute action

Operation ID:
ExecuteProcedureV2

Executes a Dynamics 365 Business Central action.

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
Action name
 procedure True string

Name of action
Parameters list
 parameters True dynamic

Input parameters to the action

Returns

The outputs of this operation are dynamic.

Get record

Operation ID:
GetItemV2

Retrieves a Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
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 record types

Operation ID:
GetTablesV2

Retrieves Dynamics 365 Business Central record types

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company

Returns

Represents a list of tables.

Body
TablesList

Update record

Operation ID:
PatchItemV2

Updates an existing Dynamics 365 Business Central record

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
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

When a customer approval is requested

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

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

Triggers a flow when a general journal line approval request occurs in Dynamics 365 Business Central.
When a purchase document approval is requested

Triggers a flow when a purchase document approval request occurs in Dynamics 365 Business Central.
When a record is changed

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

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

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

Triggers a flow when a record is modified in Dynamics 365 Business Central
When a sales document approval is requested

Triggers a flow when a sales document approval request occurs in Dynamics 365 Business Central.
When a vendor approval is requested

Triggers a flow when a vendor approval request occurs in Dynamics 365 Business Central.
When an item approval is requested

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

When a customer approval is requested

Operation ID:
CreateCustomerApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When a general journal batch approval is requested

Operation ID:
CreateGeneralJournalBatchApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When a general journal line approval is requested

Operation ID:
CreateGeneralJournalLineApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When a purchase document approval is requested

Operation ID:
CreatePurchaseDocumentApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When a record is changed

Operation ID:
CreateOnChangedItemsSubscriptionV2

Triggers a flow when a record is changed in Dynamics 365 Business Central

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
Table name
 table True string

Name of the Dynamics 365 Business Central table

Returns

Represents a wrapper object for batch trigger response

Body
TriggerBatchResponse[IdResponse]

When a record is created

Operation ID:
CreateOnNewItemsSubscriptionV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
Table name
 table True string

Name of the Dynamics 365 Business Central table

Returns

Represents a wrapper object for batch trigger response

Body
TriggerBatchResponse[IdResponse]

When a record is deleted

Operation ID:
CreateOnDeletedItemsSubscriptionV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
Table name
 table True string

Name of the Dynamics 365 Business Central table

Returns

Represents a wrapper object for batch trigger response

Body
TriggerBatchResponse[IdResponse]

When a record is modified

Operation ID:
CreateOnUpdatedItemsSubscriptionV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of the Dynamics 365 Business Central company
Table name
 table True string

Name of the Dynamics 365 Business Central table

Returns

Represents a wrapper object for batch trigger response

Body
TriggerBatchResponse[IdResponse]

When a sales document approval is requested

Operation ID:
CreateSalesDocumentApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When a vendor approval is requested

Operation ID:
CreateVendorApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

When an item approval is requested

Operation ID:
CreateItemApprovalWebHookV2

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

Parameters

Name Key Required Type Description
Environment name
 environment True string

Name of the Dynamics 365 Business Central environment
Company name
 dataset True string

Name of 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

Model definition for an approval web hook response.

Body
ApprovalWebHookResponse

Definitions

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

IdResponse

A response whose sole purpose is to return an item ID.

Name Path Type Description
Row id
 Row id string

Gets and sets the identifier for the data record.

ApprovalWebHookResponse

Model definition for an approval web hook response.

Name Path Type Description
Workflow Step Id
 Workflow Step Id string

Identifier for the workflow step.
Requested By User Email
 Requested By User Email string

Email address for the user requesting the approval.
Row Id
 Row Id string

Identifier for the data record.

Table

Represents a table.

Name Path Type Description
Name
 Name string

The name of the table. The name is used at runtime.
DisplayName
 DisplayName string

The display name of the table.
DynamicProperties
 DynamicProperties object

Additional table properties provided by the connector to the clients.

TablesList

Represents a list of tables.

Name Path Type Description
value
 value array of Table

List of Tables