Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

My zap has a Salesforce Find Records by Query action. The zap then creates an Excel spreadsheet in OneDrive and is supposed to put the results of the query into rows in the Excel spreadsheet (the two formatter steps shown in my screenshot are just to set the name of the spreadsheet that is created). When I run the SOQL query in Salesforce Developer Workbench, I can see that it correctly returns 1350 records. But when I run the zap (both in test mode and published), I only get 200 rows added to my spreadsheet. 

I know that SOQL has a limit of 2000 rows, and usually the default batch size in Salesforce is 200, but I need the zap to get all the rows and not just 200. 

 

Zapier support has said this is bug - does anyone have any ideas for how else I could accomplish this with Zapier? 

The requirements are:

  • Run on a schedule (ie, not triggered by anything happening in Salesforce)
  • Need to query different objects in Salesforce and combine the results into one .csv - for example, Salesforce Contacts and Salesforce Users all become “users” in one combined .csv
  • The .csv has to be uploaded to an FTP site for another product that doesn’t have an API. I have this working nicely in Zapier with EasyFTP.

Hi there, ​@CarolynR! 👋

So sorry to hear you’re running into that bug. I checked and it looks like it’s still unresolved unfortunately. I can’t give any ETA on when it will be fixed but we’ll be sure to notify you as soon as it is!

In terms of a potential workaround, perhaps you could try using an API Request action to search for the records instead?

Looking at Salesforce’s API documentation here their query endpoints should indeed be able to return up to 2,000 records, so in theory it shouldn’t have the same issue of being limited to 200. 🤔 It’s a bit more advanced as it would involve referencing Salesforce’s API documentation to get the request set up correctly but we do have a general Create an API Request action guide that may help to get you started.

If you do give that a try please let us know how you get on, keen to help get things up and running! 🙂

Just circling back in here to share that the bug has been fixed! 😁🎉

In case you missed the email notification that was sent by the team, the limit has been raised from 200 to 2,000—which should get things working correctly now. 

As the bug is resolved I’ll be closing out this topic. If you’re still experiencing any issues, post a new topic in the Community here or contact Support directly to let us know. 

In the meantime, happy Zapping! ⚡

Terms & ConditionsAccessibility statement