Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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.