My posts about my jobs and hobbies in computer technology: web development (Java, PHP, jQuery, Angularjs, CSS, HTML, XML, web services), mobile development (Android, PhoneGap), system admin/devops (Linux, CentOS, Apache, Tomcat, MySQL, PostgreSQL, Puppet), open sources...
Sunday, March 27, 2016
Download SalesForce Report in CSV to import into MySQL
I've used Talend Open Studio to import SalesForce report data into MySQL via REST API but it turned out the Analytics API limits up to 2,000 records so now use Python to pull it from CSV and import into MySQL. Here is the code