Multiple System Parameter REST

stormcloaks
Mega Contributor

Hi,

I would like to call the REST Table Webservice.

For example to pull all the incidents with priority 1, I formed the URL which returns the number and state

https://<instance name >/api/now/table/incident?sysparm_query=priority%3D1&sysparm_fields=number,state

If I want to send one more system parameter "active=true", to retrieve all the the incidents which are priority 1 and active is true. What would be the URL can someone please advise ?

Thanks in advance for your help

1 ACCEPTED SOLUTION

jarodm
Mega Guru

e.g.


sysparm_query=active=true^state=5^priority=4&sysparm_fields=number,state



I usually go to a list view and get my filter just right, the right-click and `Copy query`, but for simple edits I just use the ^



find_real_file.png


View solution in original post

2 REPLIES 2

jarodm
Mega Guru

e.g.


sysparm_query=active=true^state=5^priority=4&sysparm_fields=number,state



I usually go to a list view and get my filter just right, the right-click and `Copy query`, but for simple edits I just use the ^



find_real_file.png


Thanks Jarod.



That was really lightening quick