Jobs
Query the jobs 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 Jobs WHERE Id = 5831224147;
SELECT * FROM Jobs WHERE RequisitionId = '4551228237';
SELECT * FROM Jobs WHERE Status = 'open';
SELECT * FROM Jobs WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Jobs WHERE UpdatedAt = '2024-01-01 12:00:00.000';
Columns
Name | Type | Operators | Description |
Id [KEY] | Int64 | = | Job ID. |
Name | String | Name of the job. | |
RequisitionId | String | = | An arbitrary ID provided by an external source. |
Notes | String | Notes for the job. | |
Confidential | Bool | If the job is confidential or not. | |
Status | String | = | One of: open, closed, draft. |
CreatedAt | Datetime | >=,>,<,<=,= | The timestamp when the job was created. |
OpenedAt | Datetime | The timestamp when the job was opened. | |
ClosedAt | Datetime | The timestamp when the job was closed. | |
UpdatedAt | Datetime | >=,>,<,<=,= | The timestamp when the job was last updated. |
IsTemplate | Bool | Indicates if the job is designed as a template to create other jobs. | |
CopiedFromId | Int64 | The ID of the source job. | |
DepartmentIds | String | Comma-delimited list of department IDs the job belongs to. | |
Departments | String | Array of departments which the job belongs to. | |
OfficeIds | String | Comma-delimited list of office IDs the job is associated with. | |
Offices | String | Array of offices which the job is associated with. | |
OpeningIds | String | Comma-delimited list of opening IDs associated with the job. | |
Openings | String | Array of openings which the job is associated with. |