Do let me know if I can directly extract the data from the Text Parser module in the screenshot instead of going through the Iterator module. Thanks
These are the settings I used for the Text Parser and Iterator modules. These 2 modules are after I extract the data using the outlook email module
What you can do is,
For getting Bundle 1, You will have to use an array aggregator as Bundle Number Position doesn’t seem to be available for Text Parser Module, or alternatively, you can use the Increment function module in between the text parser and the target module and add a filter in between.
To get the required data for rows[10] and columns[12], you can simply do is use get function,
{{get(4.rows; “10.columns.2”)}}
Now, For getting the 1st bundle only, assuming that you have multiple bundles as output, simply add the increment function inbetween the text parser module and the target module, and then add a filter after the increment function,
You can use this blueprint to see how it is being done,
blueprint (49).json (7.6 KB)
You can create a new scenario and import the blueprint to see how I have done and see if that is what you have wanted.
2 Likes
Thanks @Runcorn, I tried to follow your set up but I’m not able to extract that data as per screenshots. Could you help to check to see how should I change my settings? Thanks again.
blueprint.json (9.7 KB)
Thanks @Runcorn I followed your settings but the “set variable” module is not receiving any data as per screenshot.
My bad, didn’t realize the collection was nested i.e it has rows inside rows.
Something like this,
{{get(get(map(4.rows; "columns[].rows"); 1); "1.columns.2")}}
3 Likes