How to Export JSON from a Database Table or Column

Clay doesn't support JSON export directly. You can only export data as CSV format. To export your table: 1. Navigate to the Actions menu 2. Click Export > Download CSV The CSV export mirrors your Clay table exactly, so all your column data will be included in the downloaded file. You can then convert the CSV to JSON using external tools if needed.

Sources: Download as a CSV [Clay 101] - Clay University Export and Download a File

Clay doesn't have a direct "Export JSON" option. We only support CSV export. To export your table: 1. Click Actions > Export > Download CSV The CSV export mirrors your Clay table exactly with all column data included. If you need JSON format, you can convert the CSV using external tools after export.

Sources: Export and Download a File Download as a CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University

You can extract JSON data into a column using our "Extract Values from Data" integration. To set it up: 1. Add a new column to your table 2. Search for "Extract Values from Data" integration 3. In the "Data" field, reference the column containing your JSON 4. Specify what you want to extract in the "Extraction Type" field 5. The integration will output the extracted values into your new column Alternatively, you can use AI formulas by adding a column and choosing "Ask question about items with AI" to extract specific information from existing data.

Source: Extract Values from Data with Clay

Hello Daniel! Thanks for reaching out! You can simply click into the cell. The different fields should show up. You can hover over the field you want to extract and an Add to Column option should show up. You can click on that and that should do the trick. When you click into the cell it might look something like this:

A couple of ways to do that: You can send this data to a different table by Send Table Data (Actions > Send Table Data) If you have a common column in both tables and you wish to map based on that, you can perform a lookup in the destination table and that will automatically pull in all these fields in that column in the destination table for you to extract out again!