ResultItem
Contains the individual result records returned from an asynchronous API call in Salesforce Marketing Cloud. Each record represents the outcome of a processed item, such as a contact import or message send.
View-Specific Information
Select
The connector 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 connector processes other filters client-side within the connector.
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 | Specifies the identifier (Id) of the asynchronous API request queue that stores and tracks queued API operations. |
| RequestID | String | Specifies the unique Id of the initial asynchronous API call that initiated the request. |
| ConversationID | String | Specifies the unique Id that groups together multiple asynchronous API calls that must be processed as a single logical unit. |
| CorrelationID | String | Identifies the correlation key that links related objects and operations across multiple asynchronous requests. |
| Client_ID | Int | Indicates the Id of the client that is associated with the asynchronous API request. |
| CreatedDate | Datetime | Indicates the date and time when the result item was created as part of asynchronous API processing. |
| StatusCode | String | Defines the status code returned for the asynchronous API request. |
| StatusMessage | String | Describes the detailed status of the asynchronous API call, including success, warnings, or errors. |
| OrdinalID | Int | Specifies the system-controlled, read-only ordinal Id that represents the position of the result item within a sequence. |
| ErrorCode | Int | Identifies the numeric error code that is returned when the asynchronous API request encounters a failure condition. |
| RequestType | String | Indicates whether the API request was processed as a synchronous or asynchronous operation. |
| RequestObjectType | String | Defines the type of object that is involved in the API request, such as an email, data extension, or triggered send. |
| ResultType | Int | Indicates whether the returned result originated from synchronous or asynchronous API processing. |
| Client_PartnerClientKey | String | Specifies the user-defined partner client key that is assigned to the account for partner-level correlation and tracking. |