Returns the Mailchimp Transactional templates created in the Mailchimp user interface, including draft and published content.

View-Specific Information

This view returns the Mailchimp Transactional templates created in the Mailchimp user interface, including draft and published content.

Select

To retrieve all records from this view:

SELECT * FROM McTemplates

Columns

Name	Type	Description
McTemplateId [KEY]	Integer	The Mailchimp template Id.
McTemplateName	String	The name of the template.
Labels	String	The list of labels applied to the template.
Code	String	The template HTML for the draft version.
Subject	String	The default subject line of the template.
FromEmail	String	The default sending address of the template.
FromName	String	The default from name of the template.
Text	String	The template text for the draft version.
PublishCode	String	The template HTML for the published version.
PublishText	String	The template text for the published version.
PublishedAt	Datetime	The date and time the template was published as a UTC string in YYYY-MM-DD HH:MM:SS format.
CreatedAt	Datetime	The date and time the template was created as a UTC string in YYYY-MM-DD HH:MM:SS format.
UpdatedAt	Datetime	The date and time the template was last updated as a UTC string in YYYY-MM-DD HH:MM:SS format.
DraftUpdatedAt	Datetime	The date and time the template draft was last updated as a UTC string in YYYY-MM-DD HH:MM:SS format.
IsBrokenTemplate	Boolean	Indicates whether the template has rendering errors.