Collectors
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Collectors

      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.