Table API - Return all records that contain specific text

[jfencil]

Hello All!

I appreciate any help I can get! I understand this may be a beginner question, but I need help!

I would like the Table API  to return all records that contain specific text.

For example, if a user enters Barkley for a location, I would like to return all locations that contain Barkley.

Here is the url that I am currently using, but when I try this, I do not get any data back:

"https://myinstancehere.service-now.com/api/now/table/cmn_location?sysparm_query=name%3DBarkley&sysparm_limit=10"

[Community Alums · Accepted solution]

Try something like this:

https://myinstance.service-now.com/api/now/table/cmn_location?sysparm_query=nameLIKEBarkley&sysparm_limit=10

If you use the 'REST API Explorer',  you can copy the 'GET' under the 'Request' section. 

Tim

[jfencil]

Thank you @timmo I appreciate the reponse! I will give it a go! Where did you come up with something such as nameLIKE? Is there documentation for other similar query requests? 

[SanjivMeher]

You need to build your query and then use in REST API explorer.

[jfencil]

I really appreciate the helpful suggestion @sanjivmeher!