SAP Knowledge Base Article - Public

2324204 - How to retrieve inactive employees via Integration Center?


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.


  • SAP SuccessFactors HXM Suite
  • Integration Center


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


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


  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.

See Also

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


Inactive Status Users for Integration Center, Status is Contained in inactive, active, t, f, inactive, active, terminated, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , How To


SAP SuccessFactors HXM Suite all versions