JobRecordResultsV2
Returns the set of records processed or affected by a specific job, such as data import, export, or update operations. Useful for tracking outcomes, auditing changes, or troubleshooting issues related to bulk or asynchronous jobs.
Table Specific Information
This view shows information about the records that have passed, failed, or are unprocessed after executing the CreateJobV2 stored procedure.
Select
To query this view you must specify the JobId, RecordState, and ColumnDelimiter columns in the WHERE clause. For example:
SELECT * FROM JobRecordResultsV2 WHERE JobId = '133485445' AND ColumnDelimiter = 'COMMA' AND RecordState = 'Failed'
Columns
| Name | Type | Description |
| ID [KEY] | String | The unique Salesforce ID of the individual record that was processed as part of the bulk job. |
| Created | Boolean | Indicates whether the record was newly created (true) or updated (false) during the bulk operation. |
| RowFromOriginalCSV | String | A truncated view of the original CSV row that was submitted in the job request for this record. |
| JobId | String | The unique identifier of the job this record result belongs to. |
| RecordState | String | The processing outcome for the record. Valid values include 'Successful', 'Failed', and 'Unprocessed'. |
| ColumnDelimiter | String | The delimiter used to separate fields in the CSV data submitted with the job. Valid options are 'BACKQUOTE', 'CARET', 'COMMA', 'PIPE', 'SEMICOLON', and 'TAB'. |
| Error | String | Error code and message for the failed records. |