Use OR statements in REST API URL

Luca14 · ‎05-26-2018

Hi

How can I add OR statements by using the following REST API URL:

https://company.service-now.com/api/now/stats/incident?sysparm_count=true&assignment_group=Grup-Name&state=2

I tried the following way:

https://company.service-now.com/api/now/stats/incident?sysparm_count=true&assignment_group=Grup-Name&state=2^OR_state=3

Thanks in adwance

Brian Dailey1 · ‎05-26-2018

Hi Luca,

Your best bet when trying to learn how to write more complex query statements is to view a list on the table of interest, and then use the filter icon at the top to build out your query as desired. Once you have that created, you can simply right-click on the last condition in the filter breadcrumbs and choose "Copy query" to get a properly formatted encoded-query statement.

(copied to clipboard): assignment_group=9939670d6f30b508a4c2211bbb3ee48d^stateNOT IN2,3

Give that a try,

-Brian

View solution in original post

Mike Patel · ‎05-26-2018

add at the end &sysparm_count=true

https://xxx.service-now.com/api/now/stats/incident?sysparm_query=state%3D2%5EORstate%3D3%5Eassignment_group.name%3DGrup-Name&sysparm_count=true

Mike Patel · ‎05-26-2018

make sure you use stats api instead of table

https://xxx.service-now.com/api/now/stats/incident?

Luca14 · ‎05-26-2018

won't work... can I found a documentation about this and the correct url syntax?

Luca14 · ‎05-26-2018

I got a count but not the one I'm expecting

Mike Patel · ‎05-26-2018

you can play around with api in REST API Explorer . API Name Aggregate

https://xxxx.service-now.com/nav_to.do?uri=%2F$restapi.do