Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

ResultItem

Contains results of asynchronous API call.

View-Specific Information

Select

The add-in 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 add-in processes other filters client-side within the add-in. 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 ResultItem

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) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695