REST API GET: How to get list of approval requests for a specific Approver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-10-2019 02:42 PM
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
- Labels:
-
Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-10-2019 05:50 PM
From the REST API Explorer, I get:
https://INSTANCE.service-now.com/api/now/table/sysapproval_approver?sysparm_query=approver=5137153cc611227c000bbd1bd8cd2007^state=requested
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2019 09:00 AM
I think the difference is, the caret (^) character is the AND operator.