Excel Add-In for Azure Active Directory

Build 24.0.9062

DirectoryRoles

Retrieves all DirectoryRoles for the authenticated user.

Table Specific Information

Select

Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition. For example:

SELECT * FROM DirectoryRoles WHERE Id = '0f1032b0-ec73-4f72-836e-3b4411ea70c6'
SELECT * FROM DirectoryRoles WHERE RoleTemplateId = '4d6ac14f-3453-41d0-bef9-a3e0c569773a'
SELECT * FROM DirectoryRoles WHERE Id IN ('0f1032b0-ec73-4f72-836e-3b4411ea70c6', '081c8ba7-15a3-4c39-9972-053427b3c857')
SELECT * FROM DirectoryRoles WHERE DisplayName LIKE '%Admin%'

Columns

Name Type Description
id [KEY] String The id of the directoryRole.
deletedDateTime Datetime The datetime when the directoryRole was deleted.
description String The description of the directoryRole.
displayName String The displayName of the directoryRole.
roleTemplateId String The roleTemplateId of the directoryRole.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062