TransactionalTemplates
Get Transactional Templates.
Table Specific Information
SELECT, INSERT, UPDATE, and DELETE operations are supported for TransactionalTemplates.
Select
The driver 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 driver.
- 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 template. |
| Slug | String | True |
The immutable unique code name of the template. |
| CreatedAt | Datetime | True |
The UTC timestamp when the template was created, in YYYY-MM-DD HH:MM:SS format. |
| UpdatedAt | Datetime | True |
The date and time the template was last modified as a UTC string in YYYY-MM-DD HH:MM:SS format. |
| Labels | String | False |
The list of labels applied to the template. |
| Code | String | False |
The full HTML code of the template, with mc:edit attributes marking the editable elements - draft version. |
| Subject | String | False |
The subject line of the template, if provided - draft version. |
| FromEmail | String | False |
The default sender address for the template, if provided - draft version. |
| FromName | String | False |
The default sender from name for the template, if provided - draft version. |
| Text | String | False |
The default text part of messages sent with the template, if provided - draft version. |
| PublishName | String | True |
The same as the template name - kept as a separate field for backwards compatibility. |
| PublishCode | String | True |
The full HTML code of the template, with mc:edit attributes marking the editable elements that are available as published, if it has been published. |
| PublishSubject | String | True |
The subject line of the template, if provided. |
| PublishFromEmail | String | True |
The default sender address for the template, if provided. |
| PublishFromName | String | True |
The default sender from name for the template, if provided. |
| PublishText | String | True |
The default text part of messages sent with the template, if provided. |
| PublishedAt | Datetime | True |
The date and time the template was last published as a UTC string in YYYY-MM-DD HH:MM:SS format, or null if it has not been published. |
| IsBrokenTemplate | Boolean | True |
Indicates if the template is malformed or corrupt. |
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 to filter the templates. Only used for SELECT. |
| Publish | Boolean |
Set to false to add a draft template without publishing. Only used for INSERT and UPDATE. |