Bulk API 2.0 returns failed and success results with empty field values

This issue occurs when the field names in the CSV file header do not exactly match the Salesforce object's Field API names in terms of case sensitivity.

Bulk API 2.0 uses the CSV column headers to map data to Salesforce fields. Salesforce Field API names are case-sensitive in this context. If the column header in your CSV file uses a different case than the official Field API name — for example, using name instead of Name, or description instead of Description — Bulk API 2.0 may still process the record create or update operation without throwing an error. However, when you retrieve the job results, the API cannot match the original column header to the field, and returns an empty string for that field in the results response.

To Fix the Issue

Review your CSV file and compare each column header name against the Field API names for the Salesforce object you are loading data into. Ensure that the column headers in the CSV exactly match the Field API names, including capitalization.

For example:

• Use Name (not name or NAME)
• Use Description (not description)
• Use the full API name for custom fields, such as Custom_Field__c (not custom_field__c)

After correcting the column headers in the CSV file, re-upload the job. The job results should then return the correct field values in the success and failure result responses.