Candidates
Query all of an organization's candidates.
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 Candidates WHERE Id = 23411175007;
SELECT * FROM Candidates WHERE CreatedAt < '2024-01-03 12:00:00.000' AND CreatedAt > '2024-03-03 12:00:00.000';
SELECT * FROM Candidates WHERE UpdatedAt = '2024-01-03 12:00:00';
SELECT * FROM Candidates WHERE JobIds = '4789302007';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | Candidate ID. |
| FirstName | String | First name of the candidate. | |
| LastName | String | Last name of the candidate | |
| Company | String | The company at which the candidate currently works. | |
| Title | String | The candidate's current title. | |
| CreatedAt | Datetime | >=,>,<,<=,= | The timestamp when the candidate was created. |
| UpdatedAt | Datetime | >=,>,<,<=,= | The timestamp when the candidate was updated. |
| LastActivity | Datetime | The timestamp of the last activity upon the candidate. | |
| IsPrivate | Bool | Whether the candidate is private or not. | |
| PhotoUrl | String | The photo URL of the candidate. | |
| Attachments | String | Array of candidate attachments. | |
| JobIds | String | = | Comma-delimited list of the job IDs that the candidate applied for. |
| ApplicationIds | String | Comma-delimited list of the application IDs submitted by the candidate. | |
| PhoneNumbers | String | Array of phone numbers. | |
| Addresses | String | Array of addresses. | |
| EmailAddresses | String | Array of email addresses. | |
| WebsiteAddresses | String | Array of website addresses. | |
| SocialMediaAddresses | String | Array of social media addresses. | |
| Recruiter | String | An object representing the recruiter user who is responsible for the candidate. | |
| RecruiterId | String | The ID of the recruiter. | |
| Coordinator | String | An object representing the coordinator of the candidate | |
| CoordinatorId | String | The ID of the coordinator | |
| CanEmail | Bool | Whether the candidate can email or not. | |
| Tags | String | Comma-delimited list of tags. | |
| Educations | String | Array of educations. | |
| Employments | String | Array of employments. | |
| LinkedUserIds | String | Comma-delimited list of linked user IDs. |