Business Central (on-premises) (Preview)
Dynamics 365 Business Central (on-premises) 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 |
| Contact | |
|---|---|
| Name | Microsoft |
| URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Website | https://dynamics.microsoft.com/business-central/overview/ |
Creating a connection
The connector supports the following authentication types:
| Default | Required parameters for creating connection. | All regions |
Default
Applicable: All regions
Required parameters for creating connection.
| Name | Type | Description |
|---|---|---|
| Web service URL | string | Web service URL |
| Username | securestring | Username |
| Password | securestring | Password |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Create item |
Creates a Dynamics 365 Business Central (on-premises) item |
| Delete item |
Deletes a Dynamics 365 Business Central (on-premises) item |
| Get item |
Retrieves a Dynamics 365 Business Central (on-premises) item |
| Get item types |
Retrieves Dynamics 365 Business Central (on-premises) item types |
| Update item |
Updates an existing Dynamics 365 Business Central (on-premises) item |
Create item
Creates a Dynamics 365 Business Central (on-premises) item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Company name
|
dataset | True | string |
Name of the Dynamics 365 Business Central (on-premises) company |
|
Table name
|
table | True | string |
Name of the Dynamics 365 Business Central (on-premises) table |
|
Row
|
item | True | dynamic |
Row to insert into the specified table in Dynamics 365 Business Central (on-premises) |
Returns
Delete item
Deletes a Dynamics 365 Business Central (on-premises) item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Company name
|
dataset | True | string |
Name of the Dynamics 365 Business Central (on-premises) company |
|
Table name
|
table | True | string |
Name of the Dynamics 365 Business Central (on-premises) table |
|
Row id
|
id | True | string |
Unique identifier of the row to delete |
Get item
Retrieves a Dynamics 365 Business Central (on-premises) item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Company name
|
dataset | True | string |
Name of the Dynamics 365 Business Central (on-premises) company |
|
Table name
|
table | True | string |
Name of the Dynamics 365 Business Central (on-premises) table |
|
Row id
|
id | True | string |
Unique identifier of the row to retrieve |
Returns
Get item types
Retrieves Dynamics 365 Business Central (on-premises) item types
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Company name
|
dataset | True | string |
Name of the Dynamics 365 Business Central (on-premises) company |
Returns
Represents a list of tables.
- Body
- TablesList
Update item
Updates an existing Dynamics 365 Business Central (on-premises) item
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Company name
|
dataset | True | string |
Name of the Dynamics 365 Business Central (on-premises) company |
|
Table name
|
table | True | string |
Name of the Dynamics 365 Business Central (on-premises) table |
|
Row id
|
id | True | string |
Unique identifier of the row to update |
|
Row
|
item | True | dynamic |
Row with updated values |
Returns
Definitions
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 |