How to search using Table API

Question

I want to figure out how to search a table's field for a keyword and return the rows that match. i.e. search for the word apple in the description field on a post table.

https://docs.servicenow.com/bundle/newyork-application-development/page/integrate/inbound-rest/concept/c_TableAPI.html#r_TableAPI-GET

score 1 · Answer 1 · answered Sep 03 '19 at 16:27

If you are using ServiceNow TABLE API to fetch results then you could the following on any column of any table. All you need to do is to use sysparm_query parameter with CONTAINS keyword on the column that you are trying to search.

For example:

I want to fetch all the incidents that contains unable to connect string in the descriptions.

https://myinstance.service-now.com/api/now/v2/table/incident?sysparm_query=descriptionCONTAINSunable+to+connect

It returned all the incidents records that contains unable to connect string in there descriptions.

You can mark the answer as accepted if it answered your question. So that it will help future readers. — Suhaib Janjua, Sep 06 '19 at 08:23

How to search using Table API

1 Answers1