Clay Icon
Join the Community
02 Support

Using JSON Data for Column Input in Your Project

Avatar of Joel M.Joel M.
·
·

I sourced a list from claude that was returned to me in json. Can I input json as a source that I can then place into their respective columns?

10 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can input JSON as a source in Clay and map it to respective columns. We have a feature called "write to table" that allows you to do this. Here's a brief overview of how you can do it: 1. Select your Clay account 2. Choose a destination table 3. Skip the list selection by entering "/" 4. Map the JSON data to columns in your destination table 5. (Optional) Configure run settings like auto-update You can parse your JSON array into an existing table or create a new one, writing your array of objects into individual rows. For a detailed walkthrough, including how to format JSON inputs, you might find our video tutorial on the "write to table" feature helpful.

  • Avatar of Stefano
    Stefano
    ·
    ·

    Hi Joel, thank you for reaching out. Were you able to get your answer to the query?

  • Avatar of Joel M.
    Joel M.
    ·
    ·

    mostly, now I am trying to write the data to a new table

  • Avatar of Stefano
    Stefano
    ·
    ·

    In order to export the rows from one table to the other, select "Actions"> "Write to Other table"

    (99 kB)
    Image

    In the menu that pops up under "Select Table to Write to" choose what table you would like to send this information to.

    (255 kB)
    Image

    Then, leave the "Select a list from a column" field blank and click on "Add other data from this table," as shown below.

    (144 kB)
    Image

    After that, a menu will appear, allowing you to select which column from this table you want to map to a column in the other table. In the example below, I've mapped all the email addresses from one table to another, as highlighted in the red box. If you'd like to add more than one column, simply click the "+ Add" button located below the red box in the image and do the same process.

    (138 kB)
    Image

    Let me know if this helps.

  • Avatar of Joel M.
    Joel M.
    ·
    ·

    this is helpful, but do i need to manually add the contents of every single item, or is there an option to simply add all of the data to their own columns in a single click?

  • Avatar of Stefano
    Stefano
    ·
    ·

    I am afraid you will have to individually map the different columns.

  • Avatar of Joel M.
    Joel M.
    ·
    ·
  • Avatar of Joel M.
    Joel M.
    ·
    ·

    Thank you for your help