SAP CPI pulling all job information history from Compound employee

[former_member56304]

While trying to fetch data from compound employee job_information, I'm facing an issue. As job_information is effective dated entity it returns all records (New Hire/Data Change) for an employee. When I tried to map the xml on a xsd and then convert it to a csv, the 2nd job_information record of 1st employee is appending on the 2nd employee row of the csv (please see screenshot).

How I can pull only the latest effective dated record and not all records for an user from compound employee ?

[gayathri_narayana]

Hi Matt,

Did you try with the filter step?.In addition you can use the request-reply step to enhance the data of user with additional records.

Regards,

Gayathri