Salesforce List Import Issues: Missing Items in Clay

·

I have a list imported from Salesforce, but not all the items in the Salesforce list show up in Clay. I can see an account in the list for example, but it is not in Clay. I have no filters enabled

4 comments

Clay
APP
·
·
There are a few common reasons why not all Salesforce list items appear in Clay: Report Format Issue: If you imported from a Salesforce report, it must be in "tabular" format without groupings for successful data import. 2,000 Record Limit: Salesforce imposes a 2,000 record limit per report import. If your list has more records, only the first 2,000 will import. SOQL Compatibility: Views that aren't SOQL-compatible are limited to 2,000 records. To bypass this, create a SOQL-compatible list view with basic operators (=, <, > , > =, <=) instead of "contains" filters. Try importing directly from Salesforce lists rather than reports when possible, as this allows for more comprehensive data pulls.
Sources: Import from CRM [CRM Enrichment] - Clay University Salesforce Records with Salesforce
Clay
APP
·
·
Hello Pedram! Thanks for reaching out! Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Pedram N.
·
·
https://app.clay.com/workspaces/409398/workbooks/wb_qfwRnxraGePt/tables/t_vHUx8M6SjqFZ/views/gv_M8DkqhkA8ZNP
Clay
APP
·
·
Hello Pedram! The initial pull does not pull in all fields present in the record. I performed a lookup at the end of your table and can see about 200 fields populate per record. Does that solve the issue?