How to avoid getting Historical segment from successfactor SFAPI

[former_member213558]

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

[Sriprasadsbhat]

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.

Regards,

Sriprasad Shivaram Bhat