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 protected] |
| 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
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
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
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
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
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
Definitions
string
This is the basic data type 'string'.