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!