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

[Dennis38]

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.

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

Thanks!

[Ankur Bawiskar]

Hi Dennis,

what is the query you are sending while consuming REST API?

How are you consuming the endpoint? can you share the method?

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Dennis38]

Hi Ankur,

This is the Get that is being sent from Postman.

https://myinstance.service-now.com/api/now/table/dmn_demand?sysparm_display_value=true

Thanks,

Dennis

[Ankur Bawiskar]

Hi Dennis,

The endpoint doesn't have any query to return the result so it is empty;

give some query such as below

dmn_demand?sysparm_query=number%3DDEMAND001&sysparm_display_value=true

if you want to get specific fields in output then use this i.e. add this after the above endpoint

&sysparm_fields=short_description%2Cdescription

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Prateek kumar]

It works on my PDI with the same roles.

Are there any other read ACL's configured in your instance??

and try

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