Business Central (Preview)

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 Government regions
     -   Azure China regions
Flow Standard All Flow regions except the following:
     -   US Government (GCC)
PowerApps Standard All PowerApps regions except the following:
     -   US Government (GCC)

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Create item

Operation ID:
PostItem

Creates a Dynamics 365 Business Central item

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table
Row
dynamic
Row to insert into the specified table in Dynamics 365 Business Central
Key:
item

Returns

The outputs of this operation are dynamic.

Delete item

Operation ID:
DeleteItem

Deletes a Dynamics 365 Business Central item

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table
Row id
string
Unique identifier of the row to delete
Key:
id

Returns

The outputs of this operation are dynamic.

Execute action

Operation ID:
ExecuteProcedure

Executes a Dynamics 365 Business Central action.

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Action name
string
Name of action
Key:
procedure
Parameters list
dynamic
Input parameters to the action
Key:
parameters

Returns

The outputs of this operation are dynamic.

Get item

Operation ID:
GetItem

Retrieves a Dynamics 365 Business Central item

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table
Row id
string
Unique identifier of the row to retrieve
Key:
id

Returns

The outputs of this operation are dynamic.

Get item types

Operation ID:
GetTables

Retrieves Dynamics 365 Business Central item types

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset

Returns

Body
TablesList

Represents a list of tables.

Update item

Operation ID:
PatchItem

Updates an existing Dynamics 365 Business Central item

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table
Row id
string
Unique identifier of the row to update
Key:
id
Row
dynamic
Row with updated values
Key:
item

Returns

The outputs of this operation are dynamic.

Triggers

When a customer approval is requested

Operation ID:
CreateCustomerApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

First condition
string
Select the field for the first condition
Key:
FirstConditionField
First condition is
string
Enter a value for the first condition
Key:
FirstConditionFieldValue
Second condition
string
Select the field for the second condition
Key:
SecondConditionField
Second condition is
string
Enter a value for the second condition
Key:
SecondConditionFieldValue
Third condition
string
Select the field for the third condition
Key:
ThirdConditionField
Third condition is
string
Enter a value for the third condition
Key:
ThirdConditionFieldValue
Fourth condition
string
Select the field for the fourth condition
Key:
FourthConditionField
Fourth condition is
string
Enter a value for the fourth condition
Key:
FourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When a general journal batch approval is requested

Operation ID:
CreateGeneralJournalBatchApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

First condition
string
Select the field for the first condition
Key:
FirstConditionField
First condition is
string
Enter a value for the first condition
Key:
FirstConditionFieldValue
Second condition
string
Select the field for the second condition
Key:
SecondConditionField
Second condition is
string
Enter a value for the second condition
Key:
SecondConditionFieldValue
Third condition
string
Select the field for the third condition
Key:
ThirdConditionField
Third condition is
string
Enter a value for the third condition
Key:
ThirdConditionFieldValue
Fourth condition
string
Select the field for the fourth condition
Key:
FourthConditionField
Fourth condition is
string
Enter a value for the fourth condition
Key:
FourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When a general journal line approval is requested

Operation ID:
CreateGeneralJournalLineApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

First condition
string
Select the field for the first condition
Key:
FirstConditionField
First condition is
string
Enter a value for the first condition
Key:
FirstConditionFieldValue
Second condition
string
Select the field for the second condition
Key:
SecondConditionField
Second condition is
string
Enter a value for the second condition
Key:
SecondConditionFieldValue
Third condition
string
Select the field for the third condition
Key:
ThirdConditionField
Third condition is
string
Enter a value for the third condition
Key:
ThirdConditionFieldValue
Fourth condition
string
Select the field for the fourth condition
Key:
FourthConditionField
Fourth condition is
string
Enter a value for the fourth condition
Key:
FourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When a purchase document approval is requested

Operation ID:
CreatePurchaseDocumentApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

Header first condition
string
Select the field for the first header condition
Key:
HeaderFirstConditionField
Header first condition is
string
Enter a value for the first header condition
Key:
HeaderFirstConditionFieldValue
Header second condition
string
Select the field for the second header condition
Key:
HeaderSecondConditionField
Header second condition is
string
Enter a value for the second header condition
Key:
HeaderSecondConditionFieldValue
Header third condition
string
Select the field for the third header condition
Key:
HeaderThirdConditionField
Header third condition is
string
Enter a value for the third header condition
Key:
HeaderThirdConditionFieldValue
Header fourth condition
string
Select the field for the fourth header condition
Key:
HeaderFourthConditionField
Header fourth condition is
string
Enter a value for the fourth header condition
Key:
HeaderFourthConditionFieldValue
Line first condition
string
Select the field for the first line condition
Key:
LineFirstConditionField
Line first condition is
string
Enter a value for the first line condition
Key:
LineFirstConditionFieldValue
Line second condition
string
Select the field for the second line condition
Key:
LineSecondConditionField
Line second condition is
string
Enter a value for the second line condition
Key:
LineSecondConditionFieldValue
Line third condition
string
Select the field for the third line condition
Key:
LineThirdConditionField
Line third condition is
string
Enter a value for the third line condition
Key:
LineThirdConditionFieldValue
Line fourth condition
string
Select the field for the fourth line condition
Key:
LineFourthConditionField
Line fourth condition is
string
Enter a value for the fourth line condition
Key:
LineFourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When a record is changed

Operation ID:
GetOnChangedItems

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Key:
$filter
Order By
string
An ODATA orderBy query for specifying the order of entries.
Key:
$orderby
Top Count
integer
Total number of entries to retrieve (default = all).
Key:
$top
Skip Count
integer
The number of entries to skip (default = 0).
Key:
$skip

Returns

The outputs of this operation are dynamic.

When a record is created

Operation ID:
GetOnNewItems

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Key:
$filter
Order By
string
An ODATA orderBy query for specifying the order of entries.
Key:
$orderby
Top Count
integer
Total number of entries to retrieve (default = all).
Key:
$top
Skip Count
integer
The number of entries to skip (default = 0).
Key:
$skip

Returns

The outputs of this operation are dynamic.

When a record is deleted

Operation ID:
GetOnDeletedItems

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Key:
$filter
Order By
string
An ODATA orderBy query for specifying the order of entries.
Key:
$orderby
Top Count
integer
Total number of entries to retrieve (default = all).
Key:
$top
Skip Count
integer
The number of entries to skip (default = 0).
Key:
$skip

Returns

The outputs of this operation are dynamic.

When a record is modified

Operation ID:
GetOnUpdatedItems

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company
Key:
dataset
Table name
string
Name of the Dynamics 365 Business Central table
Key:
table

Optional Parameters

Filter Query
string
An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Key:
$filter
Order By
string
An ODATA orderBy query for specifying the order of entries.
Key:
$orderby
Top Count
integer
Total number of entries to retrieve (default = all).
Key:
$top
Skip Count
integer
The number of entries to skip (default = 0).
Key:
$skip

Returns

The outputs of this operation are dynamic.

When a sales document approval is requested

Operation ID:
CreateSalesDocumentApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

Header first condition
string
Select the field for the first header condition
Key:
HeaderFirstConditionField
Header first condition is
string
Enter a value for the first header condition
Key:
HeaderFirstConditionFieldValue
Header second condition
string
Select the field for the second header condition
Key:
HeaderSecondConditionField
Header second condition is
string
Enter a value for the second header condition
Key:
HeaderSecondConditionFieldValue
Header third condition
string
Select the field for the third header condition
Key:
HeaderThirdConditionField
Header third condition is
string
Enter a value for the third header condition
Key:
HeaderThirdConditionFieldValue
Header fourth condition
string
Select the field for the fourth header condition
Key:
HeaderFourthConditionField
Header fourth condition is
string
Enter a value for the fourth header condition
Key:
HeaderFourthConditionFieldValue
Line first condition
string
Select the field for the first line condition
Key:
LineFirstConditionField
Line first condition is
string
Enter a value for the first line condition
Key:
LineFirstConditionFieldValue
Line second condition
string
Select the field for the second line condition
Key:
LineSecondConditionField
Line second condition is
string
Enter a value for the second line condition
Key:
LineSecondConditionFieldValue
Line third condition
string
Select the field for the third line condition
Key:
LineThirdConditionField
Line third condition is
string
Enter a value for the third line condition
Key:
LineThirdConditionFieldValue
Line fourth condition
string
Select the field for the fourth line condition
Key:
LineFourthConditionField
Line fourth condition is
string
Enter a value for the fourth line condition
Key:
LineFourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When a vendor approval is requested

Operation ID:
CreateVendorApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

First condition
string
Select the field for the first condition
Key:
FirstConditionField
First condition is
string
Enter a value for the first condition
Key:
FirstConditionFieldValue
Second condition
string
Select the field for the second condition
Key:
SecondConditionField
Second condition is
string
Enter a value for the second condition
Key:
SecondConditionFieldValue
Third condition
string
Select the field for the third condition
Key:
ThirdConditionField
Third condition is
string
Enter a value for the third condition
Key:
ThirdConditionFieldValue
Fourth condition
string
Select the field for the fourth condition
Key:
FourthConditionField
Fourth condition is
string
Enter a value for the fourth condition
Key:
FourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

When an item approval is requested

Operation ID:
CreateItemApprovalWebHook

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

Required Parameters

Company name
string
Name of the Dynamics 365 Business Central company.
Key:
dataset

Optional Parameters

First condition
string
Select the field for the first condition
Key:
FirstConditionField
First condition is
string
Enter a value for the first condition
Key:
FirstConditionFieldValue
Second condition
string
Select the field for the second condition
Key:
SecondConditionField
Second condition is
string
Enter a value for the second condition
Key:
SecondConditionFieldValue
Third condition
string
Select the field for the third condition
Key:
ThirdConditionField
Third condition is
string
Enter a value for the third condition
Key:
ThirdConditionFieldValue
Fourth condition
string
Select the field for the fourth condition
Key:
FourthConditionField
Fourth condition is
string
Enter a value for the fourth condition
Key:
FourthConditionFieldValue

Returns

Body
ApprovalWebHookResponse

Model definition for an approval web hook response.

Definitions

ApprovalWebHookResponse

Model definition for an approval web hook response.

Requested By User Email
string
Email address for the user requesting the approval.
Path:
Requested By User Email
Row Id
string
Identifier for the data record.
Path:
Row Id
Workflow Step Id
string
Identifier for the workflow step.
Path:
Workflow Step Id

Table

Represents a table.

DisplayName
string
The display name of the table.
Path:
DisplayName
DynamicProperties
object
Additional table properties provided by the connector to the clients.
Path:
DynamicProperties
Name
string
The name of the table. The name is used at runtime.
Path:
Name

TablesList

Represents a list of tables.

value
array of Table
List of Tables
Path:
value