Data Type Issues with AI-Generated Company Lists in Clay S.

Hey Clay S. — need help with a “Use AI” + data type issue. I’m using “Use AI” to extract a list of company names and their website URLs into a column called “Company List”. Issue: - I set the column data type to Text since there’s no list/array type. - The AI function returns an array of objects, but in the cell it displays as [object Object],[object Object],... and throws an error when accessed. - Also noticed “Text” appears twice in the column data type dropdown. Questions: - Is there a column type that can safely store an array of JSON objects or a list of structured data? Table Url

5 comments

Channeled
APP
·
·
For structured data like arrays of JSON objects, use JSON Schema instead of Fields when setting up your Use AI column outputs. When defining outputs in Use AI: - Fields creates individual columns with basic data types (Text, Number, URL, etc.) - JSON Schema provides flexibility to define and structure complex data in JSON format This prevents the [object Object] display issue and properly handles arrays of structured data.
Sources: Use AI | Documentation | Clay University Table columns | Documentation | Clay University Mistral integration overview | Documentation | Clay University
Vivek K.
·
·
I am already using JSON schema
Vivek K.
·
·
https://app.clay.com/workspaces/264912/tables/t_0sxy3xhHMDWnZZTNmsy/views/gv_zt1blEqbtxcz
Bo (.
·
·
Hey! To handle structured data like a list of company names and URLs, switch to Content Generation under the AI enrichment use case. From there: ** Select the proper use case ** Enable JSON schema > “Generate from prompt" This ensures the output is returned as a valid JSON object and you'll save on cost because you don't need to go online to get the data you want. If you want each company to appear as a separate row, use Send Table Data or Write to Other Table to push that data into a new table. 📘 Send Table Data Guide 🎥 Video walkthrough Let me know if you have more questions.
Channeled
APP
·
·