Extracting Nested Array Values for Subsequent API Calls | Clay

Extracting Nested Array Values for Subsequent API Calls

Clay S. I have one http response, where i have more than one item in array and under each item i have nested array too, how to get the value of each nested item in next API call

7 comments

Channeled
APP
·
·
To retrieve values from nested arrays in an HTTP response for use in the next API call, you can use the "Field Paths to Return" option in our HTTP API integration. Here's how: 1. In your HTTP API column settings, locate the "Field Paths to Return" field. 2. Use dot notation to specify the paths to the nested items you want to retrieve. For example: "object1.object2.name" for nested objects, or "array1[0].nestedArray[1]" for nested arrays. 3. Separate multiple field paths with commas. This approach allows you to extract specific nested values from complex JSON responses. If you're experiencing any JSON-related issues, please copy and paste your JSON into the chat so we can troubleshoot further.
Sources: HTTP API with Clay HTTP API with JWT authentication | Documentation | Clay University HTTP API integration overview | Documentation | Clay University
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
George D.
·
·
Hey Rafiq - Do you have a table where this data exists that we can take a look at? Typically what you can do when data is returned is click into a cell, navigate to the right data point and click "Add to Column" but happy to help guide you with some screenshots if you have the actual table.
Rafiq K.
·
·
Clay S. is there anyone available to connect with me on zoom call, i am new to clay i am finding to use loop and nested loop in clay
Rafiq K.
·
·
not getting proper response over chat or on slack
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.