Integration Guide
Enrich your Clay tables with B2B contacts from the Lead Database. Map a company domain or job title column and Clay pulls matching contacts for every row.
Clay’s HTTP API enrichment column lets you call any external API for every row in your table. You add a column, point it at the ScraperCity endpoint, map your table columns to the query parameters, and Clay runs the request for each row automatically.
The most common pattern: you have a table of company domains and you want to find decision-makers at each company. The enrichment column calls the Lead Database API with that domain and returns contacts with name, email, title, and LinkedIn URL.
In your Clay table, click “Add enrichment” and search for “HTTP API.” Select it. You will land on the Configure tab.
GEThttps://app.scrapercity.com/api/v1/database/leadsIn the Headers section, add:
AuthorizationBearer YOUR_API_KEYIn the Query Parameters section, add the filters you want. Use curly braces to reference table columns dynamically:
companyDomain = {Company Domain}
hasEmail = true
limit = 5
title = {Target Title}You can reference any column in your table and map it to any API filter: title, seniority, industry, country, state, city, companyName, minEmployees, maxEmployees.
In the enrichment settings, configure rate limiting:
101000 (milliseconds)Click “Test” to run the enrichment on one row. Verify the response contains the data array with contact records. If it works, run the full table.
The API returns a JSON object with a data array. After the HTTP API column runs, add “Extract Values from Data” columns to pull out individual fields:
data[0].email→First Contact Emaildata[0].first_name→First Contact Namedata[0].title→First Contact Titledata[0].linkedin_url→First Contact LinkedIndata[0].company_name→Company Namepagination.total→Total Matching LeadsChange the array index (0, 1, 2...) to extract multiple contacts per company. Or use Clay’s “Insert all items” option to expand the full array into separate rows.
Start with a table of target account domains. Map companyDomain to each row. Set limit=5 and seniority=c_suite to find top executives at every account.
Create a single-row table with static query parameters (title=CTO, industry=computer software, country=United States, hasEmail=true, limit=100). Run once to pull 100 leads matching your ideal customer profile.
Use the ScraperCity HTTP API column as one step in a Clay waterfall. If your primary email provider returns no result for a contact, fall back to ScraperCity to find the email.