Forum Discussion

TWCMG's avatar
TWCMG
New Contributor II
3 years ago

Designing a pipeline to route depending if there is or is not data in an initial query

Hi, I am trying to design a pipeline where it initially will pull in a query result set. I am trying to create a route that identifies whether the query result set returned records or did not retur...
pipeline
darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago

Hi @TWCMG,

Welcome to the community. You can add a “mapper” snap after fetching your query result with the following expression:

After the mapper snap, have a “router” snap with the conditions:

  1. $UpdatedRecords > 0
  2. $UpdatedRecords < 0

NOTE: You can put any name instead of $UpdatedRecords, it could be $xyz / $counts / etc.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    3 years ago

    I think when you execute a query and you don’t have any results, you will get an empty object on the output, or just the original object if the Execute snap has an input.

    In this case, you can check for a specific field that you know that exists in the result set.
    Example: $.hasPath(‘timestamp’)