Skip to main content

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! ⚡️