Clay Icon

Adding a Column with Python Script Output as JSON

ยท
ยท

is there any way to add a column that runs a python script and returns a JSON?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Is that what you were looking for?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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.