Email

Represents an email object in Salesforce Marketing Cloud. Each record contains metadata about an email message, including subject, content area references, and send configurations. This table is used to query or manage email assets that are stored and deployed from the account.

Table-Specific Information

Select

The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.

For example, the following (but not only) queries are processed server side:

SELECT * FROM Email WHERE Id = 123

SELECT * FROM Email WHERE Id IN (123, 456)

SELECT * FROM Email WHERE CreatedDate > '2017/01/25'

Insert

You must specify the following fields when inserting to this table: Name and Subject.

INSERT INTO Email (Name, Subject) VALUES ('Testing', 'Greetings')

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Email SET Name = 'Changed' WHERE Id = 31558

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Email WHERE Id = 123

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Specifies the identifier (Id) that uniquely identifies the email asset within Marketing Cloud.
PartnerKey	String	False	Specifies the partner-provided unique Id that is associated with the email asset and is accessible only through the API.
CreatedDate	Datetime	False	Indicates the date and time when the email asset was created. This value is generated automatically by the system.
ModifiedDate	Datetime	False	Indicates the date and time when the email asset was last modified. This value updates whenever the email content or configuration changes.
Client_ID	Int	False	Specifies the Id of the client account that owns the email asset.
Name	String	False	Specifies the display name of the email asset, which appears in the user interface and in retrieval operations.
PreHeader	String	False	Contains the text that appears as the preheader for the email message on supported devices. This value provides preview context before the recipient opens the message.
Folder	String	False	[DEPRECATED] Specifies informational folder metadata that is returned during retrieval.
CategoryID	Int	False	Specifies the Id of the folder that stores the email asset within the Content Builder hierarchy.
HTMLBody	String	False	Contains the HTML markup that defines the visual structure and content of the email message.
TextBody	String	False	Contains the plain-text version of the email message that is used for recipients who receive non-HTML messages.
Subject	String	False	Specifies the subject line of the email message, which appears in the recipient's inbox.
IsActive	Bool	False	Returns a value of 'true' when the email asset is active and available for use in sends. It returns a value of 'false' when the asset is inactive or restricted through administrative controls.
IsHTMLPaste	Bool	False	Returns a value of 'true' when the email message is created from pasted HTML rather than through the visual editor. It returns a value of 'false' when the email is created using other editing methods.
ClonedFromID	Int	False	Specifies the Id of the source email from which the current email asset was cloned. This value helps track template or content lineage.
Status	String	False	Specifies the current operational status of the email asset (for example, draft, published, or archived).
EmailType	String	False	Specifies the preferred email format associated with the asset (for example, HTML or text-only).
CharacterSet	String	False	Indicates the character encoding that is used in the email message to support proper rendering of special characters.
HasDynamicSubjectLine	Bool	False	Returns a value of 'true' when the email message uses dynamic content to personalize the subject line at send time. It returns a value of 'false' when the subject line remains static for all recipients.
ContentCheckStatus	String	False	Indicates the current validation state for the email's content, which reflects whether content checks have completed successfully or are still in progress.
Client_PartnerClientKey	String	False	Specifies the partner client key that is associated with the account that owns the email asset.
ContentAreas	String	False	Contains information about the content areas that are referenced within the email message, including any reusable or dynamic content blocks.
CustomerKey	String	False	Specifies the user-supplied unique identifier for the email asset within its object type.