REST API GET: How to get list of approval requests for a specific Approver

bari
Kilo Contributor

I'm trying to get a list of items that need approving from the "sysapproval_appover" table

I can add to the "sysparm_query" to only return items that are requested "stateINrequested" 
However when I try to filter for the approver nothing works for me.

I have tried using the sysID for the user
eg. stateINrequested&approver=3E3c46f1874fge5a0037cbafee0310c7c

 

Also tried the full name

eg. stateINrequested&approver=Joe Blogs

 

However these don't work

how to query the field "approver"

thanks

 

2 REPLIES 2

Mike Allen
Mega Sage
From the REST API Explorer, I get:

https://INSTANCE.service-now.com/api/now/table/sysapproval_approver?sysparm_query=approver=5137153cc611227c000bbd1bd8cd2007^state=requested

I think the difference is, the caret (^) character is the AND operator.