> > 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. > > Thanks Kesavan, didn't notice that. It's working now :)
On Sat, Jan 14, 2017 at 11:30 AM, Kesavan Yogarajah <[email protected]> wrote: > 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 <+94%2077%20975%208021> > [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] >> > > -- 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
