+ Start a Discussion
Max PaqMax Paq 

Analytics API limitation

Hi everyone,

We are running into some limitations when using the Analytics API where we only get the first 2000 records of a report. I have talked with one of our developer and he told me it was a limitation of the API. Is there any way around this limitation? We need to run reports via the API on much more than 2000 records.

Thank you for your help,

Max

 
Amit Chaudhary 8Amit Chaudhary 8
Sorry, You can only get up to 2000 records using this API only

The Analytics API has some restrictions in addition to the general API limits.

1) Get up to 200 reports that you most recently viewed.
2) Get results for the first 2000 report rows, which includes detailed record data. You can narrow results using filters to get
the most useful bits.
3) Add up to 20 custom field filters when you run a report. The number includes existing custom field filters saved to the
source report.
4) Send requests for reports that have up to 100 fields as columns.
5) Access results of an asynchronous report run any number of times within a 24-hour rolling period.
6) When filtering data, cross filters and standard report filters are not available.

http://salesforce.stackexchange.com/questions/23175/why-am-i-getting-only-2000-rows-using-analytics-rest-api-synchronous-report-run
http://www.slideshare.net/developerforce/salesforce1-analytics-api-handson-training
http://blog.force365.com/2013/09/28/salesforce-analytics-api/

Please let us know if this will help you,

Thanks
Amit Chaudhary
amit.salesforce21@gmail.com
Max PaqMax Paq
Thank you for your help,

Is there a difference between the number of row and the number or records returned? for example if I have an object, with a date and cost field, I have 20 thousands records of that object and I build a matrix report where I see the sum of cost per year (and not every single records). Will I get 1 row per year or 1 row per record.

The whole record limit is confusing to me since the analytics APi documentation: http://www.salesforce.com/us/developer/docs/api_analytics/salesforce_analytics_rest_api.pdf , It does say on page 4 that we can get all the records
Amit Chaudhary 8Amit Chaudhary 8
API returns data for the same number of records that are available when the report is run in the Salesforce user interface