REST API Call is not retrieving all fields in table

[Sandro Mattei]

Hi all.

I have a REST API call (GET) that uses a particular user (call it 'data_retriever') to extract information from the sys_user table. It works properly in DEV and ACC, but in PRD just retrieves 4 columns in the table.

I checked roles and ACLs, and both are the same in all my instances.

I also launched the request by using the data_retriever user via REST API Explorer (by un-check the REST API user only, and impersonating it), and it retrieves all the info, but if I try to do it from external (Postman, PowerShell, ...) still retrieves just 4 columns.

Data Policies are the same in all instances.

API Query used is : https://{instance}.service-now.com/api/now/table/sys_user?sysparm_limit=30&sysparm_query=active=true

Any clue about what I can check now?

Thanks in advance.