[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
-----------------------------------------------------------------------