Parsing collection from bundle

[Roger_Jay]

Hello

This one has been asked, but I don’t seem to be able to reproduce a solution
I am extracting clinical trial data using and HTTP module (not parsed by the module) for a study on eligibility criteria (that can’t be dowloaded)

Here I extracted 3, but I could ask for more. I then parse them and they come as one bundle that contains an array of studies that contains one collection for each study (I tried autoparse from the HTTP module, it comes kind of the same but with more nesting levels)

If it hen try to output that in a Google spreadsheet, I only get the first study.

If I had an iterator, i still only get one study

and i can’t really choose the fields to include in the spreadsheet

Am i missing a module?

Thank you

R

blueprint.json (29.8 KB)

[Roger_Jay]

I made it work, i was not iterating on the right value!

[samliew]

Welcome to the Make community!

You should not need the Parse JSON module if you have set the HTTP module to do the parsing of the response for you.

To do this, in your HTTP module settings “Parse response” field, select “YES” (it is “No” by default)

This will allow you to map the response collection properties (variables) in subsequent modules.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.