Templates
Returns and manages email templates, including draft and published versions.
Table-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Name | = |
| Label | = |
SELECT * FROM Templates WHERE Name = 'MyTemplate'
SELECT * FROM Templates WHERE Label = 'MyLabel'
Insert
The Name column is required for INSERT operations.
INSERT INTO Templates (Name, Subject, FromEmail, FromName, Publish) VALUES ('MyTemplate', 'Hello Subject', '[email protected]', 'Sender Name', 'true')
Update
The Name column is required for UPDATE operations, as it acts as the key.
UPDATE Templates SET Labels = '[\"adw\", \"eww\"]' WHERE Name = 'testname'
Delete
The Name column is required for DELETE operations.
DELETE FROM Templates 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 more granular control over the data 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. |