PollImportJobStatus
Will continuously poll the bulk API for the status of the import job until one of the following statuses is returned: Complete, Failed.
Execute
Sample EXECUTE PollImportJobStatus Id=1608, Table='Leads'
EXECUTE PollImportJobStatus Id=1609, Table='CustomObject_cdata'
EXECUTE PollImportJobStatus Id=1610, Table='ProgramMembers'
Input
| Name | Type | Required | Description |
| Id | String | True | The id of the import job. |
| Table | String | True | The table to import. Only certain tables support bulk imports, including: Leads, ProgramMembers and any custom object. |
| PollingInterval | Integer | False | The time in milliseconds between each poll. If not specified the value provided in the connection string will be used. See JobPollingInterval connection property for more information and the default value. |
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. |