Call Database View via REST
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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é
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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