We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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