Brendan's Reflections

  • Download / Scrape Salesforce Reports in 4 lines of Python

    Python Code: import requests l = requests.get(“https://login.salesforce.com/?un=USERNAME&pw=PASSWORD”) d = requests.get(“https://na3.salesforce.com/REPORT_ID?view=d&snip&export=1&enc=UTF-8&xf=csv”,cookies=l.cookies) print d.content References: http://sfdc-heretic.warped-minds.com/2006/04/10/progmatic-access-to-salesforcecom-reports/ http://docs.python-requests.org/en/latest/user/quickstart/#cookies http://www.techsmog.com/index.php/2011/02/08/parsing-real-time-salesforce-com-reports-via-perlcgi-html-tables/

    brendansterne