In this article
Table of Contents |
---|
Overview
You can use Dynamics 365 Business Central Search Snap to search for the required data for a specified entity.
Snap Type
The Dynamics 365 Business Central Search Snap is a Read-type Snap.
Prerequisites
None.
Support for Ultra Pipelines
Works in Ultra Pipelines.
Limitations
None.
Known Issues
For a specific Entity, if you select multiple related entities as part of the export query parameter, 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]
Work-around: We recommend you either follow the above setting for the Entity or ensure all the records have data (non-null values) for the selected related entities.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document
|
|
| The entity in which you want to search for objects. |
Output | Document
|
|
| The output contains searched records for the specified entity. |
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines. |
Snap Settings
Info |
---|
|
Field Name | Field Type | Description | |
---|---|---|---|
Label*
Default Value: Dynamics 365 Business Central Search | String | Specify a unique name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |
Entity*
Default Value: N/A | String/Expression | Specify the OData entity object. | |
Cross Company Default Value: Deselected | Expression/Checkbox | Select this checkbox if you want to fetch the data from a company other than your default company. You can enable the expression for this field to use input values from the upstream Snap. | |
Filter condition | Use this field set to specify the filter criteria based on which the entities are returned. | ||
Type Default Value: and | Dropdown list | Select a standard OData filter logical operator. | |
Attribute Default Value: None | String/Expression | Specify a field name. The selected attribute should be of the integer type for lessThan, lessThanOrEqual, greaterThan, greaterThanOrEqual operators. | |
Operator Default Value: equal | Dropdown list | Select a standard OData filter operator. | |
Value Default Value: None | String/Expression | Specify a value. | |
Query parameter | Use this field set to define search query parameters and their values. | ||
Parameter Default Value: N/A | String/Expression | Select the standard query parameter from the list. | |
Value Default Value: N/A | Integer/Expression | Specify the value that is associated with the parameter. | |
Order by | Use this field set to to specify the order in which items are returned when the search is executed. | ||
Attribute Default Value: N/A | String/Expression | Specify/Select the attribute that you want to use to order the search results. | |
Sort order Default Value: ascending | Dropdown list | Select the sorting order. | |
Output fields | Use this field set to specify the fields you want the Snap to display in the output. | ||
Read query field Default Value: N/A | String/Expression | Specify the fields that you want to display in the output. | |
Page size Default Value: 1000 | Integer/Expression | Specify the page size to fetch records quickly for larger data sets. | |
Start page number Default Value: 1 | Integer/Expression | Specify a page number from which the loading of records should begin through 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. A value of 0 reads all the pages. | |
Number of retries Default Value: 0 | Integer/Expression | Specify the maximum number of attempts to be made to receive a response. '0' specifies that the number of retries is disabled. | |
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 specify 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:
|
Examples
Downloads
Info |
---|
|
Related Content