The CreatorCon Call for Content is officially open! Get started here.

Call Database View via REST

envir0n
Kilo Contributor

Hi,

I need data from a database view via REST. I know the're data but I get an empty result.

My URL to REST: https://instance.service-now.com/api/now/table/databaseview

In REST API Explorer the result is empty, too.

Has anyone an idea?

Best regards,

René

10 REPLIES 10

Statuscode: 200



I send:


Send.PNG



The result:



find_real_file.png


I just tried using a advanced rest client and it worked simply. Do you have the required access on the view?



Thanks


Please Hit like, Helpful or Correct depending on the impact of the response


I'm tested it with my admin account in REST API Explorer and the result is empty too.



I setted an ACL Rule to this view. As a test i set admin rights to this user but its the same result.



Settings of ACL Rule:


find_real_file.png


envir0n
Kilo Contributor

I copied the View into a new one and now it works... Thanks for your help!


That's good



Seems like it had something to do with the ACL's in your old view.



Thanks


Please Hit like, Helpful or Correct depending on the impact of the response