Using JSON Data for Column Input in Your Project
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?
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?
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.
In order to export the rows from one table to the other, select "Actions"> "Write to Other table"
In the menu that pops up under "Select Table to Write to" choose what table you would like to send this information to.
Then, leave the "Select a list from a column" field blank and click on "Add other data from this table," as shown below.
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.
Let me know if this helps.