ADO.NET Provider for Greenhouse

Build 24.0.9062

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.

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