Why do I only retrieve 2000 records from my Salesforce report?

[SophiaF]

Issue

Querying a Salesforce report using the Salesforce Input tool returns a maximum of 2000 records.

Environment

• Alteryx Designer
  
  • Version 2018.2+
• Salesforce Input tool
  • Version 4.0
• Windows Operating System

Cause

This tool uses theSalesforce Reports and Dashboards REST API, which has a limitation of retrieving2000 records per call. Please see 'Additional Resources' below for a link to the documentation.

Additional Resources

• Salesforce Reports and Dashboards REST API - Requirements and Limitations

[nudraco]

Understand.

So, it's no way to increase SFDC REST API limit from 2,000 rows?

Just checking :-).

Very unfortunate.

Appreciate your help.

[SophiaF]

@nudraco thanks for your question! According to Salesforce's documentation, they advise to narrow down the returned results with filters, but there is not a way to increase the results.

[mchamps]

Please check out my post! I found some workarounds for the 2000 row limitation for existing reports.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Salesforce-Input-Tool-amp-Going-Beyond...

[NicolasSz]

I've submitted an idea based on your post @mchamps ! Should be quite easy for Alteryx to include in the existing macro..

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Improve-SalesForce-Input-connector/idi-p/716...