Forum Discussion

rpc1235x's avatar
rpc1235x
New Contributor II
2 years ago

Filter nested object based on NULL/EMPTY or not

Hello,

I have a nested JSON object that I want to divide in two streams. Filtering based on if "account-allocations" is NULL/EMPTY or not. Both streams coming from the same pipeline and eventually merging. 

See example:

1) JSON OBJECT

2) WHEN YOU EXPAND THE FIRST ID, YOU CAN SEE THAT FOR THIS CASE "account-allocations" is empty

3) FOR THE SECOND ID, "account-allocations" is not empty (two nested entries in this case)

 

I tried the Filter snap, but couldn't make it work

 

Thank you!

#Filter #Pipeline #FilterExpression