Trying to pull all Incidents from Service Now via the Web API that is NOT closed.
I know that Squared Up KB regarding Service Now states that you should used Sysparm_query “Active=True” for open incidents and “Active=False” for closed one. However, this doesn’t work.
When copying a Query from Service Now filter I can see that Resolved and Closed has a value of “state= 6” and “state=7”
Using this in a sysparm_query doesn’t work. sysparm_query state=6 (for instance) or if you want to use NOT !=6 (for instance for open incidents)
Anyone who’s been successful with this?
I had this a while ago and I found that the query is case sensitive so if you’re using “Active=True” per your description, vs “active=true”, ServiceNow will ignore that part of your query and return everything.