SAP Knowledge Base Article - Public

2324204 - How to retrieve inactive employees via Integration Center?

Symptom

How to retrieve inactive employees via Integration Center?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Cause

Integration Center uses OData API to retrieve data from SuccessFactors database, the default behavior of OData API is to retrieve active employees only.

Resolution

In order to retrieve the data of inactive users, you need to follow the steps mentioned on page Advanced Filters from the Help Portal, which are:

  1. On Filter and Sort screen, select "Status" field present under "User" entity with operation parameter as "Is contained in".
  2. Provide the values "t,f" as shown below ("t" would represent "active", while "f" represent "inactive" status).

    statusFilter.jpg

  3. This will make the integration return all possible User records, active and inactive.

Note: If the starting entity of the integration process is not "User", to retrieve all the users with status as "inactive" you can navigate to the "Status" field of "User" and use the above filter.

Note 2: There are more status that can be used, such as "e" or "d". These are used for inactive_external and active_external users.

  • To make sure changes are applied on your Integration Center, please see KBA 2430723 - Changes not Applied to Scheduled Integrations in Integration Center

See Also

  • 3050510 - [Onboarding] External User Data not visible when viewing reports in Integration Center - Onboarding/Offboarding
  • 3290169 - How to find out userid from encrypted data of splunk(server) logs?
  • 2786330 - Query on User entity returns blank values - Integration Center
  • 2324204 - How to retrieve inactive employees via Integration Center?
  • 3375924 - How To check User Status Via Data inspector
  • 3319018 - How To Enable Feature Data Inspector
  • 2545988 - How To Purge or Delete Users In SuccessFactors
  • 3058601 - How To Check Soft Purge or (Hard or Permanent Purge ) User
  • 2584658 - How to Check if a User is an EC User using the Integration Center

Keywords

Inactive Status Users for Integration Center, Status is Contained in inactive, active, t, f, inactive, active, terminated, status, Data Inspector , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , LOD-SF-EC-HRS , HRIS Sync , How To

Product

SAP SuccessFactors HCM Suite all versions