Versions Compared

Key

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

...

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.

...

Download this pipeline.

Step 1: Configure the Filter condition field set with and Type to fetch the records with unitCost less than or equal to 20 and greater than 10.

...

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 RemovedImage 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.

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.

Image RemovedImage Added

Downloads

Info
  1. Download and import the pipeline into SnapLogic.

  2. Configure Snap accounts, as applicable.

  3. Provide pipeline parameters, as applicable.

...