EmailSendDefinition

Stores email send definitions in Salesforce Marketing Cloud. Each record includes message details, sender and delivery profiles, and audience configurations. This table allows you to define and manage parameters that control how and when emails are sent to subscribers.

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 EmailSendDefinition WHERE ObjectID = 123

SELECT * FROM EmailSendDefinition WHERE ObjectID IN (123, 456)

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

Insert

You must specify the following fields when inserting to this table: Name, SendClassification_CustomerKey, and Email_Id.

INSERT INTO EmailSendDefinition (Name, SendClassification_CustomerKey, Email_Id) VALUES ('Testing', 13507, 31677)

Update

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

UPDATE EmailSendDefinition SET Description = 'Changed' WHERE ObjectId = 'acasascas'

Delete

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

DELETE FROM EmailSendDefinition WHERE ObjectId = 'sdfsdf123'

Columns


Name	Type	ReadOnly	Description
Client_ID	Int	True	Specifies the identifier (Id) of the client account that owns the send definition within Marketing Cloud.
CreatedDate	Datetime	False	Indicates the date and time when the send definition was created. This value is generated automatically by the system.
ModifiedDate	Datetime	False	Indicates the date and time when the send definition was last modified. This value updates whenever configuration properties or delivery settings change.
ObjectID	String	False	Contains the system-controlled text string Id that uniquely represents the send definition across internal services and API operations.
CustomerKey	String	False	Specifies the user-supplied unique Id for the send definition within its object type. This key is often used in API-based send operations and retrieval calls.
Name	String	False	Defines the display name of the send definition that appears in the user interface and within associated send workflows.
CategoryID	Int	False	Specifies the Id of the folder that stores the send definition within the Content Builder or Email Studio hierarchy.
Description	String	False	Provides a descriptive explanation of the send definition's purpose, configuration, or business context.
SendClassification_CustomerKey	String	False	Specifies the user-defined unique Id for the send classification that governs CAN-SPAM classification, delivery profile, and sender profile settings.
SenderProfile_CustomerKey	String	True	Specifies the user-defined unique Id for the sender profile that controls the visible sender information for outbound email messages.
SenderProfile_FromName	String	True	Defines the display name that appears in the email's 'From' field when the send definition is used.
SenderProfile_FromAddress	String	True	Specifies the email address that appears in the 'From' field for the send definition's outbound messages.
DeliveryProfile_SourceAddressType	String	True	Indicates the type of source internet protocol (IP) address that the delivery profile uses for message delivery (for example, default or dedicated IP pools).
DeliveryProfile_PrivateIP	String	True	Contains information about the private IP addresses that are assigned to the delivery profile for routing outbound email traffic.
DeliveryProfile_DomainType	String	True	Defines the domain type (for example, a default domain or a private authenticated domain) that is used by the delivery profile.
DeliveryProfile_PrivateDomain	String	True	Specifies the private domain that the delivery profile uses for authenticated sending or domain alignment within deliverability configurations.
DeliveryProfile_HeaderSalutationSource	String	True	Defines the source for the header salutation (for example, a profile attribute, a default value, or a content-derived value) that is applied to outbound messages .
DeliveryProfile_FooterSalutationSource	String	True	Defines the source of the footer salutation applied to outbound messages. Valid options include Default, ContentLibrary, or None.
SuppressTracking	Bool	False	Returns a value of 'true' when the send definition is configured to suppress tracking data for opens and clicks. It returns a value of 'false' when tracking metrics are fully captured and reported.
IsSendLogging	Bool	False	Returns a value of 'true' when send logging is enabled for the send definition, allowing send-level data to be captured in a designated data extension. It returns a value of 'false' when logging is disabled.
Email_ID	Int	True	Specifies the Id of the email asset that is associated with the send definition.
CCEmail	String	False	Specifies one or more carbon copy (CC) email addresses that should receive copies of the outbound message.
BccEmail	String	False	Specifies one or more blind carbon copy (BCC) email addresses that should receive copies of the outbound message without visibility to other recipients.
AutoBccEmail	String	False	Defines the automatically applied BCC address that receives a copy of every message sent through the send definition.
TestEmailAddr	String	False	Specifies an email address that is used to send test messages for validation prior to execution of a production send.
EmailSubject	String	False	Defines the static subject line that is applied to messages sent through the send definition.
DynamicEmailSubject	String	False	Contains subject-line content that can be personalized dynamically for recipients during send processing.
IsMultipart	Bool	False	Returns a value of 'true' when the email is sent using Multipart/MIME formatting to deliver both HTML and plain-text versions. It returns a value of 'false' when a single-part format is used.
IsWrapped	Bool	False	Returns a value of 'true' when link-wrapping is enabled to support click tracking within the message. It returns a value of 'false' when the message's links are not wrapped for tracking purposes.
SendLimit	Int	False	Specifies the maximum number of messages that can be sent through the send definition within a predefined send window.
DeduplicateByEmail	Bool	False	Returns a value of 'true' when the send definition removes duplicate email addresses before sending. It returns a value of 'false' when duplicate addresses are preserved.
ExclusionFilter	String	False	Contains AMPscript logic that evaluates to a Boolean result to determine whether a recipient should be excluded from the send.
Additional	String	False	Specifies a campaign-related Id that is associated with the send, often used for reporting or external system correlation.
IsPlatformObject	Bool	False	Returns a value of 'true' when the send definition is classified as a platform-level object for internal use. It returns a value of 'false' when the object is not platform-scoped.