CData Python Connector for Greenhouse

Build 24.0.9062

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.

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