function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ankit Singh 6Ankit Singh 6 

Analytics Report API call to fetch more than 2000 records

Hi All

We are trying to fetch salesforce report records using REST API call, but we are able to fetch only 2000 records.(Even we have 6000+ records in report)
Please suggest a workaround to fetch all the records from report using rest.

Thanks
Ankit
Rupali PophaliyaRupali Pophaliya
You can only get 2000 records using API.

https://developer.salesforce.com/releases/release/related/AnalyticsAPI

If you want to fetch more than 2000 reocrds, then you might need to buld query for that report and fetch data using it.
Ankit Singh 6Ankit Singh 6
Could you please let me know any link where I can find building queries for repot.
Rupali PophaliyaRupali Pophaliya
You can build SOQL query based on your report filter criteria and columns to be displayed.