office365 - 用于 onPremisesExtensionAttributes 的 Microsoft Graph 过滤器

Question

我有一个具有以下属性的 Microsoft Graph 用户:

"onPremisesExtensionAttributes": {
            "extensionAttribute1": "attr1",
            "extensionAttribute2": null,
            "extensionAttribute3": null,
            "extensionAttribute4": null,
             etc.
        },

我似乎找不到关于如何过滤此属性的任何文档或示例。我试过了:

https://graph.microsoft.com/beta/users?$filter=extensionAttribute1 eq 'attr1'
https://graph.microsoft.com/beta/users?$filter=onPremisesExtensionAttributes/extensionAttribute1 eq 'attr1'
https://graph.microsoft.com/beta/users?$filter=onPremisesExtensionAttributes/any(x:startswith(x,'attr1'))

所有这些都会导致错误的请求，所以很明显有问题。

"code": "BadRequest",
"message": "Invalid filter clause",

问题:您如何针对 onPremisesExtensionAttributes 或包含命名属性列表(例如 extensionAttribute1...n)的任何其他属性设置过滤器格式？对于字符串列表(例如 proxyAddresses)，您可以执行以下操作:

$filter=proxyAddresses/any(x:startswith(x,%27smtp:myemail%27))

Answer 1

您现在可以过滤 onPremisesExtensionAttributes :

https://graph.microsoft.com/v1.0/users?$count=true&$filter=onPremisesExtensionAttributes/extensionAttribute1 eq 'attr1'

需要注意的两个重要点:

您需要设置 ConsistencyLevel HTTP 请求头到 eventual .否则你会得到一个 400状态代码返回以下消息 Property 'extensionAttribute1' does not exist as a declared property or extension property.

您需要包含 $count=true即使你不在乎计数，否则你会得到一个 400状态代码返回以下消息 Property 'extensionAttribute1' does not exist as a declared property or extension property.

来源: https://developer.microsoft.com/en-us/office/blogs/microsoft-graph-advanced-queries-for-directory-objects-are-now-generally-available/ .