Templates

A list an account's available templates.

Table Specific Information

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

Select

The component 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 component.

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 individual id for the template.
Type	String	True	The type of template (user, base, or gallery).
Name	String	False	The name of the template.
DragAndDrop	Boolean	True	Whether or not the template uses the drag and drop editor.
Responsive	Boolean	True	Whether or not the template contains media queries to make it responsive.
Category	String	True	If available, the category the template is listed in.
DateCreated	Datetime	True	The date and time the template was created.
CreatedBy	String	True	The login name for template's creator.
Active	Boolean	True	User templates are not 'deleted,' but rather marked as 'inactive.' Returns whether or not the template is still active.
FolderId	String	False	The id of the folder the template is currently in.
Thumbnail	String	True	If available, the URL for a thumbnail of the template.
ShareUrl	String	True	The URL used for template sharing. For more information, see: http://kb.mailchimp.com/templates/basic-and-themes/how-to-share-a-template
ContentType	String	True	How the template's content is put together. The allowed values are template, multichannel, html.
DateEdited	Datetime	True	The date and time the template was edited in ISO 8601 format.
EditedBy	String	True	The login name 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 for the template. We support the Mailchimp Template Language in any HTML code passed via the API. Can be used for INSERT and UPDATE

SSIS Components for Mailchimp