+ Start a Discussion

Getting My Data

Okay, this is my goal. We have an object called SFDC_Project__c. i'm investigating a way to retrieve all the 'projects' once a day. i need this data so that i can put it into our sqlserver database, from here we can develop various reports that can be put on our intranet site. unfortunately it almost seems like salesforce does not want you to do: A) Mass Exports on a daily basis, or B) Mass queries from a PHP script. there is a huge chance that i'm going about this the wrong way, does anyone have any suggestions ?


Well how many projects do you have?  Seems like if you're getting all of them once a day all you really need is one query.  Lots of good info on running queries to Salesforce.com from PHP can be found here.