Offices
Query the offices of the 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 Offices WHERE Id = 4231215147;
SELECT * FROM Offices WHERE ExternalId = '1435210252';
Columns
Name | Type | Operators | Description |
Id [KEY] | Int64 | = | Office ID. |
Name | String | Name of the office. | |
Location | String | Location of the office. | |
PrimaryContactUserId | String | The primary contact user ID. | |
ParentId | Int64 | The office parent ID. | |
ParentOfficeExternalId | String | The external ID of this office's parent. | |
ChildIds | String | The office's children IDs. | |
ChildOfficeExternalIds | String | The external IDs of this office's children. | |
ExternalId | String | = | An arbitrary ID provided by an external source; does not map to another entity in Greenhouse. |