JobRecordResultsV2

Retrieves a list of records for a specific job.

Table Specific Information

This view shows information about the records that have passed, failed, or are unprocessed after executing the CreateJobV2 stored procedure.

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'

Name	Type	Description
ID [KEY]	String	ID of the record that was successfully processed.
Created	Boolean	The name of the table. This must be specified when retrieving data from PickListInformation.
RowFromOriginalCSV	String	Truncated row that was provided in the original job data upload request.
JobId	String	Specified the unique Id of the job.
RecordState	String	Specifies the type of the records that were processed by Salesforce. Valid values are 'Successful', 'Failed', 'Unprocessed'.
ColumnDelimiter	String	The column delimiter used for CSV job data. Valid values are 'BACKQUOTE','CARET','COMMA', 'PIPE', 'SEMICOLON', 'TAB'.