Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The Company field in the Business Central Search Snap is optional for specific entities, such as Subscriptions, and it is mandatory for the remaining entities. Therefore, if the field is left blank, the Snap displays the following error: Error while executing the request.

    Image RemovedImage Added

    Workaround: Specify the Company name for entities where it is mandatory.

  • When fetching Read related entities in the Business Central Search Snap for a specific Entity with selected Output fields, the Snap displays an error if you do not specify all the key fields in the Output fields section.

    Error: Unexpected end-of-input: expected close marker for Object.

    Workaround: Ensure you provide all the key fields in the Output fields.

  • The Business Central Search Snap does not support the following entities. The Snap displays an error when you configure with these entities.

...

Field Name

Field Type

Description

Label*

 

Default ValueDynamics 365 Business Central Search
Example: 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
ExampleCRONUS USA Inc.

String/Expression/Suggestion

Specify the company registered with the Business Central application.

Entity*

 

Default Value: N/A
Example: items

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 Valueand
Exampleor

Dropdown list

Select a standard OData filter logical operator.

Attribute

Default Value: None
ExampleunitPrice

String/Expression/Suggestion

Specify a field name.

The selected attribute should be of the integer type for lessThan, lessThanOrEqual, greaterThan, greaterThanOrEqual operators.

Operator

Default Valueequal
ExamplelessThan

Dropdown list

Select a standard OData filter operator.

Value

Default Value: None
Example20

String/Expression

Specify a value.

Query parameter

Use this field set to define search query parameters and their values.

Parameter

Default Value: N/A
Exampleexpand

String/Expression/Suggestion

Select the standard query parameter from the list. Available options are:

  • top

  • expand

  • filter

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
ExampleitemCategory

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
Example: Name 

String/Expression/Suggestion

Specify or select the attribute that you want to use to order the search results.

Sort order

Default Valueascending
Exampledescending

Dropdown list

Select the sorting order.

  • ascending

  • descending

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
Exampleinventory

String/Expression/Suggestion

Specify the fields that you want to display in the output.

Error out on no results

Default Value: Deselected

Checkbox

Select this checkbox to display the original document along with an the error message No records found in the error view if no records are returned for a the selected criteria.

  • If you deselect the checkbox, the Snap ignores the empty results and shows nothing in the output view.

Page size

Default Value100
Example200

Integer/Expression

Specify the page size to fetch records quickly for larger data sets.

Start page number

Default Value1
Example10

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 Value0
Example10

Integer/Expression

Specify the page number after which the Snap should stop loading.

A value of 0 reads all the pages.

Timeout (seconds)

 

Default Value60
Example: 100

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 Value0
Example5

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 Value1
Example5

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
ExampleAccept

String/Expression

Specify the key for the HTTP header.

Value

Default Value: N/A
Exampleapplication/json;odata.metadata=full

String/Expression

Specify the value for the HTTP header.

Snap Execution

Default ValueExecute only
Example: Validate & Execute

Dropdown list

Select one of the following three modes in which the Snap executes:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during pipeline runtime.

  • Execute only: Performs full execution of the Snap during pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

...

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.

 

Image RemovedDynamics 365 Business Central Search_Examples_Step2.pngImage Added

 

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.

Image RemovedDynamics 365 Business Central Search_Examples_Step2__Expand.pngImage AddedImage RemovedDynamics 365 Business Central Search_Examples_Step2__Expand__Output0.pngImage Added

You can configure the entity with specific output fields.

On validation, the output displays only the specified field.

Image RemovedDynamics 365 Business Central Search_Examples_Step2__xxx.pngImage Added

Filter

Setting

Output

Configure the parameter valuein the Query parameter as follows:

On validation, the Snap filters out the records with displayName = 'Glass Carafe' when the unit cost is between 16 and 20.

Image RemovedDynamics 365 Business Central Search_Examples_Step2_Filter.pngImage Added

Downloads

Info
  1. Download and import the pipeline into the SnapLogic Platform.

  2. Configure Snap accounts, as applicable.

  3. Provide pipeline parameters, as applicable.

...

Expand

Insert excerpt
Microsoft Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central
nameMicrosoft Dynamics 365 Business Central
nopaneltrue

Related Content

...

...