CData Python Connector for Greenhouse

Build 24.0.9062

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.

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