Hi Chanuka, According to the logs there is an error in the query string [1]. It should be SELECT Id,Contact_Us_First_Submission_Date__c FROM Lead WHERE Status != 'Disqualified' AND Participant_Type__c != 'Partner' AND Participant_Type__c != 'Other' AND Contact_Us_First_Submission_Date__c != Null.
[1] - <urn:queryString> Id,SELECT Contact_Us_First_Submission_Date__c FROM Lead WHERE Status != 'Disqualified' AND Participant_Type__c != 'Partner' AND Participant_Type__c != 'Other' AND Contact_Us_First_Submission_Date__c != Null</urn:queryString> Thanks Kesavan Yogarajah Software Engineer Mobile :+94 (0) 779 758021 [email protected] WSO2, Inc. lean . enterprise . middleware On Sat, Jan 14, 2017 at 10:16 AM, Chanuka Dissanayake <[email protected]> wrote: > Hi Malaka, > > Also are you using latest ESB? >> > > Yes it's, ESB 5.0 and tooling. > > Maybe issue is related to TLS version? > > > Don't know, whether it have an effect, because it didn't work before they > have update to the new version. > > I have attached the wire log, after invoking the query, it's basically not > responding. > > > Thanks, > Chanuka. > > On Fri, Jan 13, 2017 at 8:16 PM, Malaka Silva <[email protected]> wrote: > >> Hi Chanuka, >> >> Since we are simple invoking the api it should work. >> >> Can you share wire logs for further investigation. >> >> Also are you using latest ESB? Maybe issue is related to TLS version? [1] >> >> [1] https://help.salesforce.com/servlet/servlet.FileDownload >> ?file=0150M000003KgGkQAK >> >> +Dev List >> ---------- Forwarded message ---------- >> From: Chanuka Dissanayake <[email protected]> >> Date: Fri, Jan 13, 2017 at 6:53 PM >> Subject: Salesforce connector supports for complex queries >> To: kesavany Yogarajah <[email protected]>, Keerthika Mahendralingam < >> [email protected]> >> Cc: Malaka Silva <[email protected]>, Shevan Goonetilleke <[email protected]>, >> Yasith Tharindu <[email protected]>, Suhan Dharmasuriya <[email protected]>, >> Nirodha Pramod <[email protected]> >> >> >> Hi Kesavan, >> >> I have come across that, when querying data from Salesforce connector it >> does not retrieving the data, instead it kept waiting. Have you done >> anything related to $subject?. Following is the query which is not working >> through the connector. >> >> SELECT Id,Contact_Us_First_Submission_Date__c FROM Lead WHERE Status != >> 'Disqualified' AND Participant_Type__c != 'Partner' AND Participant_Type__c >> != 'Other' AND Contact_Us_First_Submission_Date__c != Null >> Regards, >> Chanuka. >> -- >> Chanuka Dissanayake >> *Software Engineer | **WSO2 Inc.*; http://wso2.com >> >> Mobile: +94 71 33 63 596 >> Email: [email protected] >> >> >> >> -- >> >> Best Regards, >> >> Malaka Silva >> Senior Technical Lead >> M: +94 777 219 791 <+94%2077%20721%209791> >> Tel : 94 11 214 5345 >> Fax :94 11 2145300 >> Skype : malaka.sampath.silva >> LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 >> Blog : http://mrmalakasilva.blogspot.com/ >> >> WSO2, Inc. >> lean . enterprise . middleware >> https://wso2.com/signature >> http://www.wso2.com/about/team/malaka-silva/ >> <http://wso2.com/about/team/malaka-silva/> >> https://store.wso2.com/store/ >> >> Don't make Trees rare, we should keep them with care >> > > > > -- > Chanuka Dissanayake > *Software Engineer | **WSO2 Inc.*; http://wso2.com > > Mobile: +94 71 33 63 596 > Email: [email protected] >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
