+ Start a Discussion
Juan Pedro Catalan 2Juan 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!
Best Answer chosen by Juan Pedro Catalan 2
Jayant JadhavJayant Jadhav
Hi Juan,


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

Jayant JadhavJayant Jadhav
Hi Juan,


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.
 
This was selected as the best answer
Juan Pedro Catalan 2Juan Pedro Catalan 2
Thanks for your help

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
Jayant JadhavJayant Jadhav
@Juan,

As per my knowledge 2000 is the limit. About "allData" params it does not help us to increase the limit.