Query email templates for a Marketo organization.

Note: This table uses the draft/approved versioning API. By default both versions are retrieved/modified. To interact with a specific version use the filter Status='draft' or Status='approved'.

CreateEmailTemplate can be used to create email templates.

GetEmailTemplateContent can be used to retrieve the email template content.

UpdateEmailTemplateContent can be used to update the email template content.

Select

Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.

For example, the following queries are processed server-side:

	SELECT * FROM EmailTemplates WHERE ID=1038
	SELECT * FROM EmailTemplates WHERE Name='Test Template 3'
	SELECT * FROM EmailTemplates WHERE Status='approved'
	SELECT * FROM EmailTemplates WHERE ID=1038 AND Status='approved'

Update

	UPDATE EmailTemplates SET Description='test update' WHERE Id=1039

Delete

	DELETE FROM EmailTemplates WHERE Id=1014
	DELETE FROM EmailTemplates WHERE Id=1034 AND Status='draft'
	DELETE FROM EmailTemplates WHERE Name='Serenity (Marketo Starter Template)

Columns