Hi Clay support team, whenever I use AI to generate a prompt, it gives me the suggested output in JSON schema not FIELD. Even though I instructed AI to give me output in FIELD and not JSON schema but still I got it in JSON schema. Help me to get my prompt output in FIELD.
When setting up your Use AI enrichment, you need to configure the output format in the "Add and define outputs" section. There are two options available: • Fields - Enter field names in the text field and select the appropriate data type for each output field using the dropdown menu • JSON Schema - For structured JSON output Make sure you're selecting Fields instead of JSON Schema in this section when configuring your enrichment. The output format is controlled by this setting, not just the prompt instructions. If you're still getting JSON output after selecting Fields, please copy and paste your current JSON output into the chat so I can help troubleshoot the specific formatting issue.
{ "type": "object", "properties": { "Person": { "type": "object", "properties": { "FullName": { "type": "string" }, "FirstName": { "type": "string" }, "LastName": { "type": "string" }, "JobTitle": { "type": "string" }, "LinkedInProfile": { "type": "string" } }, "required": [ "FullName", "FirstName", "LastName", "JobTitle", "LinkedInProfile" ] }, "Company": { "type": "object", "properties": { "Domain": { "type": "string" }, "FromCompanyTableData": { "type": "string" } }, "required": [ "Domain", "FromCompanyTableData" ] }, "Person_Achievements": { "type": "array", "items": { "type": "object", "properties": { "title": { "type": "string" }, "summary": { "type": "string" }, "date": { "type": "string" }, "source_url": { "type": "string" } }, "required": [ "title", "summary", "date", "source_url" ] } }, "Company_Recent_Funding": { "type": "array", "items": { "type": "object", "properties": { "round": { "type": "string" }, "amount": { "type": "string" }, "date": { "type": "string" }, "investors": { "type": "array", "items": { "type": "string" } }, "source_url": { "type": "string" } }, "required": [ "round", "amount", "date", "investors", "source_url" ] } }, "Company_Recent_Hiring": { "type": "array", "items": { "type": "object", "properties": { "hire": { "type": "string" }, "role": { "type": "string" }, "date": { "type": "string" }, "source_url": { "type": "string" } }, "required": [ "hire", "role", "date", "source_url" ] } }, "Company_Rebranding_Campaigns": { "type": "array", "items": { "type": "object", "properties": { "summary": { "type": "string" }, "date": { "type": "string" }, "source_url": { "type": "string" } }, "required": [ "summary", "date", "source_url" ] } }, "Company_Open_Positions": { "type": "array", "items": { "type": "object", "properties": { "title": { "type": "string" }, "team": { "type": "string" }, "location": { "type": "string" }, "source_url": { "type": "string" }, "date_accessed": { "type": "string" } }, "required": [ "title", "team", "location", "source_url", "date_accessed" ] } }, "Company_Rapid_Expansions": { "type": "array", "items": { "type": "object", "properties": { "summary": { "type": "string" }, "date": { "type": "string" }, "source_url": { "type": "string" } }, "required": [ "summary", "date", "source_url" ] } }, "Company_New_Launches": { "type": "array", "items": { "type": "object", "properties": { "product_or_feature": { "type": "string" }, "date": { "type": "string" }, "source_url": { "type": "string" } }, "required": [ "product_or_feature", "date", "source_url" ] } }, "Company_Web_Design_Flaws": { "type": "array", "items": { "type": "object", "properties": { "page_url": { "type": "string" }, "issue": { "type": "string" }, "evidence": { "type": "string" }, "date_accessed": { "type": "string" } }, "required": [ "page_url", "issue", "evidence", "date_accessed" ] } }, "Research_Metadata": { "type": "object", "properties": { "research_date": { "type": "string" }, "notes": { "type": "string" } }, "required": [ "research_date", "notes" ] } }, "required": [ "Person", "Company", "Person_Achievements", "Company_Recent_Funding", "Company_Recent_Hiring", "Company_Rebranding_Campaigns", "Company_Open_Positions", "Company_Rapid_Expansions", "Company_New_Launches", "Company_Web_Design_Flaws", "Research_Metadata" ] }
Looking at your JSON schema, you need to convert this to individual Fields format. In the "Add and define outputs" section, select Fields instead of JSON Schema. For each field in your schema, create separate field entries: ** FullName (Text) ** FirstName (Text) ** LastName (Text) ** JobTitle (Text) ** LinkedInProfile (URL) ** Domain (Text) * FromCompanyTableData (Text) For arrays like Person_Achievements, Company_Recent_Funding, etc., you'll need to structure these as individual text fields or consider if you actually need the JSON Schema format for this complex nested data structure. The Fields option works best for straightforward data extraction into individual columns, while JSON Schema is designed for complex structured data like yours.
Umer - Do you mind sending the link (url) to the table so we can take a look?
