Connect2All on-premises (Preview)

Reference

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 connection	100	60 seconds

Actions

Delete Data	Delete data from Business Central by it's unique id
Delete Data Bulk	Delete multiple records in Business Central
Delete Media	Deletes the media attached to a field in Business Central
Get Data	Get data from Business Central for specific tables
Get Data (Complex)	Get data from Business Central with a raw JSON request
Get Data by Id	Get data from Business Central for a specific table and record
Get Data in bulk format	Get data from Business Central for a table in bulk format.
Get Media	Retrieves a file from Business Central by it's Id
Get Report	Gets a report from Business Central on a report ID or a record
Insert Data	Insert data into a specific Business Central table
Insert Data (Complex)	Insert data into a specific Business Central table
Insert Data Bulk	Insert multiple records into Business Central
Perform a synchronous action	Perform a synchronous action in Business Central
Perform an action	Schedule to perform an action in Business Central
Update Data	Update a record in Business Central for a specific table
Update Data Bulk	Update multiple records in Business Central
Update Data Complex	Update a record in Business Central for a specific table
Update Media	Updates a file in Business Central by it's Id
Upsert Data	Upsert data into a specific Business Central table
Upsert Data (Bulk)	Upsert multiple records into Business Central
Upsert Data (Complex)	Upsert data into a specific Business Central table

Delete Data

Operation ID:: DeleteData

Delete data from Business Central by it's unique id

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table	Table	True	integer	The table from Business Central which is used in this request
System Id	SystemId	True	string	The id of the record in Business Central

Delete Data Bulk

Operation ID:: DeleteDataBulk

Delete multiple records in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
DeleteRequest	DeleteRequests		object

Delete Media

Operation ID:: ClearMedia

Deletes the media attached to a field in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table	Table	True	integer	The table from Business Central which is used in this request
Field	Field	True	integer	A field from the selected table
System Id	SystemId	True	string	The id of the record in Business Central

Returns

Get Data

Operation ID:: GetData

Get data from Business Central for specific tables

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Selected Field	Select		integer	A field from the selected table
Selected Field	field		integer	A field from the selected table
Filter	filter		string	A valid Business Central filter value
Name	name		string	Your reference name for this table request object
Selected Field	Order by		integer	A field from the selected table
Sort Order	sortorder		string	Whether the data returned is sorted in ascending or descending order
Table ID	table	True	integer	The table from Business Central which is used in this request
Top	top		integer	The maximum amount of records to return

Returns

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
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
			object

Returns

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

Operation ID:: GetDataInBulk

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

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Select	Fields		array of integer	Select a field you want to retrieve
Field	Field		integer	A field from the selected table
Filter	Filter		string	A valid Business Central filter value
Table ID	Table		integer	TableId
Take	Take		integer

Returns

Name	Path	Type
nextPageLink	nextPageLink	string
value	value	array of array
items	value	array of

Get Media

Operation ID:: GetMedia

Retrieves a file from Business Central by it's Id

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table	Table	True	integer	The table from Business Central which is used in this request
Field	Field	True	integer	A field from the selected table
System Id	SystemId	True	string	The id of the record in Business Central

Returns

Get Report

Operation ID:: GetReport

Gets a report from Business Central on a report ID or a record

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Format	Format	True	string	The file format to get the report in
Report	ReportId	True	integer	The id of the report in Business Central to retrieve
Layout	LayoutCode		string	The custom layout to use
Table	TableId		integer	The table from Business Central which is used in this request
System Id	SystemId		string	The id of the record in Business Central

Returns

Insert Data

Operation ID:: CreateData

Insert data into a specific Business Central table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Selected Field	id		integer	A field from the selected table
Value to set	value		string	The value to set for this field
Table ID	table	True	integer	The table from Business Central which is used in this request

Returns

Name	Path	Type	Description
System Id	SystemId	string

Insert Data (Complex)

Operation ID:: CreateDataComplex

Insert data into a specific Business Central table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
			object

Returns

Name	Path	Type	Description
System Id	SystemId	string

Insert Data Bulk

Operation ID:: CreateDataBulk

Insert multiple records into Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
CreateRequest	CreateRequests		object

Returns

Name	Path	Type	Description
Responses		array of string

Perform a synchronous action

Operation ID:: PerformSynchronousAction

Perform a synchronous action in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Action type	actiontype	True	string	The action type of the synchronous action that you wish to execute
Payload String	payload		string	The payload string to pass to the synchronous action

Returns

response: string

Perform an action

Operation ID:: PerformAction

Schedule to perform an action in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Codeunit to execute	codeunitId	True	integer	The codeunit you wish to execute
Parameter String	parameters		string	The parameter string to pass to the codeunit

Update Data

Operation ID:: UpdateData

Update a record in Business Central for a specific table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Selected Field	id		integer	A field from the selected table
Value to set	value		string	The value to set for this field
System Id	systemId	True	string	The id of the record in Business Central
Table ID	table	True	integer	The table from Business Central which is used in this request

Update Data Bulk

Operation ID:: UpdateDataBulk

Update multiple records in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
UpdateRequest	UpdateRequests		object

Update Data Complex

Operation ID:: UpdateDataComplex

Update a record in Business Central for a specific table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
			object

Update Media

Operation ID:: PatchMedia

Updates a file in Business Central by it's Id

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table	Table	True	integer	The table from Business Central which is used in this request
Field	Field	True	integer	A field from the selected table
System Id	SystemId	True	string	The id of the record in Business Central
File Contents	FileContent	True	binary	The file contents the be saved as bytes

Returns

Upsert Data

Operation ID:: UpsertData

Upsert data into a specific Business Central table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
Selected Field	id		integer	A field from the selected table
Value to set	value		string	The value to set for this field
Table ID	table	True	integer	The table from Business Central which is used in this request

Returns

Name	Path	Type	Description
System Id	SystemId	string

Upsert Data (Bulk)

Operation ID:: UpsertDataBulk

Upsert multiple records into Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
CreateRequest	CreateRequests		object

Returns

Name	Path	Type	Description
Responses		array of string

Upsert Data (Complex)

Operation ID:: UpsertDataComplex

Upsert data into a specific Business Central table

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Language	Language		string	The language in which to communicate with Business Central
			object

Returns

Name	Path	Type	Description
System Id	SystemId	string

Triggers

Triggers when a record is created	A record is created in Business Central
Triggers when a record is created (V2)	A record is created in Business Central
Triggers when a record is deleted	A record is deleted in Business Central
Triggers when a record is deleted (V2)	A record is deleted in Business Central
Triggers when a record is updated	A record is updated in Business Central
Triggers when a record is updated (V2)	A record is updated in Business Central

Triggers when a record is created

Operation ID:: RecordCreated

A record is created in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table ID	TableId	True	integer	TableId

Returns

Name	Path	Type	Description
SystemId	SystemId	string	SystemId

Triggers when a record is created (V2)

Operation ID:: RecordCreatedV2

A record is created in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Select	Fields		array of integer	Select a field you want to retrieve
Field	Field		integer	A field from the selected table
Filter	FilterValue		string	A valid Business Central filter value
Is Batch	IsBatch		boolean	Receive batches or singular updates
Table ID	TableId	True	integer	TableId

Returns

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
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table ID	TableId	True	integer	TableId

Returns

Name	Path	Type	Description
SystemId	SystemId	string	SystemId

Triggers when a record is deleted (V2)

Operation ID:: RecordDeletedV2

A record is deleted in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Select	Fields		array of integer	Select a field you want to retrieve
Field	Field		integer	A field from the selected table
Filter	FilterValue		string	A valid Business Central filter value
Is Batch	IsBatch		boolean	Receive batches or singular updates
Table ID	TableId	True	integer	TableId

Returns

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
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Table ID	TableId	True	integer	TableId

Returns

Name	Path	Type	Description
SystemId	SystemId	string	SystemId

Triggers when a record is updated (V2)

Operation ID:: RecordUpdatedV2

A record is updated in Business Central

Parameters

Name	Key	Required	Type	Description
Business Central Url	Url	True	string	The Business Central environment to connect to
Company	Company	True	string	The Business Central company to connect to
Select	Fields		array of integer	Select a field you want to retrieve
Field	Field		integer	A field from the selected table
Filter	FilterValue		string	A valid Business Central filter value
Is Batch	IsBatch		boolean	Receive batches or singular updates
Table ID	TableId	True	integer	TableId