Connect2All

Import, export and transform your Business Central 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

Connect2All unlocks Microsoft Dynamics 365 Business Central SaaS to PowerAutomate. Data in all tables of a Business Central environment can be used and managed including all tables added by extensions. In addition, any data change in these tables can be used as a trigger for a PowerAutomate flow.

Prerequisites

To use the Connect2All connector you need a Microsoft Dynamics 365 Business Central SaaS environment with one of the following GAC Business Solutions apps:

  • GAC Integration Platform
  • Production365
  • PSA365
  • Trade365

How to get credentials

Connect2All doesn't require extra authentication. It uses the credentials you use to connect to your Microsoft Dynamics 365 Business Central.

Known issues and limitations

There are the following known issues for using Connect2All in PowerAutomate:

  • When using the action 'Get Data' the dynamic schema is not resolved at designtime of your flow. You can work around this by:
    • using 'Switch to input entire array' and enter the 'Request Select Fields' by id
  • When using the action 'Get Data by Id' the dynamic schema is not resolved at designtime of your flow. You can work around this by:
    • using 'Switch to input entire array' and enter the 'Request Select Fields' by id
    • using a fixed GUID value as a System Id Just before saving this can be changed to the System Id provided by a Connect2All trigger.

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.

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

Delete Media (Bulk)

Deletes one or multiple files in Business Central

Get Csv (deprecated) [DEPRECATED]

Get data based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Get Csv by Id (deprecated) [DEPRECATED]

Get data by SystemId based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Get Csv by Id with metadata (deprecated) [DEPRECATED]

Get data by Id with metadata based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Get Csv with metadata (deprecated) [DEPRECATED]

Get data with metadata based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

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 (deprecated) [DEPRECATED]

Get data from Business Central for a table in bulk format. (deprecated)

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

Get Xml (deprecated) [DEPRECATED]

Get data based on passed configuration and returns the data in (deprecated) the XML format set in the configuration

Get Xml by Id (deprecated) [DEPRECATED]

Get data by SystemId based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

Get Xml by Id with metadata (deprecated) [DEPRECATED]

Get data by Id with metadata based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

Get Xml with metadata (deprecated) [DEPRECATED]

Get data with metadata based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

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

Process Csv (deprecated) [DEPRECATED]

Imports and transforms CSV into Business Central data using a specific configuration (deprecated)

Process Xml (deprecated) [DEPRECATED]

Imports and transforms XML into Business Central data using a specific configuration (deprecated)

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

Update Media (Bulk)

Updates one or multiple files in Business Central

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
Environment
Environment 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
Environment
Environment 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
Environment
Environment 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

Delete Media (Bulk)

Deletes one or multiple files in Business Central

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

body
body object

Returns

Get Csv (deprecated) [DEPRECATED]

Get data based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

Delimiter
delimiter string

The delimiter to be used to seperate the columns

Use Headers
headers boolean

If set headers are used in the CSV

Returns

Get Csv by Id (deprecated) [DEPRECATED]

Get data by SystemId based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

System Id
SystemId True string

The id of the record in Business Central

Delimiter
delimiter string

The delimiter to be used to seperate the columns

Use Headers
headers boolean

If set headers are used in the CSV

Returns

Get Csv by Id with metadata (deprecated) [DEPRECATED]

Get data by Id with metadata based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

System Id
SystemId True string

The id of the record in Business Central

Delimiter
delimiter string

The delimiter to be used to seperate the columns

Use Headers
headers boolean

If set headers are used in the CSV

Returns

Get Csv with metadata (deprecated) [DEPRECATED]

Get data with metadata based on passed configuration and returns the data in the CSV format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

Delimiter
delimiter string

The delimiter to be used to seperate the columns

Use Headers
headers boolean

If set headers are used in the CSV

Returns

Get Data

Get data from Business Central for specific tables

Parameters

Name Key Required Type Description
Environment
Environment 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

table
table True integer

The table from Business Central which is used in this request

name
name string

Your reference name for this table request object

top
top integer

The maximum amount of records to return

Select
Select integer

A field from the selected table

Order by
Order by integer

A field from the selected table

sortorder
sortorder string

Whether the data returned is sorted in ascending or descending order

field
field integer

A field from the selected table

Filter
filter string

A valid Business Central filter value

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
Environment
Environment 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

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
Environment
Environment 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

table
table True integer

The table from Business Central which is used in this request

Select
Select integer

A field from the selected table

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 (deprecated) [DEPRECATED]

Get data from Business Central for a table in bulk format. (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment 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

Take
Take integer
Table
Table integer

TableId

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

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
Environment
Environment 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
Environment
Environment 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

Get Xml (deprecated) [DEPRECATED]

Get data based on passed configuration and returns the data in (deprecated) the XML format set in the configuration

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

Returns

Get Xml by Id (deprecated) [DEPRECATED]

Get data by SystemId based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

System Id
SystemId True string

The id of the record in Business Central

Returns

Get Xml by Id with metadata (deprecated) [DEPRECATED]

Get data by Id with metadata based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

System Id
SystemId True string

The id of the record in Business Central

Returns

Get Xml with metadata (deprecated) [DEPRECATED]

Get data with metadata based on passed configuration and returns the data in the XML format set in the configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

Returns

Insert Data

Insert data into a specific Business Central table

Parameters

Name Key Required Type Description
Environment
Environment 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

table
table True integer

The table from Business Central which is used in this request

id
id integer

A field from the selected table

Value to set
value string

The value to set for this field

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
Environment
Environment 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
Environment
Environment 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
Environment
Environment 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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

codeunitId
codeunitId True integer

The codeunit you wish to execute

Parameter String
parameters string

The parameter string to pass to the codeunit

Process Csv (deprecated) [DEPRECATED]

Imports and transforms CSV into Business Central data using a specific configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

Delimiter
delimiter True string

The delimiter to be used to seperate the columns

Skip Header Lines
skipheaderlines integer

Set how many header lines you wish to skip

Skip Footer Lines
skipfooterlines integer

Set how many footer lines you wish to skip

Use Headers
useheaders boolean

If set headers are used in the CSV

Csv Data
data True string

The CSV data you wish to process

Returns

Process Xml (deprecated) [DEPRECATED]

Imports and transforms XML into Business Central data using a specific configuration (deprecated)

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

Configuration
Configuration True string

The configuration to use to transform the data to and from Business Central

data
data string

data

Returns

Update Data

Update a record in Business Central for a specific table

Parameters

Name Key Required Type Description
Environment
Environment 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

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

id
id integer

A field from the selected table

Value to set
value string

The value to set for this field

Update Data Bulk

Update multiple records in Business Central

Parameters

Name Key Required Type Description
Environment
Environment 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
Environment
Environment 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
Environment
Environment 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

Update Media (Bulk)

Updates one or multiple files in Business Central

Parameters

Name Key Required Type Description
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

body
body object

Returns

Upsert Data

Upsert data into a specific Business Central table

Parameters

Name Key Required Type Description
Environment
Environment 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

table
table True integer

The table from Business Central which is used in this request

id
id integer

A field from the selected table

Value to set
value string

The value to set for this field

Returns

Name Path Type Description
System Id
SystemId string

Upsert Data (Bulk)

Upsert multiple records into Business Central

Parameters

Name Key Required Type Description
Environment
Environment 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
Environment
Environment 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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
TableId True integer

TableId

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

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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
TableId True integer

TableId

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

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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
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
Environment
Environment True string

The Business Central environment to connect to

Company
Company True string

The Business Central company to connect to

TableId
TableId True integer

TableId

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

Returns

The outputs of this operation are dynamic.

Definitions

string

This is the basic data type 'string'.