Posted by mtbosworth on March 23, 2011 at 2:43pm
Hello everyone. I am working on a project to setup up Drupal as a case tracker front end for Salesforce giving end users the ability to provide a feedback. I recently setup a simple Drupal Pressflow instance with Salesforce integration and was able to submit cases and users to my development Salesforce account. Awesome. Now I need the Drupal sites to be able to pull statuses of the cases back from Salesforce to keep end users up-to-date on the cases that they've created. This is my question for the Salesforce group: What is the best way to pull data back from Salesforce? What are the options? Thanks.
Comments
I am very interested in this.
I am very interested in this. I was trying to find somebody to develop something similar, but couldn't find anybody, so I have started to integrated my Drupal website with the Salesforce Self-Service Portal instead, inside an IFrame. Maybe your solution can be used instead ? If you are interested and able, can you contact me so we can discuss this via telephone ? I have budget to pay for such development.
which Salesforce integration?
Which module are you using for the Salesforce integration?
Salesforce Suite includes sf_notifications, which acts as a responder to Salesforce Outbound Messages -- this is a "push" method. "Push" is sufficient if you have a relatively low throughput (Outbound Messages count against your API quota), and will ensure your site serves live data.
The other option would be a "pull" method, where you build a cron job to poll Salesforce for changes to relevant data. SFAPI provides a nifty function, getUpdated(), which queries a particular object type over a particular timeframe. The "pull" method is not supported by Salesforce Suite (yet - will be included in a D7 release), but a wrapper is provided in the SF PHP toolkit, which you could use to build your solution. "Pull" can help reduce your API usage, but your data will be as stale as your cron period.
Salesforce Suite
Yes, I am using Salesforce Suite. The "push" I have implemented successfully. Concerning your suggestion for implementing the "pull", I agree and was pursuing this method. Thanks for pointing out the getUpdated() method. I will give that a try.
Mike Bosworth
Balanced Scale Media, LLC
balancedscale.com
sf_notifications
I am unable to find sf_notifications in the Salesforce Suite submodules. Where can I find that?
Mike Bosworth
Balanced Scale Media, LLC
balancedscale.com
version check
D7 - doesn't exist
D6 - grab the latest 2.x-dev version
Success on getUpdated
Thanks again. I was successful in building out a cron hook to get updates from Salesforce via the getUpdate method provided by the API for Drupal 6.
Mike Bosworth
Balanced Scale Media, LLC
balancedscale.com
Not sure 100% if this might
Not sure 100% if this might be an option but it looks like DPearceMN might have something to help here:
http://drupal.org/sandbox/dpearceMN/1124028
Like I said, not 100% sure but thought I'd pass it along as I just saw it myself.