Unable to filter using advance query capabilities in Microsoft Graph SDK for .Net

Question

Unable to filter using advance query capabilities in Microsoft Graph SDK for .Net

Wajahat Ali Khalid 25

I'm Using Microsoft Graph SDK for .Net and GraphServiceClient to retrieve the list of users but cannot apply a filter on the user property 'employeeType'. I keep getting the error 'Unsupported or invalid query filter clause specified for property 'employeeType' of resource 'User'.

result = await graphClient.Users.GetAsync(requestConfiguration =>
                {
                    requestConfiguration.QueryParameters.Filter = "employeeType eq 'Employee'";
                    requestConfiguration.QueryParameters.Count = true;
                    requestConfiguration.Headers.Add("ConsistencyLevel", "eventual");
                });

This is how I'm trying to query. Employee Type property supports advanced query capabilities as documented by Microsoft. Still, I keep getting 400 exception with the message 'Unsupported or invalid query filter clause specified for property 'employeeType' of resource 'User'.

Accepted answer

0 additional answers

Your answer

Answer 1

CarlZhao-MSFT 46,371

Hi @Wajahat Ali Khalid

I tested your code snippet and it works fine for me. Can you share more context? Have you tested the API in Postman or Graph Explorer and does it work?

User's image

Hope this helps.

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

Wajahat Ali Khalid 25

Hi, @CarlZhao-MSFT Can you share how you are authenticating your graph client? This is how I'm authenticating my graph client. Could this be the issue? I need server-to-server authentication this is the Microsoft recommended way I'm following.

var scopes = new[] { "https://graph.microsoft.com/.default" };

            var options = new ClientSecretCredentialOptions
            {
                AuthorityHost = AzureAuthorityHosts.AzurePublicCloud,
            };

            var clientSecretCredential = new ClientSecretCredential(
                tenantConfig.AB2C_TenantId, tenantConfig.AB2C_AppID, tenantConfig.AB2C_ClientSecret, options);

            return new GraphServiceClient(clientSecretCredential, scopes);

I've also tried using Postman and getting the same error.
User's image

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
CarlZhao-MSFT 46,371 Reputation points

2023-11-07T07:38:07.82+00:00
Hi @Wajahat Ali Khalid

B2C tenants do not support advanced queries, so you cannot use the advanced query functionality of the $filter query parameter with B2C tenants.

Also, the employeeType attribute is only specific to Azure AD, it does not apply to Azure AD B2C tenants. You should create a custom employeeType attribute for this and grant it to your users.

You can grant custom attributes to a user by calling the Update User API.

See this document to find your extension app.

Finally, you can try using the $filter query parameter for the employeeType custom attribute to filter users.

var users = await graphClient.Users.GetAsync((requestConfiguration) => { requestConfiguration.QueryParameters.Filter = "extension_xxxxxxx61f44c07a3cc353cb1d03960_employeeType eq 'Employee'"; });

Share via

Unable to filter using advance query capabilities in Microsoft Graph SDK for .Net

0 additional answers

Your answer