Join the Community

Troubleshooting AI Enrichment and Write to Table Issues

·

·

Hi there, i created an AI Enrichment / Prompt which extracts people and contact infos from websites etc, combined with dork & some more. The result is a json object with an nested contact list. I just want to use "Write to table" to create a row in a contact table for each found contact in the prompt. But it doesnt work. If i add a "WTT" Column i can not access the nested contact list in the AI Result Json to iterate. I thought that it is related to the datatype and that i need a list. So i tried to transform the contacts list from the json to another column. But this doesnt work. I also manually tried to create some testdata as a list in a new column. But everytime i try to use the "WTT" Approach the WTT doesnt recognize any list element in my table. I tried the example from the 101 training and created 10 lookalikes but my WTT does not recognize the data cells as list. What would be the best approach? What i am doing wrong?

14 comments

Channeled
APP
·
·
To create rows from your nested contact list, follow these steps: 1. Select "Write to table" from the Actions dropdown or when viewing nested data in a cell 2. Choose your destination table 3. Select the column containing your contacts list (lists are indicated by curly brackets {} in Clay) 4. Map the specific contact properties from your list to columns in the destination table 5. Optionally, add any additional data points from the current table Make sure your AI result is properly formatted as a list with curly brackets. If you're still having issues, please share your JSON structure so I can help troubleshoot further.
Sources: Write to Table [Clay 101] - Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Tim R.
·
·
This is my current json output schema: { "type": "object", "properties": { "contacts": { "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "jobtitle": { "type": "string" }, "hobbies_interests": { "type": "string" }, "phone": { "type": "string" }, "mobile": { "type": "string" }, "email": { "type": "string" }, "email_source": { "type": "string", "enum": [ "Scraped", "Dorked", "Estimated" ] }, "linkedin_profile": { "type": "string" }, "facebook_profile": { "type": "string" }, "instagram_profile": { "type": "string" }, "xing_profile": { "type": "string" }, "twitter_profile": { "type": "string" }, "public_mentions": { "type": "string" }, "referenced_news_events": { "type": "string" }, "mutual_interests": { "type": "string" }, "needs_opportunities": { "type": "string" } }, "required": [ "name", "jobtitle", "email", "email_source" ], "additionalProperties": false } } }, "required": [ "contacts" ], "additionalProperties": false }
Channeled
APP
·
·
To create a row for each contact in your nested JSON array: 1. Make sure your AI output is properly formatted as a list (indicated by curly brackets {} in Clay) 2. Select "Write to table" from the Actions dropdown or when viewing the nested data in a cell 3. Choose your destination table 4. Select the column containing your contacts list 5. Map the specific contact properties (name, email, etc.) to columns in your destination table If your JSON isn't being recognized as a list, verify that the "contacts" array is properly formatted in the output.
Sources: Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University Write to Other Table | Documentation | Clay University
Tim R.
·
·
i tried to extract the data into another columsn: JSON.stringify(({{Ex Contact Broad}}?.contacts || []).flat()) But the WTT Columns doesnt recognize the data as the list.
Channeled
APP
·
·
For write to table to recognize your contacts list: 1. Make sure your JSON output has the contacts array properly formatted with curly brackets {} in Clay 2. When setting up write to table: • Select the column containing your contacts list • Choose the specific contact properties to map to your destination table If JSON.stringify is causing issues, try accessing the raw contacts array directly without transformations. Could you share your complete JSON output so I can help troubleshoot further?
Sources: Write to Other Table | Documentation | Clay University Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University
Tim R.
·
·
Give the example plz for my json output
Channeled
APP
·
Based on your JSON schema, here's how to set up write to table for your contacts array: 1. Select "Write to table" from the Actions dropdown 2. Choose your destination table (or create a new one) 3. Select the column containing your contacts array (the one with your AI output) 4. Map the contact properties to columns in your destination table: • name → Name column • jobtitle → Job Title column • email → Email column • etc. Make sure your AI output is properly formatted as a list with contacts in this structure: LBKS{ "contacts": [ { "name": "John Doe", "jobtitle": "CEO", "email": "[john@example.com](mailto:john@example.com)", "email_source": "Scraped" }, { "name": "Jane Smith", ... } ] }LBKS
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University
Tim R.
·
·
here is my table: https://app.clay.com/workspaces/619857/workbooks/wb_0sx2dxmq9JeEs4RkSuf/tables/t_0sx2e3sEWukWhEcRTtj/views/gv_0sx2e3tTJv7UeTF5ENt
Tim R.
·
·
Ist a workbook
Tim R.
·
·
In the columns "Ex Contact Broad" i want to extract the data from the web and in the column "Write to othet table" i tried to generate data entries in the contacts tab.
Tim R.
·
·
I am in germany and may be we can talk later
Tim R.
·
·
Where and how can i talk with a person?:-)
Smit V.
·
·
Hi Tim, apologies for the delay in response! I believe you were able to send the rows to the new table successfully. Are you still looking for help?
(84 kB)
Let me know and I'd be happy to help you further!
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.

Troubleshooting AI Enrichment and Write to Table Issues | Clay