Apex Code Development You need to sign in to do that
Don't have an account?
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
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
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
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