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

Operation ID:

DeleteData

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

Operation ID:

DeleteDataBulk

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

Operation ID:

ClearMedia

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)

Operation ID:

DeleteMediaBulk

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]

Operation ID:

GetCsvDocument

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]

Operation ID:

GetCsvDocumentById

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]

Operation ID:

GetCsvDocumentByIdWithMetadata

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]

Operation ID:

GetCsvDocumentWithMetadata

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

Operation ID:

GetData

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)

Operation ID:

GetDataRaw

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

Operation ID:

GetDataById

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]

Operation ID:

GetDataInBulk

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

Operation ID:

GetMedia

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

Operation ID:

GetReport

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]

Operation ID:

GetXmlDocument

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]

Operation ID:

GetXmlDocumentById

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]

Operation ID:

GetXmlDocumentByIdWithMetadata

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]

Operation ID:

GetXmlDocumentWithMetadata

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

Operation ID:

CreateData

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)

Operation ID:

CreateDataComplex

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

Operation ID:

CreateDataBulk

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

Operation ID:

PerformSynchronousAction

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

Operation ID:

PerformAction

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]

Operation ID:

PostTransformCsv

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]

Operation ID:

PostTransformXml

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

Operation ID:

UpdateData

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

Operation ID:

UpdateDataBulk

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

Operation ID:

UpdateDataComplex

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

Operation ID:

PatchMedia

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)

Operation ID:

UpdateMediaBulk

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

Operation ID:

UpsertData

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)

Operation ID:

UpsertDataBulk

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)

Operation ID:

UpsertDataComplex

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

Operation ID:

RecordCreated

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)

Operation ID:

RecordCreatedV2

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

Operation ID:

RecordDeleted

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)

Operation ID:

RecordDeletedV2

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

Operation ID:

RecordUpdated

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)

Operation ID:

RecordUpdatedV2

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