Hey! Is there an easy way to export a column with JSON data? I used the "Enrich Person" to get data from linkedin url and I'd like to export the JSON data to analyse and use it outside of Clay. There seems to be an option only to export a CSV and it will not include all the JSON data in it. Any tips how to do this? I couldn't find a good way to do this.
You're right that CSV exports don't include full JSON data. Here are two ways to get your complete JSON data out:
Option 1: HTTP API to external service
Use our HTTP API enrichment to send the full JSON data to Zapier or another webhook endpoint. [1] In the Body section, reference your entire enrichment column to include all JSON properties. [2]
Option 2: Create dedicated export columns
Before exporting, create separate columns for the specific JSON fields you need using "Add as column" from the enrichment results. This ensures the data exports properly in CSV format.
The HTTP API method gives you the most flexibility for external analysis since you can send the complete JSON structure. [3]
If you still need help with exporting or working with your JSON data, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?