ResultItem
Contains results of asynchronous API call.
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 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. |