Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Call Database View via REST

envir0n
Kilo Contributor

‎03-10-2017 01:43 AM

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é

0 Helpfuls
  • 2,983 Views
10 REPLIES 10

Alikutty A
Tera Sage

‎03-10-2017 02:04 AM

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


0 Helpfuls

Alikutty A
Tera Sage
In response to Alikutty A

‎03-10-2017 02:09 AM

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


envir0n
Kilo Contributor
In response to Alikutty A

‎03-10-2017 02:16 AM

Hi,



thanks for reply. I send a GET


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


0 Helpfuls

Alikutty A
Tera Sage
In response to envir0n

‎03-10-2017 02:23 AM

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