Iterate multiple collections from an unique bundle

Hi, I receive scraped data from the PhantomHunter module. This text data is extracted using a PARSE JSON module.
I get a single bundle output, which contains multiple collections. Each collection pertains to a company and its contact information.
I want to iterate over each of the collections so that I can add them to a Google Sheets.

I can’t seem to figure out how to do it because in the ITERATOR module, I can’t select the array that contains all the collections… How can I do this, please?



Welcome to the Make community!

Could you please share screenshots of the module fields and filters in question? It would really help other community members to see what you’re looking at.

You can also export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (12.3 KB)

If possible, could you also please provide the input/output bundles of the modules by running the scenario, then clicking the bubble on the top-right of each module, taking screenshots of, and copying the contents into this discussion thread:

Screenshot_2023-08-29_100800

This will allow others to better assist you. Thanks!

2 Likes

Hi @Felix_Guerini ,

You shouldn’t need an iterator at all. Just connect your Google Sheets module straight to the Parse JSON module.

If a module returns more than one bundle, then Make will automatically process each bundle in turn.

Let us know how it goes.

2 Likes

I found a solution : I simply wrapped the JSON with {“value”: ______ } to insert an array containing all the collections of the bundle. This array allows me to use an ITERATOR.


2 Likes

Heya @Felix_Guerini welcome to the community :wave:

I just wanna quickly step in and say congrats on solving this one :muscle:

Also, thanks a lot for remembering to share your insights with us and marking them as a solution. This helps keep our community organized and makes it easy for those who might be searching for similar information in the future. :pray: