Skip to Content
avatar image
Former Member

XSLT Mapping in HCI to Filter out Terminated Employees

Hi

I want to use an XSLT mapping to filter out terminated employee from an XML generated by Compound Employee rehiretest.txt. I've tried the following XSL rehirexsl.txt. This correctly filters out employee 10000755 Illie Nastase, but it also incorrectly filters out 10000436 Alin Popa who is a Rehire.

Can anyone help me tweak my mapping so that it only filters out employees who's current status is Terminated?

Thanks

Jonathan

rehiretest.txt (54.1 kB)
rehirexsl.txt (518 B)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 28, 2017 at 07:54 AM

    Hello Jonathan,

    You need to change a bit in your XSLT mapping,but I have suggestion to go with SAP HCI predefined steps [ Filter + Content Modifier ] which will do the same instead of going with XSLT mapping.

    Step1: Add Content Filter with Value Type = "Nodelist" and have the below condition.

    XPath Expression:

    /queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information[1]/emplStatus = 'T') and (person/employment_information/job_information[1]/end_date = '9999-12-31')]

    Value Type: NodelList

    Step2: Add Content Modifier to rebuild the XML with Root Node which was truncated by Content Filter.

    Add below to Body part of content modifier.

    Body:

    <queryCompoundEmployeeResponse>
    ${in.body}
    </queryCompoundEmployeeResponse>

    Hope above helps.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02 at 09:01 AM

    Hi Jonathan Griffiths,

    A better way is to use OData API instead of SFAPI. By default, OData API selects only Active employees as on date.

    Go to Integration Center in Successfactors and create a new integration using object "User". You can add the fields as per your requirement. You can add filter conditions as well. Once done, you can click on Save button and there is an option in the Save menu to generate HCI artifacts. Click that option to get HCI artifacts like iFlow, XSLT mapping etc. automatically generated for you. You can import these artifacts in HCI (Eclipse) and configure further as per your need.

    Regards,
    Netrey

    Add comment
    10|10000 characters needed characters exceeded