How do I take a JSON response that has multiple records inside it and write each record "within" the JSON to a new row in a clay table? I tried the write to table feature, but it's writing the entire JSON value to the column, and I want multiple rows written, one for each record in the JSON
To write each record from a JSON response to new rows in a Clay table, you can use the "write to table" feature. Here's how: 1. Select your Clay account and choose the destination table. 2. In the "Select a list from a column" field, enter "/" to skip list selection. 3. Map the JSON object paths to the appropriate columns in your destination table. 4. If your JSON is in an array format, select the array column to be mapped. This approach will create individual rows for each record in your JSON response, rather than writing the entire JSON to a single column. If you need more specific guidance, please share your JSON structure so we can provide a more tailored solution.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
This actually didn't work unfortunately. The JSON looks like this:
.png){kind=logo}
[
{
"Company Name": "Microsoft",
"Domain Name": "microsoft.com",
"Employee Size": 122078,
"Annual Revenue": "$196.2B",
"Year Founded": "1975",
"Industry": "Software"
},
{
....
}
]To write each record from your JSON array into individual rows in a Clay table, you can use our "write to table" feature. Here's how: 1. Select your Clay account and choose the destination table. 2. In the "Select a list from a column" field, enter "/" to skip list selection. 3. Map the JSON object paths to the appropriate columns in your destination table. For example: • "Company Name" to Company Name column • "Domain Name" to Domain Name column • "Employee Size" to Employee Size column • etc. 4. Select the column containing your JSON array to be mapped. This approach will create individual rows for each record in your JSON array, writing the values to their respective columns.
Hey Malik - I recorded this walkthrough video with two different options showing exactly how to set this up: https://cln.sh/0NmWBJVV Let me know if you have any follow-up questions!
Thanks, let me take a look.
Hey Bo (. I watched your walkthrough and it was helpful. I have a similar use case but mildly diferent. I have a JSON containing between 1 and 3 different records (contacts). I want to create a new row for each record in a different table (or better yet different tab/table within same workbook), and match it with the rest of the data in the row. Is there a sort of iterator mechanism I could do this with? So far what I tried only lets me create 1 row. Here is the JSON: { "leads": [ { "first_name": "Mariana", "last_name": "Barros", "title": "Marketing Manager", "email": "", "company_name": "BarBurrito Restaurants Inc.", "company_domain": "barburrito.ca", "reasoning_for": [ { "reason": "Identified as the Marketing Manager at BarBurrito Restaurants Inc.", "source": "Management Team at RocketReach", "verified_in_current_experience": true, "confidence_score": "8/10" } ], "reasoning_against": [ { "reason": "No available email address found for direct contact.", "source": "RocketReach", "verified_in_current_experience": false, "confidence_score": "5/10" } ], "is_good_lead": "Yes" }, { "first_name": "Sameer", "last_name": "Lalji", "title": "Senior Vice President", "email": "", "company_name": "BarBurrito Restaurants Inc.", "company_domain": "barburrito.ca", "reasoning_for": [ { "reason": "Positioned as the Senior Vice President in the organization, likely involved in marketing decisions.", "source": "Management Team at RocketReach", "verified_in_current_experience": true, "confidence_score": "9/10" } ], "reasoning_against": [ { "reason": "No email provided to establish contact.", "source": "RocketReach", "verified_in_current_experience": false, "confidence_score": "5/10" } ], "is_good_lead": "Yes" }, { "first_name": "Colette", "last_name": "MacLean", "title": "Chief Technology Officer", "email": "", "company_name": "BarBurrito Restaurants Inc.", "company_domain": "barburrito.ca", "reasoning_for": [ { "reason": "Her position suggests involvement in marketing technology initiatives.", "source": "The Org", "verified_in_current_experience": true, "confidence_score": "7/10" } ], "reasoning_against": [ { "reason": "Mainly focused on technology solutions, not direct marketing roles.", "source": "The Org", "verified_in_current_experience": true, "confidence_score": "6/10" } ], "is_good_lead": "No" } ] } Link to the table: https://app.clay.com/workspaces/10501/tables/t_JEFkEEngxFvs/views/gv_Tz6faMofwTXm thanks for your help!
Please disregard, just got this to work but seems I can’t delete the message
Hello Malik! Glad to hear you got it to work! I'll go ahead and close this ticket out. If you have any questions, please don't hesitate to reach out. We'd be happy to help :)