JDBC Driver for Salesforce Marketing Cloud

Build 24.0.9062

ResultItem

Contains results of asynchronous API call.

View-Specific Information

Select

The 本製品 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 本製品 processes other filters client-side within the 本製品.

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

SELECT * FROM ResultItem WHERE AsyncAPIRequestQueueID = 123

SELECT * FROM ResultItem WHERE AsyncAPIRequestQueueID IN (123, 456)

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

Columns

Name Type Description
AsyncAPIRequestQueueID Int The Id of the async API request queue.
RequestID String Unique ID of initial async API call.
ConversationID String Unique ID of initial async API call. All requests that should be processed as a single unit will have the same ConversationID.
CorrelationID String Identifies correlation of objects across several requests.
Client_ID Int The Id of the client.
CreatedDate Datetime Read-only date and time of the object's creation.
StatusCode String Status of async API request.
StatusMessage String Describes the status of an API call.
OrdinalID Int System-controlled, read-only text string identifier for object.
ErrorCode Int Identifies the error of an API request via a numeric code.
RequestType String Defines request as synchronous or asynchronous API.
RequestObjectType String Defines type of the Request object, such as email or triggered send.
ResultType Int Defines result as coming from synchronous or asynchronous API.
Client_PartnerClientKey String User-defined partner key for an account.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062