All good, by putting eval($pattern) will accept the regex pattern.
@viktor_n Thanks for your response. I have created and uploaded file and used it as you have shown but I am unable to understand how in the expressions I can read those three values and trigger one pipeline for each value. Could you please give some inputs on this?
To be able to write expressions, this box needs to be checked.
This would return the data inside the file.
When you come to this point you can use .values() function, that will return list of the values.
With JSON Splitter snap you could split that list and set this values inside the Pipeline Execute.
Hey @Dai9210,
Here’s one solution for you:
Default Values_2021_09_27.slp (8.6 KB)
The pipeline sends all records in an array. That array is joined with the default values 1=1. Right after, follows a mapper with expression that maps the $group array, and within that map, there’s a nested .mapValues() function that checks if the key is in the incoming document (apart from the $group). If it is map Its value, if not , keep the actual one. After the mapping is done, jsonSplitter will split the $group.
Regards,
Bojan
It works!
Thanks very much! @bojanvelevski
REST snap errors when passing in variables for HTTP Entity and Service URL | SnapLogic - Integration Nation - 9265
