SSIS Components for Greenhouse

Build 24.0.9062

Applications

Query all of an organization?s applications.

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 Applications WHERE Id = 29045175007;
SELECT * FROM Applications WHERE JobIds = '39055172007';
SELECT * FROM Applications WHERE Status = 'open';
SELECT * FROM Applications WHERE AppliedAt >= '2024-01-01 12:00:00.000' AND AppliedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Applications WHERE LastActivityAt >= '2024-01-01 12:00:00.000' AND AppliedAt <= '2024-03-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Application ID.
CandidateId Int64 The ID of the candidate who is applying for the job.
Prospect Bool If true, the is a prospect application which means that the associated person is a prospect and has not yet applied for the job.
AppliedAt Datetime >=,>,=,<,<= The timestamp when a candidate / prospect applied for a job.
RejectedAt Datetime The timestamp when a candidate / prospect got rejected.
LastActivityAt Datetime >=,>,=,<,<= The timestamp of the last activity in the application.
Location String The contents of the location question on a job post.
SourceId Int64 The ID of the source.
SourcePublicName String The name of the source.
CreditedToId Int64 The ID of the user who will receive credit for the application.
CreditedToFirstName String The first name of the user who will receive credit for the application.
CreditedToLastName String The second name of the user who will receive credit for the application.
CreditedToName String The full name of the user who will receive credit for the application.
CreditedToEmployeeId String The ID of the employee who will receive credit for the application.
RejectionReasonId Int64 The ID of the rejection reason.
RejectionReasonName String The name of the rejection reason.
RejectionDetails String The details of the rejection.
JobIds String = Comma-delimited list of the job IDs that the candidate applied for.
Jobs String An array containing the job that the candidate applied for.
JobPostId Int64 The ID of the job post through which the candidate applied. This value is null if the application was created through other means.
Status String = One of: active, rejected, hired, converted.
CurrentStageId Int64 The job stage's unique identifier.
CurrentStageName String The name for the job stage.
Answers String The answers provided to the questions in the job post for the application.

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