JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

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.

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