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?