ODBC Driver for Salesforce

Build 22.0.8462

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.

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 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'.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462