How to extract JSON response from claygent to create multiple columns for data selection

any idea how i can get the response from claygent that I get as a JSON into another column, that I can then “reselect” into more columns? So basically I want one master column, that I can then select from and create multiple columns out of it

10 comments

Robin S.
·
·
https://app.clay.com/workspaces/9574/tables/t_kucZ2dPaYWUV/views/gv_DviXwtmdPPUH
Robin S.
·
·
The JSON can be found at the very end of the table
Clay T.
APP
·
·
Hey there Robin thanks for reaching out sorry for the delay.
Clay T.
APP
·
·
If you click on one of the cells in your Claygent column and hover over the result box, an option to "Add as Column" will appear. You can select this to move the result into a column.
Robin S.
·
·
Hey Luis! I am aware of that 🙂 but the result is in JSON format. and I’d like to basically get a column, where I have the JSON format in like a list.
Robin S.
·
·
So I can choose from this list, if I wanna create more columns.
Robin S.
·
·
Because there are 4 values inside of each JSON and I don’t wanna create 4 extra columns.
Robin S.
·
·
Hope you get what i mean 😅
Clay T.
APP
·
·
Sorry for the delay, let me take a look again.
Clay T.
APP
·
·
So you can use JSON mode in chatGPT to extract the values, so that they can be used. Here is a loom that shows how you could accomplish this. https://www.loom.com/share/317de47023fb429a80022de0f4a5d6dc