Get Record Count with REST

[raghscool]

Hi,

I am not able to get the count for the sys_whitelist_member table using REST calls. Any ideas?

[Pradeep Sharma]

Hi Raghav,

What is the exact error you are getting.

[raghscool]

https://<INSTANCE-NAME>/api/now/v1/stats/sys_whitelist_member?sysparm_count=true

<message>Insufficient rights to query records</message>

<detail>No permission to read table 'sys_whitelist_member'</detail>

The user I am using has all the roles assigned including the Admin role.

[Pradeep Sharma]

Hi Raghav,

You are not able to read the data because OOB only maint role can read it. Admins will not have access to this table.

I hope this answers your question.

[raghscool]

Pradeep,

Can you explain a bit more?

[Pradeep Sharma]

Hi Raghav,

Servicenow restricts access to this table. you can just go to navigation filter and type sys_whitelist_member.list and you will see the message.

Please let me know if you have any questions.