GetImportSendStatus
Retrieves the status of an ImportSend automation in Salesforce Marketing Cloud. This automation imports data and triggers send operations, and the procedure returns information about execution state, completion time, and any related errors.
Input
| Name | Type | Required | Description |
| TokenID | String | True | Specifies the unique identifier (Id) that is returned by the ImportAndSend stored procedure. This Id links the status request to a specific ImportSend automation and ensures that the correct run history is retrieved. |
Result Set Columns
| Name | Type | Description |
| Status | String | Returns the current processing status of the ImportSend automation (for example, 'Pending', 'Running', 'Completed', or 'Error'). This value indicates the operational state of the automation at the time of the request. |
| LastUpdate | Datetime | Returns the most recent date and time when the ImportSend automation record was updated. This timestamp reflects changes to processing status or logging information. |
| CreatedTime | Datetime | Returns the date and time when the ImportSend automation was created. This timestamp provides a historical reference for tracking the lifecycle of the automation. |
| StartTime | Datetime | Returns the date and time when the ImportSend automation began processing the submitted import file. This timestamp helps determine when the automation started evaluating and sending messages. |
| CompletedTime | Datetime | Returns the date and time when the ImportSend automation finished processing. This timestamp confirms that all import and send operations have completed for the associated request. |
| LastRunTime | Datetime | Returns the date and time when the ImportSend automation last executed. This value helps administrators review recent activity and monitor automation frequency. |
| Source | String | Returns the source system or configuration that initiated the ImportSend automation. This value identifies where the import originated and assists in tracking end-to-end message-processing workflows. |
| Inserted | Integer | Returns the number of new records that were written to the _MobileSubscription data extension during the import process. This count reflects the volume of subscribers who were added as part of the automation. |
| Updated | Integer | Returns the number of existing subscriber records that were updated during the import process. This value indicates how many contacts received refreshed subscription attributes or statuses. |
| Invalid | Integer | Returns the number of rows in the import file that cannot be processed because of validation errors or missing data. This count helps identify issues that require correction before resubmitting the file. |