is there any way to add a column that runs a python script and returns a JSON?
While we don't have a direct way to run Python scripts within Clay, you can achieve a similar result using our HTTP API integration. Here's how: 1. Create an external API endpoint that runs your Python script and returns JSON. 2. In Clay, add a new HTTP API enrichment column. 3. Set the Method to POST and enter your API endpoint URL. 4. In the "Body" section, include any necessary data from your table, formatted as JSON. 5. Run the column to send requests to your API and receive JSON responses. The JSON response will be contained in the HTTP column. You can then use our "write to table" feature to extract specific data from the JSON and add it as new columns.
Is that what you were looking for?
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.