TransactionalTemplates
Get Transactional Templates.
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
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. |