‎Filtering Users On The Basis Of Domains‎ Using Graph API

Question

Hello. I am trying to get the users of a particular domain via the users endpoint.

https://graph.microsoft.com/v1.0/users.

I have tried using the endswith filter on the userPrincipalName in the following manner:

https://graph.microsoft.com/v1.0/users?$filter=endswith(userPrincipalName,'domain.com')

but it returns Request_UnsupportedQuery

Could anyone please help me out on what filters need to be used to restrict the result set on the said criteria

OR

if there is an entirely different endpoint to do this.

Thanks. :)

Answer 1

@DevUser-4116 Unfortunately, the $filter operators doesn't include endswith and contains as of now. The supported $filter parameters are listed here. In the given parameters, I don't see any parameter that can help filtering based on domain name in the UPN.

There is an active feedback regarding this feature here:
https://microsoftgraph.uservoice.com/forums/920506-microsoft-graph-feature-requests/suggestions/36040288-useful-user-endpoint-filtering. Please vote for it as this is monitored by the product team.

If you just want to get a list of users with specific domain name in UPN suffix, you can use below PowerShell Cmdlet.

Get-AzureADUser | Where-Object {$_.UserPrincipalName -like '@domain.name'}

---

Please do not forget to "Accept the answer" wherever the information provided helps you. This will help others in the community as well.

Answer 2

You can use the beta endpoint for the Microsoft Graph like below to get what you need.

https://graph.microsoft.com/beta/users?$count=true&$filter=endswith(userPrincipalName, 'some domain name')

You have to include the Request Header of ConsistencyLevel=eventual in your query.