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?
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.
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:
This will allow others to better assist you. Thanks!
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.
I just wanna quickly step in and say congrats on solving this one
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.