Hi
I have the following scenario (the 1st route is not necessary for now):
The first step is to read a JSON. With this flow, I create a list of IDs for each one of the Google Sheet steps.
However, I need to list IDs only if I can find two sets of terms in a specific field in all JSON items.
From the flow above, I can only find this specific field when creating filters between the second router and the aggregator and between the Array Aggregator and Google Sheets.
When I create the following filter between Router and Array Aggregator:
I have the error message when processing the Google Sheets step: Function ‘prepareBodyForInsert’ finished with error! Cannot read properties of undefined (reading ‘match’) (and Output bundle 0kb)
When I have the same filter between Aggregator and Google Sheets, I get zero results (no Output Bundle, once Google Sheet doesn’t process).
Important: flow with no filter works fine!
Blueprint:
blueprint.json (40.5 KB)
Output Bundle files to support:
Iterator Bundle.txt (1.5 MB)
array-agreggator.txt (66 Bytes)
array aggregator pre-filter.txt (250.1 KB)
Acesso Ficha.txt (1.8 MB)
Any help?