Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Connect2All on-premises (Preview)
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Copilot Studio | 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) |
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - 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) |
| 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) |
| 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
- Operation ID:
- DeleteData
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
- Operation ID:
- DeleteDataBulk
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
- Operation ID:
- ClearMedia
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
- Operation ID:
- GetData
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)
- Operation ID:
- GetDataRaw
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
- Operation ID:
- GetDataById
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
- Operation ID:
- GetDataInBulk
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
- Operation ID:
- GetMedia
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
- Operation ID:
- GetReport
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
- Operation ID:
- CreateData
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)
- Operation ID:
- CreateDataComplex
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
- Operation ID:
- CreateDataBulk
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
- Operation ID:
- PerformSynchronousAction
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
- Operation ID:
- PerformAction
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
- Operation ID:
- UpdateData
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
- Operation ID:
- UpdateDataBulk
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
- Operation ID:
- UpdateDataComplex
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
- Operation ID:
- PatchMedia
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
- Operation ID:
- UpsertData
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)
- Operation ID:
- UpsertDataBulk
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)
- Operation ID:
- UpsertDataComplex
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
- Operation ID:
- RecordCreated
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)
- Operation ID:
- RecordCreatedV2
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
- Operation ID:
- RecordDeleted
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)
- Operation ID:
- RecordDeletedV2
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
- Operation ID:
- RecordUpdated
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)
- Operation ID:
- RecordUpdatedV2
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'.