Skip to Content
0
Jun 11, 2020 at 02:57 AM

SF - Employyee Central Quey build in SAP CPI for Hire/Rehire/Termination and Change events

707 Views

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