Excel Add-In for Azure Active Directory

Build 24.0.9062

AdministrativeUnits

Retrieves all AdministrativeUnits 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 AdministrativeUnits WHERE Id = '1721e354-9b76-49d5-bdf1-bb30a936c3ab'
SELECT * FROM AdministrativeUnits WHERE Id IN ('1721e354-9b76-49d5-bdf1-bb30a936c3ab')
SELECT * FROM AdministrativeUnits WHERE DisplayName LIKE '%Test%'

Columns

Name Type Description
id [KEY] String The id of the administrativeUnit.
deletedDateTime Datetime The datetime when the administrativeUnit was deleted.
description String The description of the administrativeUnit.
displayName String The displayName of the administrativeUnit.
isMemberManagementRestricted Bool Indicator if administrativeUnit is member management restricted.
visibility String The visibility of the administrativeUnit.

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