Departments
Query the departments of an organization.
SELECT
Note: Filters provided with one of the supported operators listed in the "Operators" column can be processed server-side, all the other filters are processed client-side.
SELECT * FROM Departments WHERE Id = 4158401007;
SELECT * FROM Departments WHERE ExternalId = '5158401007';
Columns
Name | Type | Operators | Description |
Id [KEY] | Int64 | = | Department ID. |
Name | String | The department's name. | |
ParentId | Int64 | The ID of the department's parent. | |
ParentDepartmentExternalId | String | The external ID of the department's parent. | |
ChildIds | String | Comma-delimited list of the department's child IDs. | |
ChildDepartmentExternalIds | String | Comma-delimited list of the external IDs of the department's children. | |
ExternalId | An arbitrary ID provided by an external source. | = | An arbitrary ID provided by an external source |