SSIS Components for Greenhouse

Build 24.0.9062

JobStages

Query job stages.

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 JobStages WHERE Id = 2831224147;
SELECT * FROM JobStages WHERE JobId = 4232024152;
SELECT * FROM JobStages WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM JobStages WHERE UpdatedAt = '2024-01-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Job stage ID.
Name String The name of the job stage.
CreatedAt Datetime >=,>,=,<,<= The timestamp when the job stage was created.
UpdatedAt Datetime >=,>,=,<,<= The timestamp when the job stage was updated.
JobId Int64 = The ID of the job this stage belongs to.
Priority Int Numeric field used for ordering.
Interviews String Array of interview steps associated with the job stage.

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