JDBC Driver for Azure Active Directory

Build 22.0.8509


Retrieves all DirectoryRoleTemplates for the authenticated user.

Table Specific Information


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%'


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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509