REST call returning empty response for non-admin user.

[Peter Wigham2]

Hi all,

Hoping someone is able to assist. I'm working on a simple integration and one of the things needed is for read access to the Dictionary [sys_dictionary] table. It seems like this works in the REST API explorer in the platform when I'm accessing as an admin. I think use Postman as an admin user and again, works great.
I then try to set this up as a user without the admin access, though enough access to query and view the table in the platform, and I'm given a 200 response but the body is empty. I get the correct record value in the X-Total-Count within the header but at no point can I seem to get the correct response body unless I use an admin user.

Is there anyone out there who has experienced and resolved this issue in the past? Any advice would be much appreciated.

Thanks,
PW

[Hitoshi Ozawa]

Probably missing some roles. The user probably already have rest_api_explorer and web_service_admin roles because otherwise, the user won't have access to the API.

The user would also need ACL to the sys_dictionary. Try impersonating the user and check if the user is able to view the sys_dictionary table.

[David Patterson]

The question on its face boils down to "http 200" received - implies no problems with authentication.
If no data is being returned, it could be that the Service Account handling the REST call doesn't have permissions to access the table data being requested.  Check the Groups and Roles of that account to be sure.