JDBC Driver for Marketo

Build 22.0.8462

EmailTemplates

Query, update and delete EmailTemplates for a Marketo organization.

Table Specific Information

Select

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

SELECT * FROM EmailTemplates WHERE Name = 'CRUD Test'

Retrieve the email record for the given target Id.

SELECT * FROM EmailTemplates WHERE Id = 1192

Update

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

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

Delete

To delete a Email you must specify the ID field.

DELETE FROM EmailTemplates WHERE Id = 1192

Columns

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462