Using database view in REST APIs

rajranbhare · ‎03-16-2017

Hello,

I am using database view in servicenow REST API. I want to retrieve particular record from the view results.

Like for table api, we have the GET call (GET /api/now/table/<tablename>/<sys_id>). Can there be something like this for database view?

Alikutty A · ‎03-16-2017

To Filter using OR conditions, you can add value for the sysparm_query = value=Service Desk^ORvalue=Software

The best way to get your query is to apply the filter on the table and Copy query by right clicking the filter and paste it on sysparm_query

The URL will be displayed in the API

Thanks

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

Alikutty A · ‎03-16-2017

You are welcome!

Thanks

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