...
For a specific Entity, if you select multiple Read related entities, and if one of them has null values for a few records, then Snap displays the following error:An error has occurred."The EDM instance of type '[Microsoft.Dynamics.DataEntities.Person Nullable=True]' is missing the property 'EmployeesV2'." [HTTP/1.1 400 Internal Server Error]
As a workWork-around, we : We recommend you either follow the above setting for the Entity or ensure all the records have data (non-null values) for the selected Read related entities.
...
Field Name | Field Type | Description | |
---|---|---|---|
Label* Default Value: Dynamics 365 Finance and SCM Read | String | Specify a unique name for the Snap. | |
Entity* Default Value: N/A | String/Expression | Specify the OData entity object from which you want to read the records. | |
Primary key | Use this field set to specify the primary key that uniqely identifies the rows. | ||
Key Default Value: N/A | String/Expression | Specify or select the primary key from which you want to read the record.
| |
Value Default Value: N/A | String/Expression | Specify the value of the key from which you want to read the record. | |
Cross Company Default Value: Deselected | Expression/Checkbox | Select this checkbox if you want to fetch data apart from your default company. You can enable the expression for this field to use input values from the upstream Snap. | |
Output fields | Use this field set to fetch the fields you want the Snap to display in the output. | ||
Output field Default Value: N/A | String/Expression | Specify or select the fields that you want to display in the output. | |
Read related entities | Use this field set to specify the related entities of the specific entity. | ||
Read related entity Default Value: N/A | String/Expression | Specify or select the numerous related entities that you want to display in the output in addition to the fields in the Output fields. | |
Page size Default Value: 1000 | Integer/Expression | Specify the number of records you want to fetch per page size quickly for large datasets. | |
Start page number Default Value: 1 | Integer/Expression | Specify the page number from which the loading of records should begin till the last record or load until the value specified in the Max page number field. | |
Max page number Default Value: 0 | Integer/Expression | Specify the page number after which the Snap should stop loading. The value of '0' reads all the pages. If you do not provide any value in this field, the default value (0) is used. | |
Number of retries Default Value: 0 | Integer/Expression | Specify the maximum number of retry attempts in case of failures. The number of retries are disabled if the value is 0. | |
Retry interval (seconds) Default Value: 1 | Integer/Expression | Specify the amount of time in seconds between retry attempts. | |
HTTP header | Use this field set to define the HTTP key-value pairs to pass to the Dynamics 365 instance. | ||
Key Default Value: N/A | String/Expression | Specify the key for the HTTP header. | |
Value Default Value: N/A | String/Expression | Specify the value for the HTTP header. | |
Snap Execution Default Value: Execute only | Dropdown list | Select one of the following three modes in which the Snap executes:
|
...