This is a list of file types supported in BIgObject Import Service, with file type specific handling instructions.

File type specific handling instructions are added to misc field, defined in Data Import Service

Comma Separated Values (CSV)

{
    "skip": 0,
    "sep": ",",
    "comment": "#",
    "fields": -1,
    "quotes": true,
    "trim": false
}
  • skip: Number of lines to skip before loading.
  • sep: Separator character in your CSV record.
  • comment: Character for indicating a CSV record is commented.
  • fields: How many fields are there in one record
  • quotes: Whether users are too picky about quote correctness. True for lazy quote.
  • trim: Whether leading white spaces are removed. True to remove.