- Reference
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 - 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/business-central/overview/ |
| Connector Metadata | |
|---|---|
| Publisher | Microsoft |
| Publisher | Microsoft |
| Website | https://dynamics.microsoft.com/business-central/overview/ |
| Privacy policy | https://www.microsoft.com/trust-center/privacy |
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| Web service URL | string | Web service URL | True |
| Username | securestring | Username | True |
| Password | securestring | Password | True |
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
- Operation ID:
- PostItem
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
The outputs of this operation are dynamic.
Delete item
- Operation ID:
- DeleteItem
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
- Operation ID:
- GetItem
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
The outputs of this operation are dynamic.
Get item types
- Operation ID:
- GetTables
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
- Operation ID:
- PatchItem
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
The outputs of this operation are dynamic.
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 |
