Excel Add-In for Greenhouse

Build 24.0.9062

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

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