Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

How to Retrieve All Salesforce Lead Records in Your Lookup

·Apr 17, 2025 09:04 AM·

Hi! When I lookup records from Salesforce (lead records with a certain status) it only returns 5 results while there are 21. How do I make sure the lookup returns all results so I can write every row to another table?

How to Retrieve All Salesforce Lead Records in Your Lookup | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
To retrieve all 21 lead records from Salesforce, we recommend using the "Lookup Records via SOQL" action instead of the standard "Lookup Record" action. This allows you to write a custom SOQL query to fetch all the desired records. Here's how to do it: 1. Use the "Lookup Records via SOQL" action in your Clay workflow. 2. In the SOQL Query field, enter a query like: SELECT Id, Name, Status FROM Lead WHERE Status = 'YourSpecificStatus' 3. This will return all matching records without a limit. After retrieving the records, you can use the "write to table" feature to add them to another table in Clay. If you need further assistance with the SOQL query or writing to another table, please let me know.
Sources: Lookup Rows | Documentation | Clay University Salesforce integration overview | Documentation | Clay University Lookup Rows | Documentation | Clay University
Michaël d.
·
·
Yes that worked, thanks!
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Michaël d.!