[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Using httpapi to integrate with Salesforce



   Please disregard this inquiry. I was given bad information. Apparently,
   in the actual URL, the forward slash was missing after .com.
   Apologies for taking anyone's time with this.

   Best,
   Todd Settimo
   Wenger Corporation

   On 4/29/2015 10:40 AM, Todd Settimo wrote:

   I am currently working on integrating a client's ERP system with
   Salesforce. So far, I've successfully used httpapi to consume
   Salesforce's RESTful web services which have been HTTP POSTs to this
   point.
   When it comes to retrieving data from Salesforce, Salesforce doesn't
   have a lot of predefined web services to support HTTP GETs for various
   tables. Instead, they have one web service to access all of their
   tables and want you to use SOQL, a kind of proprietary SQL, as a query
   statement in the URL on an HTTP GET.
   A typical URL might look something like this (but with a Salesforce
   access token appended to it which is acquired on a prior POST):
   [1]https://www.salesforce.com/services/data/..../v22.0/query?q=SELECT+i
   d+,+name+,+Email+,+phone+from+Contact+WHERE+Contact_Number__c+=+'1'
   When we try to run this using http_url_get we are seeing in the log:
   SetError() #2: Host name look up failed.
   We've verified the domain and the syntax of our URL and it seems to be
   correct.  We're stumped at this point.  I'd be grateful for any insight
   anyone might have.

   --
   Best,
   Todd Settimo
   Wenger Corporation

References

   1. https://cs21.salesforce.com/services/data/v22.0/query?q=SELECT+id+,+name+,+Email+,+phone+from+Contact+WHERE+Contact_Number__c+=+%271%27
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------