JDBC Driver for Greenhouse

Build 24.0.9062

ScheduledInterviews

Query the interviews that have been scheduled for an application.

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 ScheduledInterviews WHERE Id = 19138922007;
SELECT * FROM ScheduledInterviews WHERE ExternalEventId = '5164588007';
SELECT * FROM ScheduledInterviews WHERE ApplicationId = 4230124147;
SELECT * FROM ScheduledInterviews WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM ScheduledInterviews WHERE UpdatedAt = '2024-01-01 12:00:00.000';
SELECT * FROM ScheduledInterviews WHERE StartsAt >= '2024-01-01 12:00:00.000' AND StartsAt <= '2024-03-01 12:00:00.000';
SELECT * FROM ScheduledInterviews WHERE EndsAt = '2024-01-01 12:00:00.000';

Columns

Name Type Operators Description
Id [KEY] Int64 = Scheduled interviews ID.
ApplicationId Int64 = Application ID.
ExternalEventId String = The external event ID.
StartsAt Datetime >=,>,=,<,<= A datetime value if the interview has a precise start time, or a date value if the is an all-day event.
EndsAt Datetime >=,>,=,<,<= A datetime value if the interview has a precise start time, or a date value if the is an all-day event.
Location String The location of the interview.
VideoConferencingUrl String The URL used for video interviews, such as Zoom, Google Meets, or Microsoft Teams.
Status String One of: scheduled, awaiting_feedback, complete
CreatedAt Datetime >=,>,=,<,<= The timestamp when the scheduled interview was created.
UpdatedAt Datetime >=,>,=,<,<= The timestamp when the scheduled interview was updated.
InterviewId Int64 Interview ID.
InterviewName String Name of the interview.
OrganizerId Int64 The ID of the user who organized the interview.
OrganizerFirstName String The first name of the user who organized the interview.
OrganizerLastName String The last name of the user who organized the interview.
OrganizerName String The full name of the user who organized the interview.
OrganizerEmployeeId String The employee ID of the user who organized the interview.
Interviewers String Array of users who have interviews with the candidate.

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