What are you trying to achieve?
I’m getting a JSON result from an HTTP request and I’m trying to access the individual results within each nested collection. I can’t figure it out.
For example, I’d like to get the email address, listed under email:, to then search in Google Sheets for that specific email. From there, I’d like to then update the row with the remainder of the information from within the respective JSON result (i.e. is_disabled, is_deliverable, etc.).
Screenshots: scenario setup, module configuration, errors
json-sample-response.json (1.46 KB)
1 Like
Hi @mattchoo
Since the output is not an array format, you can simply map the required fields.
If the variables inside collection is not shown in display, you can use the get() function to map values inside the collection.
Between, the blueprint is not loading in Make.
If the above solution does not work, please share the JSON output from output bundle:
Regards,
Msquare Automation - Gold Partner of Make
Book a Free Consultation | Connect Live
Explore our YouTube Channel for valuable insights and updates!
Welcome to the Make community!
You can simply put this in an iterator module:
{{ map(toArray(1.results); "key") }}
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
Help Center Basics
Articles & Videos
Partner & Custom Apps
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
