BulkExportJobs
Returns a list of bulk export jobs that were created in the past 7 days.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
SELECT * FROM BulkExportJobs WHERE Table='Leads'
SELECT * FROM BulkExportJobs WHERE Table='Leads' AND Status='Created'
Columns
| Name | Type | Operators | Description |
| ExportId [KEY] | String | Unique id of the export job. | |
| Table [KEY] | String | = | Name of the table the export job was created for. Can be Activities, Leads, ProgramMembers or any CustomObject_ table. |
| Status | String | = | The status of the export. |
| Format | String | The format of the file. | |
| CreatedAt | Datetime | The date when the export request was created. | |
| QueuedAt | Datetime | The queue time of the export job. This column will have a value only when 'Queued' status is reached. | |
| StartedAt | Datetime | The start time of the export job. This column will have a value only when 'Processing' status is reached. | |
| FinishedAt | Datetime | The finish time of export job. This column will have a value only when status is 'Completed' or 'Failed'. | |
| FileSize | Long | The size of file in bytes. This column will have a value only when status is 'Completed'. | |
| FileChecksum | String | The checksum of the generated file. | |
| NumberOfRecords | Long | The number of records in the export file. This column will have a value only when the status is 'Completed'. | |
| ErrorMessage | String | The error message in case of failed status. |