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!
