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