Skip to Content

How to avoid getting Historical segment from successfactor SFAPI

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded