Connect2All on-premises (Preview)
Import and export your Business Central on-premises data
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 - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - 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) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | GAC Business Solutions |
| URL | https://www.gac.nl |
| apps@gac.nl |
| Connector Metadata | |
|---|---|
| Publisher | GAC Business Solutions |
| Website | https://www.gac.nl |
| Privacy Policy | https://www.gac.nl/disclaimer |
| Categories | Productivity;Data |
GAC Connect2All integrates the Microsoft Power Platform to Business Central on-premises and makes adaptations and the extensibility to connect virtual any Datasource to your business processes in Business Central on-premises possible. You do not need to be a Professional developer to seamlessly extend Business Central on-premises to interact to other business application and Datasources. GAC Connect2All delivers your business the scalability and flexibility to create smart integration solutions you need today and tomorrow.
Prerequisites
The user, who wants to use to the Connect2All connector in Power Automate, must meet the requirements below:
- The user must have a valid BC 365 license.
- The user must have a paid subscription to at least one (or more) of the following GAC products:
- Trade365 Starter
- Trade365 Plus
- Trade365 Enterprise
- Production 365 Starter
- Production 365 Plus
- Production 365 Enterprise
- PSA 365 Starter
- PSA 365 Plus
- PSA 365 Enterprise
- GAC Integration platform
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 |
|---|---|---|---|
| Password | securestring | The Password for this api | True |
| Username | securestring | The Username for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Delete Data |
Delete data from Business Central by it's unique id |
| Delete Data Bulk |
Delete multiple records in Business Central |
| Delete Media |
Deletes the media attached to a field in Business Central |
| Get Data |
Get data from Business Central for specific tables |
| Get Data (Complex) |
Get data from Business Central with a raw JSON request |
| Get Data by Id |
Get data from Business Central for a specific table and record |
| Get Data in bulk format |
Get data from Business Central for a table in bulk format. |
| Get Media |
Retrieves a file from Business Central by it's Id |
| Get Report |
Gets a report from Business Central on a report ID or a record |
| Insert Data |
Insert data into a specific Business Central table |
| Insert Data (Complex) |
Insert data into a specific Business Central table |
| Insert Data Bulk |
Insert multiple records into Business Central |
| Perform a synchronous action |
Perform a synchronous action in Business Central |
| Perform an action |
Schedule to perform an action in Business Central |
| Update Data |
Update a record in Business Central for a specific table |
| Update Data Bulk |
Update multiple records in Business Central |
| Update Data Complex |
Update a record in Business Central for a specific table |
| Update Media |
Updates a file in Business Central by it's Id |
| Upsert Data |
Upsert data into a specific Business Central table |
| Upsert Data (Bulk) |
Upsert multiple records into Business Central |
| Upsert Data (Complex) |
Upsert data into a specific Business Central table |
Delete Data
Delete data from Business Central by it's unique id
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table
|
Table | True | integer |
The table from Business Central which is used in this request |
|
System Id
|
SystemId | True | string |
The id of the record in Business Central |
Delete Data Bulk
Delete multiple records in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
DeleteRequest
|
DeleteRequests | object |
Delete Media
Deletes the media attached to a field in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table
|
Table | True | integer |
The table from Business Central which is used in this request |
|
Field
|
Field | True | integer |
A field from the selected table |
|
System Id
|
SystemId | True | string |
The id of the record in Business Central |
Returns
Get Data
Get data from Business Central for specific tables
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Selected Field
|
Select | integer |
A field from the selected table |
|
|
Selected Field
|
field | integer |
A field from the selected table |
|
|
Filter
|
filter | string |
A valid Business Central filter value |
|
|
Name
|
name | string |
Your reference name for this table request object |
|
|
Selected Field
|
Order by | integer |
A field from the selected table |
|
|
Sort Order
|
sortorder | string |
Whether the data returned is sorted in ascending or descending order |
|
|
Table ID
|
table | True | integer |
The table from Business Central which is used in this request |
|
Top
|
top | integer |
The maximum amount of records to return |
Returns
Get Data (Complex)
Get data from Business Central with a raw JSON request
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
|
object |
Returns
Get Data by Id
Get data from Business Central for a specific table and record
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Selected Field
|
Select | integer |
A field from the selected table |
|
|
Table ID
|
table | True | integer |
The table from Business Central which is used in this request |
|
System Id
|
SystemId | True | string |
The id of the record in Business Central |
Returns
Get Data in bulk format
Get data from Business Central for a table in bulk format.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Select
|
Fields | array of integer |
Select a field you want to retrieve |
|
|
Field
|
Field | integer |
A field from the selected table |
|
|
Filter
|
Filter | string |
A valid Business Central filter value |
|
|
Table ID
|
Table | integer |
TableId |
|
|
Take
|
Take | integer |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
nextPageLink
|
nextPageLink | string | |
|
value
|
value | array of array | |
|
items
|
value | array of |
Get Media
Retrieves a file from Business Central by it's Id
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table
|
Table | True | integer |
The table from Business Central which is used in this request |
|
Field
|
Field | True | integer |
A field from the selected table |
|
System Id
|
SystemId | True | string |
The id of the record in Business Central |
Returns
Get Report
Gets a report from Business Central on a report ID or a record
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Format
|
Format | True | string |
The file format to get the report in |
|
Report
|
ReportId | True | integer |
The id of the report in Business Central to retrieve |
|
Layout
|
LayoutCode | string |
The custom layout to use |
|
|
Table
|
TableId | integer |
The table from Business Central which is used in this request |
|
|
System Id
|
SystemId | string |
The id of the record in Business Central |
Returns
Insert Data
Insert data into a specific Business Central table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Selected Field
|
id | integer |
A field from the selected table |
|
|
Value to set
|
value | string |
The value to set for this field |
|
|
Table ID
|
table | True | integer |
The table from Business Central which is used in this request |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
System Id
|
SystemId | string |
Insert Data (Complex)
Insert data into a specific Business Central table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
|
object |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
System Id
|
SystemId | string |
Insert Data Bulk
Insert multiple records into Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
CreateRequest
|
CreateRequests | object |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Responses
|
array of string |
Perform a synchronous action
Perform a synchronous action in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Action type
|
actiontype | True | string |
The action type of the synchronous action that you wish to execute |
|
Payload String
|
payload | string |
The payload string to pass to the synchronous action |
Returns
- response
- string
Perform an action
Schedule to perform an action in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Codeunit to execute
|
codeunitId | True | integer |
The codeunit you wish to execute |
|
Parameter String
|
parameters | string |
The parameter string to pass to the codeunit |
Update Data
Update a record in Business Central for a specific table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Selected Field
|
id | integer |
A field from the selected table |
|
|
Value to set
|
value | string |
The value to set for this field |
|
|
System Id
|
systemId | True | string |
The id of the record in Business Central |
|
Table ID
|
table | True | integer |
The table from Business Central which is used in this request |
Update Data Bulk
Update multiple records in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
UpdateRequest
|
UpdateRequests | object |
Update Data Complex
Update a record in Business Central for a specific table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
|
object |
Update Media
Updates a file in Business Central by it's Id
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table
|
Table | True | integer |
The table from Business Central which is used in this request |
|
Field
|
Field | True | integer |
A field from the selected table |
|
System Id
|
SystemId | True | string |
The id of the record in Business Central |
|
File Contents
|
FileContent | True | binary |
The file contents the be saved as bytes |
Returns
Upsert Data
Upsert data into a specific Business Central table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
Selected Field
|
id | integer |
A field from the selected table |
|
|
Value to set
|
value | string |
The value to set for this field |
|
|
Table ID
|
table | True | integer |
The table from Business Central which is used in this request |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
System Id
|
SystemId | string |
Upsert Data (Bulk)
Upsert multiple records into Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
CreateRequest
|
CreateRequests | object |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
Responses
|
array of string |
Upsert Data (Complex)
Upsert data into a specific Business Central table
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Language
|
Language | string |
The language in which to communicate with Business Central |
|
|
|
object |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
System Id
|
SystemId | string |
Triggers
| Triggers when a record is created |
A record is created in Business Central |
| Triggers when a record is created (V2) |
A record is created in Business Central |
| Triggers when a record is deleted |
A record is deleted in Business Central |
| Triggers when a record is deleted (V2) |
A record is deleted in Business Central |
| Triggers when a record is updated |
A record is updated in Business Central |
| Triggers when a record is updated (V2) |
A record is updated in Business Central |
Triggers when a record is created
A record is created in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table ID
|
TableId | True | integer |
TableId |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
SystemId
|
SystemId | string |
SystemId |
Triggers when a record is created (V2)
A record is created in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Select
|
Fields | array of integer |
Select a field you want to retrieve |
|
|
Field
|
Field | integer |
A field from the selected table |
|
|
Filter
|
FilterValue | string |
A valid Business Central filter value |
|
|
Is Batch
|
IsBatch | boolean |
Receive batches or singular updates |
|
|
Table ID
|
TableId | True | integer |
TableId |
Returns
Triggers when a record is deleted
A record is deleted in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table ID
|
TableId | True | integer |
TableId |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
SystemId
|
SystemId | string |
SystemId |
Triggers when a record is deleted (V2)
A record is deleted in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Select
|
Fields | array of integer |
Select a field you want to retrieve |
|
|
Field
|
Field | integer |
A field from the selected table |
|
|
Filter
|
FilterValue | string |
A valid Business Central filter value |
|
|
Is Batch
|
IsBatch | boolean |
Receive batches or singular updates |
|
|
Table ID
|
TableId | True | integer |
TableId |
Returns
Triggers when a record is updated
A record is updated in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Table ID
|
TableId | True | integer |
TableId |
Returns
| Name | Path | Type | Description |
|---|---|---|---|
|
SystemId
|
SystemId | string |
SystemId |
Triggers when a record is updated (V2)
A record is updated in Business Central
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Business Central Url
|
Url | True | string |
The Business Central environment to connect to |
|
Company
|
Company | True | string |
The Business Central company to connect to |
|
Select
|
Fields | array of integer |
Select a field you want to retrieve |
|
|
Field
|
Field | integer |
A field from the selected table |
|
|
Filter
|
FilterValue | string |
A valid Business Central filter value |
|
|
Is Batch
|
IsBatch | boolean |
Receive batches or singular updates |
|
|
Table ID
|
TableId | True | integer |
TableId |
Returns
Definitions
string
This is the basic data type 'string'.