IdeaExchange · Idea Details

This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
Vote 10  points

Justin Clarke

Apex Data Loader - Bulk API - Handle Null Date Fields

Salesforce Platform, Web Services API

Existing Feature

The documentation for Bulk API says that blanks are skipped in the CSV file, so you must insert a #N/A into the field if you want to null that field.

This works fine for most fields, except when using #N/A on a date field, the Apex Data Loader fails to update those rows that use #N/A for date fields and the error log reports:

Error converting value to correct data type: Date Conversion FAILED

As of right now, there does not be any way to insert nulls into date fields using the Apex Data Loader.

4 years ago · 4 Comments · Report Abuse

1 to 4 of 4

Ideas

Apps

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce.com takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.