1

I would like to download a report generated in Salesforce every month as a csv file and process it on our side. I explored the analytic api which has a limit of 2000 rows per call, writing a soql query is a option but its cumbersome. Can I ftp the report to a location on our server once its generated in Salesforce? What would be the ideal way to download a report with 100k records?

2
  • If you could limit yourself to 25K rows, you could use Conga Composer/Conductor
    – cropredy
    Jan 14, 2016 at 22:13
  • NO I need to download entire report. Jan 15, 2016 at 16:58

1 Answer 1

1

You can use the apex Data Loader, there's a way to set it up using a batch file and Windows Task Scheduler. I set it up for a client, it's not actually too difficult to use :)

Check out these:

https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line https://help.salesforce.com/apex/HTViewHelpDoc?id=command_line_intro.htm&language=en_US https://help.salesforce.com/apex/HTViewHelpDoc?id=using_the_command_line_interface.htm

7
  • The Data loader only allows data export of Salesforce objects but not Reports generated. Jan 14, 2016 at 21:35
  • Correct, but a report is just data from Salesforce objects... you could run a query to export the exact data that you would export from the report...
    – Tim
    Jan 14, 2016 at 21:39
  • Other than the other way is just scheduling the report or creating some custom APEX to actually get the content of a report that has been loaded then making the APEX generate the file.
    – Tim
    Jan 14, 2016 at 21:40
  • You mean to write a SOQL query to get data and export using data loader? Jan 14, 2016 at 21:42
  • I dont know APEX so I will have to learn it. After scheduling the report with Apex can apex push the report to my server? Is there any way to change the default limit exposed on rest api call? Jan 14, 2016 at 21:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .