Share via

Does user delta query support filter query parameters?

testfestAdmin 1 Reputation point
2022-11-16T00:45:01.657+00:00

Hi There,

I was trying to add filter query parameters in Microsoft users delta request (the URL is shown as below.)

https://graph.microsoft.com/v1.0/users/delta?$filter=endswith(mail,'a[@](/users/na/?userId=a28c79c1-c609-48db-b55f-1783d1187afb).com')&$orderby=userPrincipalName&$count=true

However, I was getting below errors.

java.io.IOException: {"error":{"code":"Request_UnsupportedQuery","message":"Unsupported Query.","innerError":{"date":"2022-11-16T00:14:46","request-id":"35fc45f9-eb26-466a-b360-9daef231392a","client-request-id":"35fc45f9-eb26-466a-b360-9daef231392a"}}}

And as I checked your official doc, seems only Object id is allowed in the filter query? Can I filter delta users by mail?

Scoping filters allow you to track changes to one or more specific users or groups by object ID. For example, the following request returns changes for the groups matching the IDs specified in the query filter.

Microsoft Security | Microsoft Graph
0 comments No comments

1 answer

Sort by: Most helpful
  1. Shivam Dhiman 6,086 Reputation points
    2022-11-16T01:13:48+00:00

    Hi @testfestAdmin

    As per the documentation, it supports filter but there is limited support:
    The only supported $filter expression is for tracking changes on a specific object: $filter=id+eq+{value}.
    You can filter multiple objects. For example, https://graph.microsoft.com/v1.0/users/delta/?$filter= id eq '477e9fc6-5de7-4406-bb2a-7e5c8****' or id eq '004d6a07-fe70-4b92-add5-e6e37****'.
    There is a limit of 50 filtered objects.

    Please refer to this documentation for more details.

    Hope this helps.

    If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.