Skip to Content

How to avoid getting Historical segment from successfactor SFAPI

Dec 16, 2017 at 08:29 AM


avatar image

Dear Experts,

I would like to know how to avoid the historical segments from the SFPI call.

for example , i'm getting multiple "associated_employee_job_information" and i just want to pick the last updated one.

i just want to pick the termination date (end_date), but i'm getting multiple associated_employee_job_information and the sequence of the segment also abnormal.

please suggest how to avoid historical record while querying..

im using SFAPI in SAP HCI.

Thanks and regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sriprasad Shivaram Bhat
Dec 19, 2017 at 05:03 PM

Hello Ramesh,

Somehow missed your question.You can get the current records ( without historical or future ) using effective_end_date key in your query.

add following to your WHERE condition effective_end_date = to_date('2017-12-19') then it should return only current data.

Also you can explore ORDER BY using which you can sort records ascending or descding.


Sriprasad Shivaram Bhat

10 |10000 characters needed characters left characters exceeded