Templates

Contains all email templates available in the account, including type, name, and last-modified date.

Table Specific Information

SELECT, INSERT, UPDATE and DELETE are supported for Templates.

Select

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

Id supports the '=' operator.
Type supports the '=' operator.
Category supports the '=' operator.
DateCreated supports the '=,<,>,<=,>=' operator.
CreatedBy supports the '=' operator.
FolderId supports the '=' operator.
ContentType supports the '=' operator.

SELECT * FROM Templates WHERE Id = '1245'
SELECT * FROM Templates WHERE Type = 'base'
SELECT * FROM Templates WHERE Category = 'asdw'
SELECT * FROM Templates WHERE FolderId = '15151'
SELECT * FROM Templates WHERE ContentType = 'template'
SELECT * FROM Templates WHERE CreatedBy = 'abcd'
SELECT * FROM Templates WHERE DateCreated = '2024-02-07 00:00:37.0'
SELECT * FROM Templates WHERE DateCreated >= '2024-02-07 00:00:37.0'
SELECT * FROM Templates WHERE DateCreated <= '2024-02-07 00:00:37.0'
SELECT * FROM Templates WHERE DateCreated > '2024-02-07 00:00:37.0'
SELECT * FROM Templates WHERE DateCreated < '2024-02-07 00:00:37.0'

Insert

Columns Name and Html are required for Insert.

INSERT INTO Templates(name, html) VALUES ('test_template', '<title></title>')

Update

Column Html is required for Update. As the html column is not returned from the server during SELECT operation, the user will have to provider HTML column in the UPDATE statement.

Update Templates set html='<title></title>', name='abcd' where id=13693

Delete

Delete from Templates where id=13695

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique identifier of the template, used to reference or manage it within Mailchimp.
Type	String	True	The type of the template, which can be 'user', 'base', or 'gallery', depending on its origin and usage.
Name	String	False	The descriptive name of the template, helping users easily identify it within their Mailchimp account.
DragAndDrop	Boolean	True	Indicates whether the template is built using Mailchimp's drag-and-drop editor, allowing for easy visual design adjustments.
Responsive	Boolean	True	Specifies whether the template includes responsive design features, such as media queries, for optimized display on different devices.
Category	String	True	The category under which the template is listed, if applicable, helping organize and classify templates by purpose or theme.
DateCreated	Datetime	True	The date and time when the template was initially created within Mailchimp.
CreatedBy	String	True	The username or login of the person who originally created the template.
Active	Boolean	True	Indicates whether the template is currently active. User templates are not deleted but can be marked as inactive.
FolderId	String	False	The unique identifier of the folder where the template is stored, useful for organizing templates into logical groups.
Thumbnail	String	True	The URL of the template's thumbnail image, if available, providing a visual preview of the design.
ShareUrl	String	True	The URL for sharing the template externally. For more information, see Mailchimp's documentation at http://kb.mailchimp.com/templates/basic-and-themes/how-to-share-a-template.
ContentType	String	True	Specifies how the content of the template is structured, such as HTML or drag-and-drop format. The allowed values are template, multichannel, html.
DateEdited	Datetime	True	The date and time when the template was last modified, recorded in ISO 8601 format.
EditedBy	String	True	The username or login of the person who last edited the template.

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
Html	String	The raw HTML source code of the template. The Mailchimp Template Language is supported in any HTML code provided via the API and can be used in INSERT and UPDATE operations.

Power BI Connector for Mailchimp