Problem in SAP IDM while running SFSF Delta load using last_modified_on filter

[ravi_paul]

Hi Gurus,

We have IDM 8 SP4 version installed and want to integrate SuccessFactor(SF) Employee Central(EC) module where we are using CompoundEmployee SOAP API to retrieve user data. Good part is, while we do a full run(initial load), we are able to read users data from SF EC however we also have to setup delta read from SF EC.

While I was going thru many blogs and articles on CompoundEmployee, I found we should use last_modified_on filter/parameter from the last successful run that should give us information but unfortunately I'm unable to retrieve info. I have followed SAP Note - https://me.sap.com/notes/2784576/E

Here are the screenshot from IDM -

Table Entry of same user when ran full sync which shows that changes was made within 3 months to user's profile -

Regards,

Ravi Paul

[lambert-giese · Accepted solution]

Since this is a SOAP (i.e. XML-based) API on SF side, you may want to try writing the greater than sign in your filter as > If that doesn't fix the problem, try accessing the SF API in an API test tool like Insomnia or Postman first and prototype your request there; it's easier to debug. After you have it working in the test tool, apply the same parameters in SAP IDM.

[ravi_paul · Accepted solution]

Hi @Lambert,
Thanks using SOAPUI, I was able to find the problem, I was using "to_datetime('2024-03-13T07:58:59.000Z')", where as the correct format is - to_datetime('2024-03-13T07:58:59Z').
Although, I was able to find the problem with my query however that didn't solved my problem, as I wanted SuccessFactor to provide records that were update only after specified date whereas it is also giving past records as well, but it seems that is standard behavior of CompoundEmployee SFAPI. 

I had to go thru rigorous query logic of CompoundEmployee SFAPI and I'm hoping, I'll find the correct query.