JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

Send

Used to send email and retrieve aggregate data. This table does not support deletes or updates.

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 Send

SELECT * FROM Send WHERE Id = 123

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

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

Insert

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

INSERT INTO Send(FromName, Email_Id, List_Id) VALUES('NASA', 31677, 52362)

Columns

Name Type ReadOnly Description
ID [KEY] Int False

Identifier for an object.

PartnerKey String False

Unique identifier provided by partner for an object, accessible only via API.

CreatedDate Datetime False

Indicates the date and time of the object's creation.

ModifiedDate Datetime False

Indicates the last time object information was modified.

Client_ID Int False

The Id of the client.

Client_PartnerClientKey String False

User-defined partner key for an account.

Email_ID Int False

Identifier for an object.

Email_PartnerKey String False

Unique identifier provided by partner for an object, accessible only via API.

SendDate Datetime False

Indicates the date on which a send occurred.

FromAddress String False

Indicates From address associated with a object.

FromName String False

Specifies the default email message From Name.

Duplicates Int False

Represent the number of duplicate email addresses associated with a send.

InvalidAddresses Int False

Specifies the number of invalid addresses associated with a send.

ExistingUndeliverables Int False

Indicates whether bounces occurred on previous send.

ExistingUnsubscribes Int False

Indicates whether unsubscriptions occurred on previous send.

HardBounces Int False

Indicates number of hard bounces associated with a send.

SoftBounces Int False

Indicates number of soft bounces associated with a specific send.

OtherBounces Int False

Specifies number of Other-type bounces in a send.

ForwardedEmails Int False

Number of emails forwarded for a send.

UniqueClicks Int False

Indicates number of unique clicks on message.

UniqueOpens Int False

Indicates number of unique opens resulting from a triggered send.

NumberSent Int False

Number of emails actually sent as part of an email send.

NumberDelivered Int False

Number of sent emails that did not bounce.

NumberTargeted Int False

Indicates the number of possible recipients for an email send.

NumberErrored Int False

Number of emails not sent as part of a send because an error occurred while trying to build the email.

NumberExcluded Int False

Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status.

Unsubscribes Int False

Indicates the number of unsubscribe events associated with a send.

MissingAddresses Int False

Specifies number of missing addresses encountered within a send.

Subject String False

Defines the status of an object.

PreviewURL String False

Indicates URL used to preview the message associated with a send.

SentDate Datetime False

Indicates date on which a send took place.

EmailName String False

Specifies the name of an email message associated with a send.

Status String False

The status of the object.

IsMultipart Bool False

Indicates whether the email is sent with Multipart/MIME enabled.

SendLimit Int False

Indicates limit of messages to send as part of a send definition within a predefined send window.

SendWindowOpen Datetime False

Defines the beginning of a send window for a send definition.

SendWindowClose Datetime False

Defines the end of a send window for a send definition.

IsAlwaysOn Bool False

Indicates whether the request can be performed while the system is is maintenance mode.

Additional String False

The ID for a send that customers use as a campaign ID.

BCCEmail String False

Indicates email addresses to receive blind carbon copy of a message.

EmailSendDefinition_ObjectID String False

System-controlled, text string identifier for object.

EmailSendDefinition_CustomerKey String False

The customer key of the email send definition.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
List_Id Int

The Id of the list to be sent.

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