EmailTemplates

Query, update and delete EmailTemplates for a Marketo organization.

Table Specific Information

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of email templates from the target instance, filterable by name and status.

SELECT * FROM EmailTemplates WHERE Name = 'CRUD Test'

Retrieve the email record for the given target Id.

SELECT * FROM EmailTemplates WHERE Id = 1192

Any field that is not read-only can be updated.

UPDATE EmailTemplates SET Name = 'Update Test' Description = 'Testing Update' WHERE Id = 1192

To delete a Email you can specify the ID or Name field.

DELETE FROM EmailTemplates WHERE Id = 1192
DELETE FROM EmailTemplates WHERE Name in ('Test1', 'Test2')


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
FolderId	Integer	True		The Id of the folder
FolderType	String	True		The Type of folder The allowed values are Folder, Program.
FolderName	String	True		The Name of folder
Status	String	True	True	Status filter for draft or approved versions
UpdatedAt	Datetime	True		Datetime the asset was most recently updated
Url	String	True		Url of the asset in the Marketo UI
Version	Integer	True		The Template version type The allowed values are 1, 2.
Workspace	String	True		Name of the workspace
Content	String	True		HTML content for template. Multipart file.