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