Microsoft Dynamics 365 CRM API 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 the Microsoft Dynamics server.

The typical structure of the procedure looks as follows:

Parameter
<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 to the entity metadata. The first field in the resultset is always key field (if the entity has it). The rest fields are ordered alphabetically.