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
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.
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.
