Clay
A Prospex list feed as a Clay source, through the CSV or the live JSON URL: one flat row per company, with the list's reasons in a column.
A list feed is a flat table. Rows carry a company_ prefix on registry facts, and one row is one company.
The quick way: the CSV
Download the list and import it. Column headers are written for a person, so Clay's importer names the columns correctly with no mapping step:
curl -sS -o list.csv 'https://prospex.ch/app/lists/feed/<token>.csv'
Good for a one-off list to work through. It is a snapshot, so a rebuilt list means a fresh download.
The live way: the JSON URL as an HTTP source
Add an HTTP API source in Clay and give it the JSON URL from the list's Connect page. Three settings matter:
| Setting | Value |
|---|---|
| URL | https://prospex.ch/app/lists/feed/<token>.json?limit=500 |
| Where the rows are | data, an array of objects. |
| Next page | next_url, absolute and complete. Empty means you are done. |
Treat the URL as a secret in Clay the way you would a key, and rotate it from the Connect page if a table gets shared further than you meant.
The columns worth mapping
| Field | What it gives a Clay table |
|---|---|
| company_domain | The join key for every Clay enrichment that takes a domain. |
| company_uid | The Swiss identifier, for writing back into a CRM without a name match. |
| fit | A sortable word. Filter the table on it before you spend credits on enrichment. |
| reasons | Why the company is in the list, in the list's own words. Usable in a message. |
| missing | Which facts Prospex does not hold, so Clay only enriches where there is a gap. |
| in_crm | Whether your connected CRM already has the company. Filter it out and stop paying to enrich accounts you own. |
reasons, missing and signals are arrays in the JSON. In the CSV the same values arrive joined into one cell.
Budget
Every company Clay pulls counts against your row budget once a month. Re-importing the same table costs nothing more that month, however often it runs, so only companies new to the month spend rows. Limits has the numbers, and each JSON page carries a usage block with your position in the day and the month.