.png){kind=logo}
Exporting Custom Fields from Clay to Apollo via API
Hi, has anyone successfully exported a custom field from clay into apollo? I'm using the API but somehow I can't get any custom fields imported
Hi, has anyone successfully exported a custom field from clay into apollo? I'm using the API but somehow I can't get any custom fields imported
To export a custom field from Clay to Apollo using the API, you'll need to use our HTTP API integration. Here's a brief overview: 1. In Clay, set up an HTTP API column. 2. Configure the endpoint to Apollo's API for creating or updating contacts. 3. In the Body section, include your custom field data using Clay column tokens. 4. Ensure your Apollo API key is included in the Headers. After setting this up, export your data from Clay using the 'Export' feature in the 'Actions' menu. If you're still having issues, please share the specific JSON you're using so we can troubleshoot further.
this is the JSON array I'm using { "api_key": "VWr0pQSp3NqJU1pf42UxMA", "first_name": "First Name", "last_name": "Last Name", "organization": "Company", "email": "Work Email", "mobile_phone": "Final Phone", "Custom Field: Notes": "Sureconnectoutcome" }
To successfully export a custom field from Clay to Apollo using the API, you'll need to adjust your JSON array. Here's how:
1. Use the HTTP API integration in Clay.
2. Set the method to POST and use Apollo's API endpoint for creating/updating contacts.
3. In the Body section, format your JSON like this: LBKS{ "api_key": "VWr0pQSp3NqJU1pf42UxMA", "contact": { "first_name": "##{{First Name}}", "last_name": "##{{Last Name}}", "organization_name": "##{{Company}}", "email": "##{{Work Email}}", "phone_number": "##{{Final Phone}}", "custom_fields": { "Notes": "##{{Sureconnectoutcome}}" } } }LBKSReplace the placeholders (e.g., ##{{First Name}}) with your Clay column names. This structure should allow the custom field to be exported correctly.
No. I've done all of this
Hey Bruno - To update a custom value through an HTTP API call, follow these steps:
1. Identify the custom field you want to update. You can get a list of all custom fields using a GET request to /api/v1/typed_custom_fields.
2. Prepare your API request:
3. • Use a PUT request to update an existing contact
4. • Set the URL to https://api.apollo.io/api/v1/contacts/{contact_id}
5. • Add these headers:
6. • 'Cache-Control: no-cache'
7. • 'Content-Type: application/json'
8. • 'accept: application/json'
9. • 'x-api-key: YOUR_API_KEY'
10. In the request body, include the custom field you want to update within the "typed_custom_fields" object.
11. Send the request using your preferred method (cURL, Postman, etc.).
12. Review the API response to confirm the update was successful.
Can you try again this way? Typically the field name would be numbers.