Line Ending Header
When you create a Bulk API 2.0 job, specify a line ending that matches the line ending used to create the CSV file using the lineEnding request field. Bulk API 2.0 supports two line-ending formats:
- LF linefeed
- CRLF carriage-return plus linefeed
The default line ending, if not specified, is LF. Different operating systems use different characters to mark the end of a line.
Unix / Linux / OS X uses LF (line feed, '\n', 0x0A).
Windows / DOS uses CRLF (carriage return followed by line feed, '\r\n', 0x0D0A).
For example,
{
"object" : "Account",
"contentType" : "CSV",
"operation" : "insert",
"lineEnding" : "LF"
}
Note that it’s possible that the text editor used to create the CSV file is configured for a specific line-ending format and might supersede the default operating system format.