DirectoryRoles
Contains a list of directory roles, detailing roles assigned to users and groups within the organization.
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 unique identifier for the directory role, used to differentiate it from other roles. |
| deletedDateTime | Datetime | The timestamp indicating when the directory role was deleted, or null if it has not been deleted. |
| description | String | A detailed explanation of the directory role's purpose and functionality. |
| displayName | String | The human-readable name of the directory role, typically used in user interfaces. |
| roleTemplateId | String | The unique identifier for the template that defines the permissions and structure of this directory role. |