community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Moderator
Moderator
Created on

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 the Salesforce Reports and Dashboards REST API, which has a limitation of retrieving 2000 records per call. Please see 'Additional Resources' below for a link to the documentation.

 

 

Additional Resources

 

Comments
Meteor

Understand.

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

Just checking :-).

Very unfortunate.

Appreciate your help.

Moderator
Moderator

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