2166571 - How to query inactive users on User entity - OData API

How to query both active and inactive users from the SuccessFactors instance in a single OData API query using User entity?

• SAP SuccessFactors HXM Suite
• OData API

By default OData API User entity won't return data for inactive users unless you explicitly specify in the query statement.

A special filter condition on "status" field should be used with an "IN" operator and value as 't','f', which represents active and inactive respectively. This will make the query return data for all users, active and inactive.

One example would be:

https://apiX.successfactors.XXX/odata/v2/User?$format=json&$select=username,status,email,userId,firstName,country&$filter=status in 't','f'&$top=200

Note: If there are external users in the system then it is good to add this in the filter condition $filter=status IN 'active','active_external','inactive','inactive_external'. This will fetch all the internal and external User information, both active and inactive.

The guide page below explains User entity's behavior regarding inactive users.

OData User entity - Supported Operations

Inactive, users, user, entity, insufficient, permission, terminated, deactivated, query, select, data, blank, usernav, empty, null , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , How To