ImportResultsSummary
Provides summary results for import jobs that were initiated from an import definition in Salesforce Marketing Cloud. Each record includes the total rows processed, successful imports, and errors encountered. This retrieve-only view supports reporting and monitoring of data import performance.
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 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 | Specifies the system-controlled text string identifier (Id) that is assigned to this import-results summary object. |
| ID | Int | Returns the read-only Id that uniquely identifies this summary record. |
| Client_ID | Long | Specifies the Id of the client that is associated with this import-results summary. |
| ImportDefinitionCustomerKey | String | Specifies the customer key that is associated with the import definition that produced these results. |
| TaskResultID | Int | Returns the task result Id that is associated with this summary of import results. |
| ImportStatus | String | Specifies the status of the import operation that generated this summary. |
| StartDate | String | Indicates the start date for the time range that is used to retrieve import-result information. |
| EndDate | String | Specifies the end date for the time range that is used to retrieve import-result information. |
| DestinationID | String | Specifies the Id of the list or data extension that received the imported records. |
| NumberSuccessful | Int | Indicates the number of records that were successfully imported during the operation. |
| NumberDuplicated | Int | Indicates the number of duplicated records that were encountered during the import operation. |
| NumberErrors | Int | Indicates the number of records that resulted in errors during the import process. |
| TotalRows | Int | Indicates the total number of rows included in this import-results summary. |
| ImportType | String | Specifies the type of import that was performed. |