Excel Add-In for Marketo

Build 24.0.9175

Emails

Query emails 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'.

GetEmailFullContent can be used to retrieve the full content of an email.

UpdateEmailContent can be used to update the content content of an email.

UpdateEmailFullContent can be used to update the full content of an email.

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 Emails WHERE Id=15457
	SELECT * FROM Emails WHERE Name='[email protected]'
	SELECT * FROM Emails WHERE FolderId=26
	SELECT * FROM Emails WHERE UpdatedAt >= '2023-03-22 00:09:14.0' AND UpdatedAt <= '2023-03-22 01:49:03.0'

Insert


	INSERT INTO Emails (Name, TemplateId, FolderId, FolderType) VALUES ('My Email', 1037, 5111, 'Program')

Update


	UPDATE Emails SET Name='CRUD Test', Description='Testing CRUD' WHERE Id=23852

Delete


	DELETE FROM Emails WHERE Id=23838
	DELETE FROM Emails WHERE Id=23759 AND Status='approved'
	DELETE FROM Emails WHERE Id IN (17008, 23764) AND Status='draft'

Columns

Name Type ReadOnly Operators Description
Id [KEY] Int True =

The unique, Marketo-assigned identifier of the email.

Status [KEY] String True =

The status of the email, draft or approved version.

Name String False =

The name of the email.

Description String False

The description of the email.

Subject String False

The email subject.

FromName String False

The from name.

FromEmail String False

The from email address.

ReplyEmail String False

The reply email address.

PreHeader String False

The pre-header text for the email.

URL String True

The URL of the asset in the Marketo UI.

TemplateId Int False

The template associated with the email.

PublishToMSI Bool True

Identifies whether the email is published.

Version Int True

The Template version type.

Operational Bool False

Identifies whether the email is operational.

TextOnly Bool False

Identifies whether the email is text only.

WebView Bool False

Identifies whether the email is web view.

AutoCopyToText Bool False

Identifies whether the email is auto copied to text.

FolderId Int False =

The unique, Marketo-assigned identifier of the parent folder/program.

FolderName String True

The name of the folder

FolderType String False =

The type of folder (Folder,Program)

WorkspaceName String True

Name of the workspace the email is part of.

CreatedAt Datetime True

Datetime the email was created.

UpdatedAt Datetime True =,>,<,>=,<=

Datetime the email was most recently updated.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175