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

Alikutty A
Tera Sage

Hi,



Database views are read only. Did you try reading data from a database view? I mean the get operation.





Thanks


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


I tried to perform a get query via REST API explorer on incident_metric view and it worked for me.



You may not be able to POST or PUT data in a database view.



Thanks


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


Hi,



thanks for reply. I send a GET


GET https://instance.service-now.com/api/now/table/databaseview?sysparm_limit=1


And what is your response status code? Can you put a screen print of response and headers.



Thanks


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