RE: Using httpapi to integrate with Salesforce

[Colin Grierson <Colin.Grierson@xxxxxxxxxxx>]

I've just set up a soap call interface to salesforce. We were getting intermittent connections, which turned out to be because we were going through a firewall and their server (cs14.salesforce.com) does not have a fixed IP address. Changing to go through our proxy server, which is outside the firewall, solved the problem.

Regards
Colin


Colin Grierson | Development Consultant
Systems Advisory Services Ltd
520 Great South Road, Greenlane, Auckland, New Zealand | PO Box 17-268 Greenlane
Phone +64 9 525 7353 | DDI +64 9 580 8745 | Email Colin.Grierson@xxxxxxxxxxx
We integrate, develop, manage and maintain mission critical systems

-----Original Message-----
From: ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx [mailto:ftpapi-bounces@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Todd Settimo
Sent: Thursday, 30 April 2015 5:41 a.m.
To: ftpapi@xxxxxxxxxxxxxxxxxxxxxx
Subject: Using httpapi to integrate with Salesforce

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):

*_https://www.salesforce.com/services/data/..../v22.0/query?q=SELECT+id+,+name+,+Email+,+phone+from+Contact+WHERE+Contact_Number__c+=+'1'_*
<https://cs21.salesforce.com/services/data/v22.0/query?q=SELECT+id+,+name+,+Email+,+phone+from+Contact+WHERE+Contact_Number__c+=+%271%27>

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




#####################################################################################
Scanned by MailMarshal - Marshal8e6's comprehensive email content security solution. 
#####################################################################################
-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------