GetExportJobStatus
Returns the status of an export job. Job status is available for 30 days after Completed or Failed status was reached.
Execute
Sample EXECUTE GetExportJobStatus Table='Leads', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE GetExportJobStatus Table='CustomObject_cdata', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE GetExportJobStatus Table='Activities', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE GetExportJobStatus Table='Activities_NewLead', Id='b4841291-0d27-48bc-8e9a-c639a6f33a0d'
EXECUTE GetExportJobStatus 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. |
Result Set Columns
| Name | Type | Description |
| Id | String | The Id of the export job. |
| Status | String | The status of the export job. 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. |