GetImportJobStatus
Returns the status of an import job.
Execute
Sample EXECUTE GetImportJobStatus Id=1608, Table='Leads'
EXECUTE GetImportJobStatus Id=1609, Table='CustomObject_cdata'
EXECUTE GetImportJobStatus Id=1610, Table='ProgramMembers'
Input
Name | Type | Required | Description |
Id | String | True | The id of the import job. |
Table | String | True | The table that data was imported to. Only certain tables support bulk imports, including: Leads, ProgramMembers and any custom object. |
Result Set Columns
Name | Type | Description |
Id | String | The Id of the import job. |
Status | String | The status of the import job. Applicable values: Queued, Importing, Complete, Failed. |
RowsProcessed | Integer | The number of rows processed so far. |
RowsFailed | Integer | The number of rows failed so far. |
RowsWithWarning | Integer | The number of rows with a warning so far. |
Message | String | The status message of the batch. |
Success | Boolean | Boolean indicating if the procedure was executed successfully. If false, the output parameter 'Details' will contain the failure details. |
Details | String | Details of execution failure. NULL if success=true. |