How to Iterate Through an Array for Exporting Lookalike Companies | Clay

How to Iterate Through an Array for Exporting Lookalike Companies

does anyone know how to iterate through an array of results? i’m looking to export a list of lookalike companies (206 results total) but I’m only getting the first 10 back. the idea is export list then run a people search on the companies. thanks!

8 comments

Channeled
APP
·
·
To export a full list of 206 lookalike companies, you’ll need to adjust the “Limit Results” or “Limit” parameter in your integration settings. By default, integrations like Ocean.io return only 10 results, but you can increase this up to the maximum allowed (typically 50 per request). If you have more than 50 results, you’ll need to run the integration multiple times, each time adjusting the offset or batching your requests to cover all 206 companies. After exporting your complete list, you can then run a people search on each company as needed. Keep in mind that you are charged 1 credit per result returned for each row, so exporting large lists will consume more credits. If you need step-by-step guidance on batching or exporting, let me know!
Sources: Find Company Lookalikes [Clay 101] - Clay University Find Company Lookalikes [Clay 101] - Clay University Find Lookalike Companies with Ocean.io with Ocean.io Find Lookalike Companies with Ocean.io with Ocean.io Find Company Lookalikes with Companies, People, Jobs
Dmitry S.
·
·
there isn’t a field for offset
Channeled
APP
·
·
To export all 206 lookalike companies from Clay, use the "Write to Table" feature. After running the Ocean.io lookalikes integration, the results may initially appear grouped or limited, but "Write to Table" allows you to break out each lookalike company into its own row in a new or existing table. This way, you can capture the full set of results, not just the first 10. Once your data is organized in the table, you can export the entire list and proceed with your people search workflow as needed , .
Sources: Find Company Lookalikes [Clay 101] - Clay University Find Company Lookalikes [Clay 101] - Clay University
Dmitry S.
·
·
I’m already doing that part but it’s only writing the first 10
Dmitry S.
·
·
https://app.clay.com/workspaces/525992/tables/t_0svn1kxG7RgcwCXMPh9/views/gv_8nYHtUtuMHC7
Tanvi R.
·
·
Hi Dmitry, thanks for reaching out! You're only seeing 10/206 lookalike results here due to a cell size limitation in Clay. To pull all companies, you'll want create this search as a table source. You can use the lookalikes feature on the find companies table source. Just apply the same companies under domains and run the source. All results will be populated as rows into a new table.
Tanvi R.
·
·
(672 kB)
Dmitry S.
·
·
this was perfect. thank you!