[Solved] Salesforce Pull action has stopped working for some surveys, but not all.

0

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. 

 

 

Incorrect

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 ( [0] => INVALID_QUERY_FILTER_OPERATOR: Order.Event__c from Order where Id = ‘0124000000ELFy’ ^ ERROR at Row:1:Column:43 invalid ID field: 0124000000ELFy )

 

Correct

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 ( [0] => 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 ( [0] => 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] => xxx@xxx.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 ) ) ) )

 

Correct Action:

 

 

Incorrect Action:

 

If anyone can help, I would reaally reallly appreciate it. 

 

Laura

andrewbroadbent asked

    Best answer

    0

    DONE!! I’ve been copying and pasting the wrong ID. ARGH. 

    andrewbroadbent answered
      ×

      Login

      Question stats

      • Active
      • Views854 times
      • Answers1 answer
      • Followers0 followers