Connect2All (Preview)

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
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
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.

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 Media

Deletes the media attached to a field in Business Central

Get Csv

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

Get Csv by Id

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

Get Csv by Id with metadata

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

Get Csv with metadata

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

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

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

Get Xml by Id

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

Get Xml by Id with metadata

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

Get Xml with metadata

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

Insert Data

Insert data into a specific Business Central table

Insert Data (Complex)

Insert data into a specific Business Central table

Perform an action

Schedule to perform an action in Business Central

Process Csv

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

Process Xml

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

Update Data

Update a record in Business Central for a specific table

Update Media

Updates a file in Business Central by it's Id

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 in Business Central to retrieve data from

System Id
SystemId True string

The id of the record in Business Central

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 in Business Central to retrieve data from

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 Csv

Get data based on passed configuration and returns the data in the CSV 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

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

Get data by SystemId based on passed configuration and returns the data in the CSV 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

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

Get data by Id with metadata based on passed configuration and returns the data in the CSV 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

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

Get data with metadata based on passed configuration and returns the data in the CSV 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

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

Select
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

name
name string

Your reference name for this table request object

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

table
table True integer

The table from which you want to retrieve data

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

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

Select
Select integer

A field from the selected table

table
table True integer

The table from which you want to retrieve data

System Id
SystemId True string

The id of the record in Business Central

Returns

The outputs of this operation are dynamic.

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 in Business Central to retrieve data from

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

Table
TableId integer

The table in Business Central to retrieve data from

System Id
SystemId string

The id of the record in Business Central

Returns

Get Xml

Get data based on passed configuration and returns the data in 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

Get data by SystemId based on passed configuration and returns the data in 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

System Id
SystemId True string

The id of the record in Business Central

Returns

Get Xml by Id with metadata

Get data by Id with metadata based on passed configuration and returns the data in 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

System Id
SystemId True string

The id of the record in Business Central

Returns

Get Xml with metadata

Get data with metadata based on passed configuration and returns the data in 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

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

id
id integer

A field from the selected table

Value to set
value string

The value to set for this field

table
table True integer

The table from which you want to retrieve data

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

Returns

Name Path Type Description
System Id
SystemId 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

Imports and transforms CSV into Business Central data using a specific 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

Csv Data
data True string

The CSV data you wish to process

Delimiter
delimiter True string

The delimiter to be used to seperate the columns

Skip Footer Lines
skipfooterlines integer

Set how many footer lines you wish to skip

Skip Header Lines
skipheaderlines integer

Set how many header lines you wish to skip

Use Headers
useheaders boolean

If set headers are used in the CSV

Returns

Process Xml

Imports and transforms XML into Business Central data using a specific 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

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

id
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
table True integer

The table from which you want to retrieve data

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 in Business Central to retrieve data from

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

Triggers

Triggers when a record is created

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 updated

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