Stuck at trying to extract data from Iterator

When asking your question, please include:

:footprints: The steps you have taken
:camera_flash: Relevant screenshots
:link: Any links you have
[ Code { "and": "JSON", "in" : "code block"} ]
:x: Exclude Personal Information.

Hi, I need help here on how to extract the data from the Iterator module under Bundle 1> rows[10] > columns [2]

Thanks for your help and time :slight_smile:

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

Screenshot 2023-07-15 at 10.20.03 PM
Screenshot 2023-07-15 at 10.19.26 PM

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”)}}

Screenshot from 2023-07-16 13-22-24

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.

1 Like

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)

Just use,


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")}}

Screenshot from 2023-07-17 18-29-50

1 Like