Connect2All on-premises (Preview)

Connect2All on-premises connects cloud flows with Dynamics 365 Business Central on-premises. It helps organizations automate ERP processes by reading, creating, updating, importing and exporting Business Central data through reusable connector actions and triggers.

This connector is available in the following products and regions:

Service	Class	Regions
Copilot Studio	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)
Logic Apps	Standard	All Logic Apps regions except the following: - Azure Government regions - Azure China regions - 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)
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)

Contact
Name	Bravx
URL	https://www.bravx.com
Email	apps@bravx.com

Connector Metadata
Publisher	GAC Business Solutions
Website	https://www.bravx.com
Privacy Policy	https://www.bravx.com/privacy-statement
Categories	Productivity;Data

The Connect2All on-premises connector unlocks Microsoft Dynamics 365 Business Central on-premises for Power Automate. Data in all tables of a Business Central environment can be used and managed, including all tables added through extensions. In addition, any data change in fields within these tables can be used as a trigger for a Power Automate flow.

Requirements

To use the Connect2All on-premises connector, you need an on-premises Microsoft Dynamics 365 Business Central environment (from version 20.0.37118.1) with one of the following Bravx apps:

Integration Platform
Production365
PSA365
Trade365
Medical365

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.

Name	Type	Description	Required
Username	securestring	The Username for this api	True
Password	securestring	The Password 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 (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
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
Table ID	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
Field	Select		integer	A field from the selected table
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
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
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
Table ID	table	True	integer	The table from Business Central which is used in this request
Field	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
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
Take	Take		integer
Table ID	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
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
Table ID	table	True	integer	The table from Business Central which is used in this request
Field	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
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
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
Field	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
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
Table ID	table	True	integer	The table from Business Central which is used in this request
Field	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
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
Table ID	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
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
Table ID	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
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
Table ID	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