Unable to query Users with f

[former_member476580]

Hi Experts,

We are trying to query Users from BizX (SuccessFactors). However, we are not able to query users that has their "status" field set to "f". We were only able to query Users with their "status" field to "t".

We have created a simple iflow that just queries the status field without any filters. We were only able to see the 70000 users (or just status fields) and the 10000 did not show up (there is a total of 80000 users).

The query we have used is:
$select=status

[former_member476580 · Accepted solution]

This has now been fixed.

On default, it is set (either from successfactors or HCI) to query users with 't' status. Even if status only has 't' or 'f' values, using the query $select=status would only pull users with status 't'.

The fix is to use a filter and specify there to also pull users with status 'f'

Doing the query below pulls all users including the ones with status 'f'

$select=status&$filter=status eq 'f' or status eq 't'