Automate the downloading of Data Export zip files

After a Data Export has completed there can be a large number of zip files to download.

If there are 80+ files at 130 MB (In Summer 12 the limit has been increased to 512 MB) each and each file takes several minutes to download it can be a time consuming process to do manually.

Is there a way to automate the retrieval of these zip files?

Answer

One approach is to use the SOAP API to automatically establish a session using securely stored credentials. Once the session is established you can use the Session ID and Server URL to send a web request to the page that contains the Data Export, parse out the download links, and then pull the zip files down and store them locally. Depending on the duration of the transfer you may need to recover from a lost session.

The usual caveat applies to this approach as some of the steps aren’t using the provided APIs. Salesforce may at their whim break the ability to extract the zip paths.


Based on the above solution we have made a free tool using .NET here at work that can automatically download the Data Export from the command line and/or the included GUI app.

This can be useful when the number of zips to retrieve grows large or you want to automate the download process.

See FuseIT SFDC Data Export.


You might also like to vote for the idea:
Weekly Data Export – Ability to automate file transfer via web service

Attribution
Source : Link , Question Author : Daniel Ballinger , Answer Author : Daniel Ballinger

Leave a Comment