ODBC Driver for Salesforce

Build 26.0.9770

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.

View-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 References 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 Deprecated. The delimiter used in CSV data is now auto-detected; manual specification is no longer required. The field will remain available and mirrored when specified in the criteria, otherwise the auto-detected value will be pushed.
Error String Error code and message for the failed records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770