TransactionalTemplates

Contains all transactional email templates stored in the account.

Table Specific Information

SELECT, INSERT, UPDATE, and DELETE operations are supported for TransactionalTemplates.

Select

The add-in will use the Mailchimp API to process WHERE clause conditions built with the following columns and operator. The rest of the filter is executed client-side within the add-in.

Name supports the '=' operator.
Label supports the '=' operator.

SELECT * FROM TransactionalTemplates WHERE Name = 'MyTemplate'
SELECT * FROM TransactionalTemplates WHERE Label = 'MyLabel'

Insert

Name is required for the INSERT operation.

INSERT INTO TransactionalTemplates (Name, Subject, FromEmail, FromName, Publish) VALUES ('MyTemplate', 'Hello Subject', '[email protected]', 'Sender Name', true)

Update

Name is required for the UPDATE operation as it acts as the key.

UPDATE TransactionalTemplates SET labels='[\"adw\", \"eww\"]' WHERE name='testname'

Delete

Name

is required for the DELETE operation.

DELETE FROM TransactionalTemplates WHERE Name = 'MyTemplate'

Columns


Name	Type	ReadOnly	Description
Name [KEY]	String	False	The name of the transactional email template.
Slug	String	True	The immutable unique identifier (slug) for the template used to reference it in API calls.
CreatedAt	Datetime	True	The Coordinated Universal Time (UTC) timestamp indicating when the template was created, formatted as YYYY-MM-DD HH:MM:SS.
UpdatedAt	Datetime	True	The UTC timestamp indicating when the template was last modified, formatted as YYYY-MM-DD HH:MM:SS.
Labels	String	False	A list of labels applied to the template for organizational or filtering purposes.
Code	String	False	The full HTML source code of the template, including mc:edit attributes that mark editable regions in the draft version.
Subject	String	False	The subject line defined for the draft version of the template, if specified.
FromEmail	String	False	The default sender email address associated with the draft version of the template.
FromName	String	False	The default sender display name associated with the draft version of the template.
Text	String	False	The default plain-text version of the message associated with the draft version of the template.
PublishName	String	True	The published version's display name for the template. Maintained separately for backward compatibility.
PublishCode	String	True	The full HTML source code of the published version of the template, including mc:edit attributes that mark editable elements.
PublishSubject	String	True	The subject line defined for the published version of the template, if specified.
PublishFromEmail	String	True	The default sender email address associated with the published version of the template.
PublishFromName	String	True	The default sender display name associated with the published version of the template.
PublishText	String	True	The default plain-text version of the message associated with the published version of the template.
PublishedAt	Datetime	True	The UTC timestamp indicating when the template was last published, formatted as YYYY-MM-DD HH:MM:SS. If the value is null, the template has not been published.
IsBrokenTemplate	Boolean	True	Indicates whether the template is malformed or corrupt and cannot be rendered properly.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Label	String	An optional label used to filter templates during SELECT operations.
Publish	Boolean	If the value is set to 'false', adds a draft version of the template without publishing it, applicable for INSERT and UPDATE operations.

Excel Add-In for Mailchimp