Clay Icon

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

  • Avatar of Robin S.
    Robin S.
    ·
    ·

    The JSON can be found at the very end of the table

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey there Robin thanks for reaching out sorry for the delay.

  • Avatar of Clay T.
    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.

  • Avatar of Robin S.
    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.

  • Avatar of Robin S.
    Robin S.
    ·
    ·

    So I can choose from this list, if I wanna create more columns.

  • Avatar of Robin S.
    Robin S.
    ·
    ·

    Because there are 4 values inside of each JSON and I don’t wanna create 4 extra columns.

  • Avatar of Robin S.
    Robin S.
    ·
    ·

    Hope you get what i mean 😅

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Sorry for the delay, let me take a look again.

  • Avatar of Clay T.
    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