Object Reference for the Salesforce Platform
jNewer Version Available
BackgroundOperationResult
Stores error messages generated when running Async SOQL queries or
importing data into big objects using Bulk API. This is a big object,
available in API version 37.0 and later.
Each instance of BackgroundOperationResult represents one
error. The Message field stores the text of the error
message. The ParentID field stores the:
- job ID of the query, in case of Async SOQL
- batch ID for the data import, in case of Bulk API
Bulk API validates data at the time of import, and generates an error message for the first
occurrence of invalid data in any row of the data file. The validation performed depends on the
type of data being imported.
- Text—The length of the input string must be less than or equal to the length of the corresponding text field in the target object.
- Number—The input data must be a number, whose scale and precision are compatible with the corresponding number field in the target object.
- ID—The input data must be a valid 15- or 18-character ID.
- DateTime—The input data must be a valid dateTime value, in the approved format.
- Lookup—The lookup value must be a valid 15- or 18-character ID.
Fields
| Field Name | Details |
|---|---|
| CreatedById |
|
| CreatedDate |
|
| Data |
|
| Id |
|
| Message |
|
| MessageType |
|
| ParentId |
|
Usage
You can check for errors by querying the BackgroundOperationResult object. For example, this query returns details of all
errors in a data file imported using Bulk API, whose batch ID is 751xx000000006OAAQ.
1SELECT CreatedbyId, CreatedDate, Id, Message, MessageType, ParentId FROM BackgroundOperationResult WHERE ParentId = “751xx000000006OAAQ”