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