JSON outputs for Claygent populating in random rows - second time I've seen this https://app.clay.com/workspaces/28090/workbooks/wb_0t10s7inwdzWnjvAs9T/tables/t_0t17303Pmd22Cd2dTcY/views/gv_0t17303ZUsHxoo7uvxw
JSON outputs populating in random rows typically indicates formatting or parsing issues with your Claygent configuration. To troubleshoot this effectively, could you copy and paste the JSON output that's causing issues into the chat? This will help identify specific formatting problems like missing commas, incorrect brackets, or unescaped characters. In the meantime, ensure your Claygent prompt clearly defines column outputs and instructs where each piece of information should go. Before applying to large datasets, test on a few rows first to verify the structured output is correct.
{ "type": "object", "properties": { "portfolioComplexityScore": { "type": "integer", "description": "Complexity score from 1 to 10 based on rubric." }, "complexityDrivers": { "type": "string", "description": "Comma-separated list of concrete drivers found (e.g., '40+ modules, 8 industries, GSI channel, 3 acquisitions (24 months), AppExchange presence')." }, "evidence": { "type": "string", "description": "Sources with type, URL, date if available, and short verbatim quote; separate multiple items with semicolons." } }, "required": [ "portfolioComplexityScore", "complexityDrivers", "evidence" ], "additionalProperties": false }
Your JSON schema looks properly formatted. The syntax is correct with proper brackets, commas, and quotes. Since you're experiencing random row population, the issue likely stems from your Claygent prompt configuration rather than the JSON schema itself. Ensure your prompt clearly instructs Claygent to output each field to the correct column and test on a few rows first before applying to larger datasets.
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.