Rest API - Reading the dmn_demand table returns an empty result set

Dennis38
Tera Contributor

Using Postman: attempting to query the dmn_demand table returns an empty result set.

{
"result": []
}

Using the following Roles; the query returns data in the London version.

find_real_file.png

If I add the "admin" role; Postman returns the requested dmn_demand table result set.

Thanks!

1 ACCEPTED SOLUTION

Dennis38
Tera Contributor

Thanks for the help! We discovered it is custom JavaScript added to the "dmn_demand" read Access Control.

View solution in original post

7 REPLIES 7

Dennis38
Tera Contributor

Thanks for the feedback!

The following does not return a result set. If I add the Admin role to the user, it does return a result set.

https://YourInstanceName.service-now.com/api/now/table/dmn_demand?sysparm_display_value=true&sysparm_limit=1

There are 3 read Access Controls for dmn_demand.

Is there any role restricted for dmn_demand*

Check if your API user has that access


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Dennis38
Tera Contributor

Thanks for the help! We discovered it is custom JavaScript added to the "dmn_demand" read Access Control.