PLEASE HELP. The Salesforce integration is driving me batty, and is now pushing a project quite late.
I have been creating 30~ surveys for the company, that we will be sending out through Salesforce & Docusign.
Half of them are working fine. Half don’t pull data from salesforce. They have ALL been made by cloning the template, and are all identical except for branding, and the intro & outro messages. I’ve tried removing and re-adding the Salesforce pull action, but it won’t work. The only difference I can see in the action log is that the one that isn’t working is adding “Id,” in the select term of the input (see the underlined bit). Ignore the fact the incorrect one is pulling less fields from Salesforce; when it started to break, I just tried to fix one field at a time.
Submitted: 2015-12-16 08:01:12
Input: command=query&query=s:63:”select Id,Order.Event__c from Order where Id = ‘0124000000ELFy’”;&customerid=405512&qsku=196&sessionID=1450267136_56715200cdc7b7.73167629&object=N;
Output: Array (  => INVALID_QUERY_FILTER_OPERATOR: Order.Event__c from Order where Id = ‘0124000000ELFy’ ^ ERROR at Row:1:Column:43 invalid ID field: 0124000000ELFy )
Input: command=query&query=s:255:”select Order.Event__c,Order.Main_POC__c,Order.Event_Name__c,Order.AccountId,Order.Id,Order.Main_POC_First_Name__c,Order.Main_POC_Last_Name__c,Order.Main_POC_Job_Title__c,Order.Account_Name__c,Order.Main_POC_Email__c from Order where Id = ‘80124000000ELFy’”;&customerid=405512&qsku=188&sessionID=1450190599_56702707042c81.04424418&object=N;
Output: Array (  => Array ( [datetime] => 2015-12-15 09:43:19 [input] => command=query&query=s%3A255%3A%22select+Order.Event__c%2COrder.Main_POC__c%2COrder.Event_Name__c%2COrder.AccountId%2COrder.Id%2COrder.Main_POC_First_Name__c%2COrder.Main_POC_Last_Name__c%2COrder.Main_POC_Job_Title__c%2COrder.Account_Name__c%2COrder.Main_POC_Email__c+from+Order+where+Id+%3D+%2780124000000ELFy%27%22%3B&customerid=405512&qsku=188&sessionID=1450190599_56702707042c81.04424418&object=N%3B [output] => Array (  => stdClass Object ( [Event__c] => a0824000008PizRAAS [Main_POC__c] => 0032400000HcngmAAB [Event_Name__c] => iStrategy Europe 8 [AccountId] => 0012400000K2AzAAAV [Id] => 80124000000ELFyAAO [Main_POC_First_Name__c] => Name [Main_POC_Last_Name__c] => surname [Main_POC_Job_Title__c] => Example Job Title [Account_Name__c] => Unilever [Main_POC_Email__c] => email@example.com [type] => Order ) [soap] => Array ( [soap_request_header] => POST /services/Soap/u/13.0/00D24000000cyVJ HTTP/1.1 Host: eu5.salesforce.com Connection: Keep-Alive User-Agent: PHP-SOAP/5.3.3 Accept-Encoding: gzip, deflate Content-Type: text/xml; charset=utf-8 SOAPAction: “” Content-Length: 739 Cookie: [soap_request] =>00D24000000cyVJ!AQIAQJrAFYJV_9XKR2DRlLPWCORbbknny40SvidGiUN0Et.ES7WP1swoHZDmwEWtgiuvtJB0hWlV_hgrFso3LMuSBcGWt0Ggselect Order.Event__c,Order.Main_POC__c,Order.Event_Name__c,Order.AccountId,Order.Id,Order.Main_POC_First_Name__c,Order.Main_POC_Last_Name__c,Order.Main_POC_Job_Title__c,Order.Account_Name__c,Order.Main_POC_Email__c from Order where Id = ‘80124000000ELFy’ [soap_response_header] =>trueOrder80124000000ELFyAAOa0824000008PizRAAS0032400000HcngmAABiStrategy Europe 80012400000K2AzAAAV80124000000ELFyAAONamesurnameCustomer Account Manager eCommerceCompanyxxx@xxx.com1 [soap_response] => HTTP/1.1 200 OK Date: Tue, 15 Dec 2015 14:43:19 GMT Set-Cookie: BrowserId=E05TIHaPTsWxaeLfDfWyyg;Path=/;Domain=.salesforce.com;Expires=Sat, 13-Feb-2016 14:43:19 GMT Expires: Thu, 01 Jan 1970 00:00:00 GMT Content-Type: text/xml;charset=UTF-8 Content-Encoding: gzip Transfer-Encoding: chunked ) ) ) )
If anyone can help, I would reaally reallly appreciate it.
DONE!! I’ve been copying and pasting the wrong ID. ARGH.