Microsoft Dynamics 365 Business Central Reference

Dynamically created procedures

The connector doesn't provide predefined procedures. All the procedures are generated dynamically by running the InitializeMetadata procedure on connector's start and according description of entities in the metadata file read from Microsoft Dynamics 365 Bisiness Central server.

The typical structure of the procedure looks as follows:

Parameter

<company_name> (optional): CSV with company unique names
<filter> (optional): Filter criteria for which entities will be returned
<preview> (optional): Preview only, don't write into table
<target_table> (optional): Table name to save the data to

ResultSet is dynamic for each entity and consists of the relevant columns  names, datatypes and annotations defined according entity metadata. The first field in the resultset is always key field (if the entity has it). The rest fields are ordered alphabetically.