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 |