SSIS Components for Azure Active Directory

Build 24.0.9060

DirectoryRoleTemplates

Retrieves all DirectoryRoleTemplates 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 DirectoryRoleTemplates WHERE Id = '62e90394-69f5-4237-9190-012177145e10'
SELECT * FROM DirectoryRoleTemplates WHERE Id IN ('62e90394-69f5-4237-9190-012177145e10', '2af84b1e-32c8-42b7-82bc-daa82404023b')
SELECT * FROM DirectoryRoleTemplates WHERE DisplayName LIKE '%Admin%'

Columns

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

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