JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

ListSend

Specifies retrieve-only properties associated with the list(s) for a completed send.

View-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 ListSend

SELECT * FROM ListSend WHERE Id = 123

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

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

Columns

Name Type Description
ID [KEY] Int Read-only identifier for an object.
PartnerKey String Unique identifier provided by partner for an object, accessible only via API.
Client_ID Int The Id of the client.
SendID Int Contains identifier for a specific send.
List_ID Int Read-only identifier for an object.
List_ListName String The name of the list.
Duplicates Int Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists).
InvalidAddresses Int Specifies the number of invalid addresses associated with a send.
ExistingUndeliverables Int Indicates whether bounces occurred on previous send.
ExistingUnsubscribes Int Indicates whether unsubscriptions occurred on previous send.
HardBounces Int Indicates number of hard bounces associated with a send.
SoftBounces Int Indicates number of soft bounces associated with a specific send.
OtherBounces Int Specifies number of Other-type bounces in a send.
ForwardedEmails Int Number of emails forwarded for a send.
UniqueClicks Int Indicates number of unique clicks on message.
UniqueOpens Int Indicates number of unique opens resulting from a triggered send.
NumberSent Int Number of emails actually sent as part of an email send. This number reflects all of the sent messages and may include bounced messages.
NumberDelivered Int Number of sent emails that did not bounce.
Unsubscribes Int Indicates the number of unsubscribe events associated with a send.
MissingAddresses Int Specifies number of missing addresses encountered within a send.
PreviewURL String Indicates URL used to preview the message associated with a send.

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