...
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. | |
Company Default Value: N/A | String/Expression/Suggestion | Specify the company registered with the Business Central application. | |
Entity*
Default Value: N/A | String/Expression/Suggestion | Specify the OData entity object. | |
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/Suggestion | 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/Suggestion | Select the standard query parameter from the list. Available options are:
The value for the Parameter top in the Query parameter field set must always be less than the given Page size value. For example, if the Page size is 100, the top value can be 50 so that the Snap fetches the top fifty records from the Business Central application. | |
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/Suggestion | Specify or 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. | ||
Output field Default Value: N/A | String/Expression/Suggestion | Specify the fields that you want to display in the output. | |
Page size Default Value: 100 | 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. | |
Timeout (seconds)
Default Value: 60 | Integer | Specify the timeout to determine whether the connection is alive and also the timeout when waiting for response through a socket. | |
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:
|
Troubleshooting
Error | Reason | Resolution |
---|---|---|
Number of requests exceeded the limit of 6000 over the time window of 300 seconds | Requests exceeded the limit of 6000 over the time window of 300 seconds. | Decrease the batch size and retry. Learn more about the error messages: Service protection API limits. |
Too many Requests - 429. | There are too many requests sent to Business Central endpoint. | The Microsoft Business Central related Snaps, include |
Examples
This example pipeline demonstrates how to filter records using Filter conditions and Query parameters in the Business Central Search Snap to get the required results.
...
Configure the top parameter as follows. Configure the Attribute in the Order by field set with displayName as ascending. | On validation, the Snap displays the top five records with the unit cost between 10 and 20 with displayName in the ascending order. |
|
|
Expand
You can configure the Value in the Query parameter field set with different entities related to the items Entity. | On validation, the output displays the corresponding record for the specified entities. |
You can configure the entity with specific output fields. | On validation, the output displays only the specified field |
...
Setting | Output |
---|---|
Configure the parameter valuein the Query parameter as follows: | On validation, the Snap filters out the records with displayName = 'Glass Carafe' when unit cost is between 16 and 20. |
Downloads
Info |
---|
|
...