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. |