I am trying to create a Data Load Tool similar to Data Loader which will upload the data from a CSV file to Salesforce. This tool is built using java and using "Bulk API". While this tool works fine, it is only creating problems when I try to insert null values through CSV.
I checked the "Bulk API Developer Guide" and it is mentioned that "Empty field values are ignored when you update records. To set a field value to null, use a field value of #N/A."
I wanted to know that is there any alternate way in which i can set the field values to "null" without having to set them to "#N/A" in CSV? Something similar to Data Loader, where blank fields are treated as "null" when we enable "Insert Null Values".