Apex Code Development You need to sign in to do that
Don't have an account?
Juan Pedro Catalan 2 Export Report Data with HTTP Request
Hi everyone,
I need to export a report data with one scheduled job and apex code. When I've the csv data I need to send a HTTP Request.
The problem is the report data size is 30Mb aprox...
How do you do it? What is it the better way?
Thanks!
I need to export a report data with one scheduled job and apex code. When I've the csv data I need to send a HTTP Request.
The problem is the report data size is 30Mb aprox...
How do you do it? What is it the better way?
Thanks!
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/
This content is from other post.
All Answers
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/
This content is from other post.
So...I can't export more of 2000 rows? I can see that with the "allData" params is possible..it's true? If it isn't possible, There is anyway? Really I need to do it...
Thanks
As per my knowledge 2000 is the limit. About "allData" params it does not help us to increase the limit.