Integrating JSON Schema for SELECT Function in Prompts

·Oct 22, 2025 01:29 PM·

Share

Hi guys, I've made a prompt and I've created one of the outputs using the JSON schema to basically make it a SELECT function. So it seems in the prompt it looks good, but then when I run it, it outputs it as a text. When I add the output as a column, it keeps it as a text. Is there a way to add it as the actual SELECT function that I've got in the original prompt? I got it on a couple of things, one of them has 8 outputs, and there is quite a lot of effort to add them all individually for multiple outputs. any way to add the select column straight from the prompt?

3 comments

· Sorted by Oldest

Clay Support
APP
·
·
You need to manually change the column data type after the AI outputs the data. When you define outputs in your prompt using JSON schema or Fields, the AI creates the column structure, but the actual data type needs to be set separately. [1]
To change your column to a Select data type:
1.
Click on the column header to access the dropdown menu
2.
Select "Edit column"
3.
Click on the gear icon and change the data type from Text to Select
4.
Press "Save settings" [2]
Unfortunately, there's no direct way to automatically create Select columns with predefined options straight from the AI prompt output - you'll need to manually convert each text column to Select type and configure the options.
1
Clay Support
APP
·
·
Did that answer your question?
1
Clay Support
APP
·
·
If you still need help with setting up your Select columns or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so we can continue?

Clay Support
APP
·
·
You need to manually change the column data type after the AI outputs the data. When you define outputs in your prompt using JSON schema or Fields, the AI creates the column structure, but the actual data type needs to be set separately. [1]
To change your column to a Select data type:
1.
Click on the column header to access the dropdown menu
2.
Select "Edit column"
3.
Click on the gear icon and change the data type from Text to Select
4.
Press "Save settings" [2]
Unfortunately, there's no direct way to automatically create Select columns with predefined options straight from the AI prompt output - you'll need to manually convert each text column to Select type and configure the options.
1
Clay Support
APP
·
·
Did that answer your question?
1
Clay Support
APP
·
·
If you still need help with setting up your Select columns or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so we can continue?