Extract specific values from JSON and pass it on the next steps

[KMag]

I am trying to extract targets from this JSON and trying to pass each value separately in another step. What’s the best way I can do this?

Simple Parse JSON doesn’t work since the raw JSOn from initial data is wrapped inside multiple collections and arrays.

Blueprint:

blueprint.json (32.1 KB)

[samliew]

Welcome to the Make community!

Yes, you should be able to use Parse Response in the HTTP module.

Then, use the map function to get the array of items into an Iterator module.

e.g.:

{{ first(map(1.data.tasks; "result.1.items")) }}

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.

[KMag]

@samliew

{{ first(map(1.data.tasks; "result.1.items")) }}

Thanks Samliew. But I still can’t select just the targets to insert on my next module.

[samliew]

I see what you’re trying to do now.

You can directly map the targets from the first result, then, use the join function to convert it into a JSON array of strings.

["{{join(map(48.data.tasks[].result[].items; "target"); """,""")}}"]

Output:

Then you can map the variable containing the JSON array like this:

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.