ImportResultsSummary
A retrieve-only object that contains status and aggregate information on an individual import started from an ImportDefinition.
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.
For example, the following (but not only) queries are processed server side:
SELECT * FROM ImportResultsSummary WHERE Id = 123 SELECT * FROM ImportResultsSummary WHERE Id IN (123, 456) SELECT * FROM ImportResultsSummary WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | System-controlled, read-only text string identifier for object. |
| ID | Int | Read-only identifier for an object. |
| Client_ID | Long | The Id of the client. |
| ImportDefinitionCustomerKey | String | Specifies customer key associated with import definition used in an import. |
| TaskResultID | Int | Indicates the task result ID associated with a summary of import results. |
| ImportStatus | String | Specifies import status associated with an import. |
| StartDate | String | Indicates the start date for the time period for which to retrieve import results. |
| EndDate | String | Specifies the end data of an activity. |
| DestinationID | String | Specifies the identifier of either the list or the data extension associated with a completed import. |
| NumberSuccessful | Int | Specifies number of successful record imports resulting from an import action. |
| NumberDuplicated | Int | Specifies number of duplicated records resulting from an import. |
| NumberErrors | Int | Indicates number of errors resulting from an import. |
| TotalRows | Int | Indicates the total number of rows included in the summary of an import. |
| ImportType | String | Specfies type of import performed. |