ResultItem
Contains results of asynchronous API call.
View-Specific Information
Select
The provider 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 provider processes other filters client-side within the provider.
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. |