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