PollExportJobStatus
Continuously polls the bulk API for the status of the export job until one of the following statuses is returned: Completed, Cancelled, Failed.
Execute
Sample EXECUTE PollExportJobStatus Table='Leads', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE PollExportJobStatus Table='CustomObject_cdata', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE PollExportJobStatus Table='Activities', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE PollExportJobStatus Table='Activities_NewLead', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE PollExportJobStatus Table='ProgramMembers', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
Input
| Name | Type | Required | Description |
| Id | String | True | The id of the export job. |
| Table | String | True | The exported table. Only certain tables support bulk exports, including: Activities, 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 export job. |
| Status | String | The status of the export process. Applicable values: Created, Queued, Processing, Cancelled, Completed, Failed. |
| Format | String | The format of the export job. |
| CreatedAt | Datetime | The date when the export job was created. |
| QueuedAt | Datetime | The date when the export job was queued. |
| StartedAt | Datetime | The date when the export job was started. |
| FinishedAt | Datetime | The date when the export job was finished. |
| NumberOfRecords | Long | The number of records contained within the generated file. |
| FileSize | Long | The size in bytes of the generated file. |
| FileChecksum | String | The checksum of the generated file. |
| ErrorMessage | String | The error message in case of failed status. |
| 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. |