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
Email 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 connection10060 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 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

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

The outputs of this operation are dynamic.

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

Returns

The outputs of this operation are dynamic.

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

The outputs of this operation are dynamic.

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

Field
Select integer

A field from the selected table

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

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

Returns

Name Path Type Description
Responses
array of 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

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

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

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

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 Field
Select integer

A field from the selected table

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

The outputs of this operation are dynamic.

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 Field
Select integer

A field from the selected table

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

The outputs of this operation are dynamic.

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

Field
Select integer

A field from the selected table

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

The outputs of this operation are dynamic.