EmailTemplates
Query the email templates of the organization.
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 EmailTemplates WHERE Id = 5275706112;
SELECT * FROM EmailTemplates WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM EmailTemplates WHERE UpdatedAt = '2024-03-01 12:00:00.000';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | Email template ID. |
| Name | String | Name of the email template. | |
| Description | String | Description of the email template. | |
| Default | Bool | Whether it is a default template or not. | |
| CreatedAt | Datetime | >=,>,=,<,<= | The timestamp when the email template was created. |
| UpdatedAt | Datetime | >=,>,=,<,<= | The timestamp when the email template was updated. |
| Type | String | One of: new_candidate, weekly_status, daily_recruiting, stage_transition, new_scorecard, new_referral, agency_candidate_status, agency_candidate_stage, take_home_test_email, candidate_auto_reply, candidate_rejection, scorecard_reminder, interviewer_invite, candidate_email, team_email, none, extending_offer, new_agency_submission, non_admin_welcome, job_admin_welcome, site_admin_welcome, prospect_referral_receipt, candidate_referral_receipt, candidate_availability_request, candidate_availability_confirmation. | |
| From | String | The user who is set to send the email. | |
| CC | String | Comma-delimited list of emails in CC. | |
| Body | String | The plain text body of the e-mail. | |
| HtmlBody | String | The body of the e-mail with html styling code. | |
| UserId | Int64 | The user ID to whom the template belongs to. | |
| UserFirstName | String | The first name of the user. | |
| UserLastName | String | The second name of the user. | |
| UserName | String | The full name of the user. | |
| UserEmployeeId | Int64 | The employee ID of the user. |