cancel
Showing results for 
Search instead for 
Did you mean: 

Performing an Action when there is no data

ncrouch
Former Employee

A common integration pattern is to do something when no data is received. For example, we might read a file, parse it, and find that no records meet some filter criteria. As a result, we might send an email, or insert a ticket into a ticket management system like ServiceNOW.

However, in SnapLogic, this can be somewhat more difficult than it seems initially because of the streaming architecture. In fact, many snaps will not execute without input documents - rather hard to accomplish when there is no document to flow through:
0009551e1aa0ae88952d21fed89d11c27601ac83.png

So, how can we take an action, even though there’s no document to run the snap?

The trick is to make a document and force it into the stream with a Join Snap (set to Merge):
9d8ad9e24b2954b4dc66922f66f086d20b03fb6f.png
73eeae9d226276e393707cc64ae6c08873b03b7b.png
3a494da1ff3b5a4737a8f7ccd3ccf70903ec211a.png
Note in this figure that even though nothing flows into the top view of the Join Snap, it still produces an output.

This enables us to use the Router snap to check whether or not a field that we know will exist in the source does in fact exist. If it does, we know that data has passed through the Filter snap and then been merged with the Sequence data. If it does not, we know that only the Sequence data has been passed through and therefore nothing made it through the Filter. Only one of these views will have anything pass through it.

The magic here is in the Merge option in the Join snap. As long as it is receiving data on a view, it will output - even if it has nothing to ‘join’ to. Meanwhile, the Sequence snap will always output the number of documents that you set it to. In this case, only one is required.

(This pipeline here: Do something after no doc filter_2017_04_26.slp (11.1 KB) )

14 REPLIES 14

Abhi
New Contributor

" This enables us to use the Router snap to check whether or not a field that we know will exist in the source does in fact exist "

Well what happen if we are not sure which field is coming out of source i.e field name is not fixed ?

You can use eval() to dynamically check for the existence of a property.

This expression $.hasOwnProperty(eval('$dynamicKey')) checks for the existence of the key dynamicKey in the input document.

ash42
New Contributor III

hey I also tried using the
image
so had a doubt will this cause it to execute this snap multiple time?

sdoscher
New Contributor III

@ash42 this will not cause the snap to execute multiple times. What you see there means that the snap before this is passing multiple documents TO the router. The router will “route” the multiple documents downstream according to the rules configured in the router.

ChristopheFr
New Contributor II

Hello,
Thanks for the solution. I use it in some cases.

But I have a pipe where the datasource are variables (queries on a DB). In that case, it could not work.
Do you have any idea ?
Thanks.