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.

ビュー固有の情報

このビューはCreateJobV2 ストアドプロシージャを実行後に成功、失敗、または未処理のレコードに関する情報を表示します。

SELECT

このビューをクエリするには、JobID、RecordState、ColumnDelimiter カラムをWHERE 句に指定する必要があります。次に例を示します。

 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.