Hi - I used the HTTP API to pull in data (medical reports about a specific ailment from the last 90 days). For most of the rows, there are multiple reports. I now want to pull out ALL TITLES of the returned reports alogn with ALL AUTHORS (each report has mulitple authors. I have the data in Clay but i’m struggling to extract and flatten it.
Use the Extract Values from Data integration to pull out titles and authors from your HTTP API response.
For flattening multiple reports per row, use the splitting data feature:
1. Add the "Extract Values from Data" column
2. Set your data source as the HTTP API response column
3. Choose extraction type for titles and authors separately
4. Use formulas to split comma-delimited values into separate columns
You can create separate columns for each extraction (titles, authors) and use dot notation for nested data paths like reports.title or reports.authors.
Yo Scott! I might be able to help - wanna so a screen share?
sure!
Great! For extracting titles and authors from your medical reports data, use the "Extract Values from Data" integration:
1. Add "Extract Values from Data" column
2. Set your HTTP API response as the data source
3. Create separate extractions for titles and authors
4. Use dot notation like reports.title and reports.authors for nested data
For flattening multiple reports per row, after extraction you can use the "write to table" feature to create separate rows for each report.
