How to query users with extension attribute excluding NULL in graph api?

Question

I want to query users in my tenant with the extension attribute but excluding users with the blank/null value for that extension. Currently this is my query:

https://graph.microsoft.com/v1.0/users?$select=id,givenName,surname,extension_---------&$filter=contains(extension-----_----)

But I keep getting this error:

{
    "error": {
        "code": "BadRequest",
        "message": "Invalid filter clause",
        "innerError": {
            "date": "2023-03-02T03:52:23",
            "request-id": "ada4bb9b-75c3-4daa-b8ae-85c4d21fe51a",
            "client-request-id": "96211638-62e7-b6c8-3678-d65123d14178"
        }
    }
}

Can anyone help me to get the right query? Thanks!

Answer 1

Hi @user0808

According to my test, the existing graph $filter query parameter cannot complete your context requirement, because the advanced query capabilities are currently not available for Azure AD B2C tenants.

I suggest you get the user collection and then filter locally.

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.

Answer 2

Hello user0808,

Thanks for posting!

Currently $filter query parameter does not support for Open extension attribute. Please refer the below screenshot:

Reference link for the same.

The following table shows support for $filter by extension properties on the user object.

Reference link for the same.

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.