Integration Error While Running Lookup for 50K Rows
Running lookup from one table to another for 50k rows, I face integration error yesterday. Is this something to do with limits?
Running lookup from one table to another for 50k rows, I face integration error yesterday. Is this something to do with limits?
Yes, your integration error is likely related to our 50,000-row table limit. Each table in Clay is capped at 50,000 rows, including visible, hidden, deleted, or filtered rows. When this limit is reached, additional rows cannot be added and some table functionalities may cease to work.
For lookup operations between tables, you can use "Lookup Single Row in Other Table" or "Lookup Multiple Rows in Other Table" actions instead of sending data linearly.
To get more details about your specific error, click into the cell where you're seeing the error message to expose more information about what went wrong.
Was that helpful?
If you still need help resolving the integration error or understanding the table limits, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Looking up records in Salesforce is it linked with API Limit?
Yes, Salesforce lookups are subject to API limits. Salesforce limits API queries to 2,000 results per request. When using lookup actions in Clay, you need to ensure your queries don't exceed Salesforce's governor limits on rows or executions.
For optimal performance, use selective queries that specify only needed fields and leverage indexed fields in WHERE clauses to stay within these limits.
Is that what you were looking for?
If you still need assistance with the integration error or Salesforce API limits, I’m here to help. Would you like to share more about the specific challenges you’re facing or what you’re trying to accomplish?
Hello Abdul! Thanks for reaching out! Do you mind sending over the table link URL for me to take a look? Technically there is a limit to the number of API calls but it is on Salesforce's end. What does limit Salesforce lookups: Your Salesforce organization's daily API quota - this varies based on your Salesforce edition and number of users. Understanding Your Salesforce API Limits Common Salesforce API Quotas: • Varies by Salesforce edition (Professional, Enterprise, Unlimited, etc.) • Typically ranges from 15,000 to 1,000,000+ daily API calls • Adjusted based on the number of Salesforce licenses/users in your org How Clay Helps Optimize Your Salesforce API Usage Batch Updates: Clay batches Salesforce operations (up to 200 records per API call) to minimize API consumption Each Clay Salesforce action typically uses: • 1 API call per lookup/update/create operation • With batching: 1 API call per 200 records (for bulk operations) Once you send the table link I can have a look!
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!