Hi All,
I am working on an Integration from SAP CPI to SAP SF, configured SF adapter with SOAP protocol.
I have checked manually and its working fine. I would like to pull the data by building an automatic query.
I am using below query for automation and getting below exception.
SELECT person, address_information, email_information, employment_information, job_information, payment_information, national_id_card, personal_information FROM CompoundEmployee WHERE company = 'XXXX' and ((last_modified_on > to_datetime(${property.Last_Modified_Date})))
Exception - Problem during invoking SuccessFactors Web service. SOAP faultCode ns2:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: Function "to_datetime" is not right. Usage Example: to_datetime('2010-05-22T08:59:59Z') Exception Trace - com.sap.it.rt.adapter.sfsf.wsclient.SfsfWsClientFaultException: Problem during invoking SuccessFactors Web service. SOAP faultCode ns2:Server, faultString SFAPI Domain Error!, errorCode INVALID_SFQL, errorMessage: Invalid SFQL! Error: Function "to_datetime" is not right. Usage Example: to_datetime('2010-05-22T08:59:59Z') at com.sap.it.rt.adapter.sfsf.wsclient.SfsfWSClient.getSfSfException(SfsfWSClient.java:314) at com.sap.it.rt.adapter.sfsf.wsclient.SfsfWSClient.call(SfsfWSClient.java:145) at com.sap.it.rt.adapter.sfsf.wsclient.SfsfWSClient.call(SfsfWSClient.java:110).
I hav also referred sNote: 2649816.
Look forward to your support.
Thanks and Regards,
Shridhar