Dynamic 365 Business Central Collectors

Overview

DataBlend currently collects the following data types:

Search
Search OData
Search CodeUnits

Configuration

Field	Required/ Optional	Comments
Type	Required	Dynamic 365 Business Central
Name	Required	Descriptive free-text name for the collector
Data Source	Required	Select a pre-configured data source from the drop down or click Create New to create a new data source.
Schema Name	Required	Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run.
Credential	Required	Select a pre-configured Dynamic 365 Business Central credential from the drop-down.
Business Central Collector Type	Required	Export Attributes
Collection Type	Required	Select from the drop-down menu provided.

Collected Data

The Dynamic 365 Business Central attribute metadata collection returns the complete set of all custom attributes (excluding the trading partner system attribute for consolidation instances), including member values. DataBlend makes these available in a tabular format with the following columns:

Column Name	Description
rowtype	Value will be either Attribute or AttributeValue. Indicates whether the row represents a custom attribute or the value of a custom attribute.
parentid	Populated for attribute values only. Indicates this value's parent attribute or attribute value.
id	Dynamic 365 Business Central internal id number. This value is required when making updates to the attribute or attribute value.
name	Name of the attribute or attribute value.
type	Populated for attributes only. Value will be either account, level, or dimension. Indicates whether the attribute can be applied to a Dynamic 365 Business Central account, level or dimension.
autocreate	Populated for attributes only. Value will be either 0 or 1. Indicates whether an attribute value can be created automatically for this attribute when data is loaded. If 0, attribute values will not be created. If 1, attribute values will be created.
keepsorted	DataBlend is aware of an issue where no values for keepsorted are returned.
dimensionid	Populated for attributes of type dimension only. Indicates the custom dimension the attribute is associated with.
seqno	Per Dynamic 365 Business Central API docs: Added in API v17 but reserved for future use.

Details

The details section documents who the Collector was created and updated by and the corresponding times. This allows for easy tracking of multiple Collectors.

Latest Collection

The latest collection section documents the state of the collector, created time, and the status of the query. States include complete and error.

Collections

The Collections section documents when the Collector was created, started, completed and the total amount of data scanned. The status includes information regarding the state of the Collector. This allows for easy tracking of multiple collections.

Filters

Collections can also be filtered. Each collection Type will have its own respective filters. Acceptable filters and required syntax can be found here: API (V2.0) for Dynamics 365 Business Central - Business Central

The formatting of filters can be found here: https://github.com/Microsoft/api-guidelines/blob/master/Guidelines.md#97-filtering

Example: When using the trialBalances collector type, the filter below will limit the data collected to 7/1/2022 through 7/31/2022. In this example, the parameter is ‘dateFilter’, ‘ge’ represents Greater Than or Equal, and ‘le’ represents Less Than or Equal.

To learn more about Dynamic 365 Business Central API requirements, please visit API (V2.0) for Dynamics 365 Business Central - Business Central.