.png){kind=logo}
Transforming Group Columns from API Results into Row Records
I have HTTP webhook API results which contains a dozen group columns inside of the cell, what's the easiest way to move each group column out as a row record?
I have HTTP webhook API results which contains a dozen group columns inside of the cell, what's the easiest way to move each group column out as a row record?
To transform HTTP webhook API results with grouped columns inside a cell into separate records, you have two options: 1. For comma-separated data:
• Use the "Extract Data From Values" feature
• Add a new column using the "/" command
• Apply a custom regex: [^,"]+"?[^,"]+ to split the values into a list
2. For nested endpoints/arrays:
• Click on the cell containing the enrichment data
• In the "Cell details" panel that appears on the right
• Hover over the specific endpoint you want to extract
• Click "Add as column"
• Enter a column description and create the new columnThis will map out the grouped data into individual columns for easier management.
Sources:
Write to table integration overview | Documentation | Clay University
Table columns overview | Documentation | Clay University
let me rephrase it, a HTTP API result has 12 groups in it, I want to move the 12 groups out and its own independent row object in different tables. How do I do that?
To split the 12 groups from your HTTP API result into separate rows across different tables, follow these steps: 1. First, click on the cell containing the HTTP API response with the 12 groups. This will open the Cell details panel on the right. 2. For each group you want to extract: • Hover over the specific group endpoint in the Cell details panel • Click "Add as column" when the option appears • Enter a description for the new column • Click "Create column" 3. Once you have created separate columns for each group, you can then use these columns to create new rows in different tables using the Write to Table integration. Source: Table columns overview | Documentation | Clay University
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hey team, im using HTTP webhook to retrive data and what's the best way to move the groups out of http results? For example, there are 7 groups inside of the HTTP response and I want to move them out as individual Row value, and only THEN create columns based off data available inside of these gorup.
OH I got it working, but still need help! I'm able to create each item to new row in other table, but is there a way to write the entire group column?
Hey Andideng - Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1737073800&signature=17035e1ffecb8002cafc1435016f9e97d6dff9c8888bd59f079656db20989722&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSz8AZQe2BKsam%2FhVPsDUQ%3D%3D%0A
Thanks Bo, here's the master table where I have "200" http pull results https://app.clay.com/workspaces/449716/workbooks/wb_RrFKxUfBuRDb/tables/t_cyhACKZ2yZBB/views/gv_m8i8Ubcco5Bv Here's the write to table: https://app.clay.com/workspaces/449716/workbooks/wb_RrFKxUfBuRDb/tables/t_v3TtuphjHeHV/views/gv_CoVbYz9cM6FG So instead of writing column by column, I'm trying to write each group inside for 200 http pull results
Hey Andideng! Thanks for sharing. Happy to help✨. Just to confirm, within that list of results in your table, you want to extract each item into separate rows but grouped into different columns in the table? That is, all results nested in the list will be extracted into the other table, but they will all be grouped under the same column. For example, if all items in the list have a "name", all names extracted will be in a separate column called "Name"? I made a quick video sharing how the list option in the "write to table" column works. Let me know if that's what you're trying to set up. https://www.loom.com/share/bb1b3130ad4f4f8b82bfdbbc22b7a3ce
Thanks Daniella! Really appreciate you for making the loom but still need help! So instead of mapping out each column like you did, is there a way to map entire groups? For example, there would be a dozen “names” in a single “200” cell in my parent column, and under each “name”, there are a dozen more child-column underneath them (employment history, current job title, contact description, etc). AND there is another level of child-of-child column under each employment history (start date, end date, employer name, etc..) “200” —> 12 contact names —> employment history, current company, LinkedIn URL, etc —> (under employment history) start date, end date, previous employer names, etc —> the actual start date, name, etc, for each previous employer A total of 4 layers. So mapping out each column individually would be really really hard as I’ll need to do that manually for maybe 40-50 columns? 😂 is there a systematic way to push the groups over to a new table?
Hey there Andi thanks for reaching out, made loom video explaining how we can do this. https://www.loom.com/share/c2b87b71979749cfa6eb1865ef15dd50?sid=07dc6ea9-75e6-4cc8-b252-171eb89a96b9
Hey Luis! Thanks again! But that’s still mapping each value individually one by one. For my purpose I need to move 12 contacts from 1 HTTP Webhook cell, and 5-7 work experience per contact, and 3-5 additional values within each experience. So I’ll just have to manually map about 40 values one by one I guess?
Which is totally fine I just thought there would be a way to move groups out at once!
Yea at the moment with the Write to table you would need to map out each value.
Ah understood! Thanks for trying Luis!