Integrating Apollo Contacts into Clay: API Help Needed
Hi Clay team, I’m trying to use the HTTP API integration to pull all contacts from a specific Apollo sequence into a Clay table so I can enrich them and then push AI-generated emails back to Apollo. Here’s what I need help with:
Using Apollo’s /contacts/search endpoint to return all contacts in a given sequence (not just one).
Making sure the results paginate in Clay so I get every contact, not just the first page.
Mapping the returned contacts array into one row per contact (exploding the array).
Pulling in basic fields (name, email, phone, company info) into columns.
Right now, I can make the API call and get data back, but I’m only getting a single row instead of all contacts in the sequence. I’d like guidance on:
- 1.
The best way to handle pagination in Clay for this call.
- 2.
How to properly explode the array of contacts into individual rows in the table.
Thanks!