Querying the SFOdata.Position entity with a query as simple as below but the query does not return any data.
However, if you do a Export of the Position object, you will see a lot of Positions existing in the system.
Also, similar queries for other Org entities(eg: Departments, Job Classifications) are returning the data correctly
Position entity is an MDF entity and thus, we need to ensure the user querying the data has MDF specific permissions also to query the Position data.
1. Login to the SFSF Instance and navigate to 'Admin Center -> Manage Permission Roles'.
2. Now select the role assigned to the user and check the permissions assigned to the api user. (Since the same user is able to query all other entities and successfully retreiving the results, we need to check permissions specific to modules/entities)
3. So in this case, we check for below permission and enable it.
4. After enabling and saving this permission, again query the Position entity and you should now be able to retreive the data successfully.
KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , Problem