EmailSendDefinition

Record that contains the message information, sender profile, delivery profile, and audience information.

Table-Specific Information

Select

The driver 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 driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

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

SELECT * FROM EmailSendDefinition

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	The Id of the client.
CreatedDate	Datetime	False	Indicates the date and time of the object's creation.
ModifiedDate	Datetime	False	Indicates the last time object information was modified.
ObjectID	String	False	System-controlled, text string identifier for object.
CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
Name	String	False	Name of the object or property.
CategoryID	Int	False	Specifies the identifier of the folder containing the email.
Description	String	False	Describes and provides information regarding the object.
SendClassification_CustomerKey	String	False	User-supplied unique identifier for an object within an object type.
SenderProfile_CustomerKey	String	True	User-supplied unique identifier for an object within an object type
SenderProfile_FromName	String	True	Specifies the default email message From Name.
SenderProfile_FromAddress	String	True	Indicates From address associated with a object.
DeliveryProfile_SourceAddressType	String	True	Indicates the source IP address type used with the delivery profile.
DeliveryProfile_PrivateIP	String	True	Contains information on the private IP address associated with a delivery profile.
DeliveryProfile_DomainType	String	True	Defines the type of domain.
DeliveryProfile_PrivateDomain	String	True	Defines private domain to use as part of a delivery profile or send definition.
DeliveryProfile_HeaderSalutationSource	String	True	Defines source of header salutation for a delivery profile or send definition.
DeliveryProfile_FooterSalutationSource	String	True	Defines source of a footer salutation to use as part of a delivery profile or send definition (Default, ContentLibrary, or None).
SuppressTracking	Bool	False	Indicates whether the send definition suppresses tracking results for associated sends.
IsSendLogging	Bool	False	Indicates whether send logging is enabled for the specified send definition
Email_ID	Int	True	The Id of the email.
CCEmail	String	False	Carbon copy email address.
BccEmail	String	False	Indicates email addresses to receive blind carbon copy of a message.
AutoBccEmail	String	False	Defines blind carbon copy email address to which to send a message as part of an email send definition.
TestEmailAddr	String	False	Defines an email address to which to send a test message as part of an email send definition.
EmailSubject	String	False	Subject of the email.
DynamicEmailSubject	String	False	Contains content to be used in a dynamic subject line.
IsMultipart	Bool	False	Indicates whether the email is sent with Multipart/MIME enabled.
IsWrapped	Bool	False	Indicates whether an email send contains the links necessary to process tracking information for clicks.
SendLimit	Int	False	Indicates limit of messages to send as part of a send definition within a predefined send window.
DeduplicateByEmail	Bool	False	Indicates whether a send definition should de-duplicate multiple emails sent to the same email address.
ExclusionFilter	String	False	Contains a string of AMPscript that can evaluate to true or false, used to exclude email addresses from a send definition.
Additional	String	False	The ID for a send that customers use as a campaign ID.
IsPlatformObject	Bool	False	Indicated whether the object is a platform object.