Convert TSV to ORC using an API

Use our API to convert your Tab Separated Values data to Apache ORC

Convert to
POST https://dataconverter.io/api/v1/convert/tsv-to-orc

After signing up and verifying your email, you will be able to create an API Token in your account settings.

Headers
  • Authorization (required) Bearer <<YOUR_API_TOKEN_HERE>>
Request Body — (multipart/form-data)
  • file (required) string <binary>

  • uploadSettings

    object 
    {
  "fieldSeparator" : "\t",
  "allowMultiLineText" : true,
  "allowQuoteInField" : true,
  "fieldNamesInFirstRow" : true,
  "startingQuote" : "\"",
  "endingQuote" : "\"",
  "lineSeparators" : "\\n,\\r\\n,\\r",
  "trimFields" : true,
  "skipEmptyRows" : false,
  "charset" : "UTF-8"
}

  • downloadSettings

    object 
    {
  "useTimestampInstant" : false,
  "overwrite" : true,
  "isUTC" : false,
  "writeUuidAsString" : true,
  "rowBatchVersion" : "ORIGINAL",
  "bigDecimalPrecision" : 38,
  "bigDecimalScale" : 10,
  "roundingMode" : "HALF_UP",
  "compressionKind" : "NONE"
}
Request Sample

curl -X POST "https://dataconverter.io/api/v1/convert/tsv-to-orc" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.tsv;type=text/tab-separated-values" \
-F "uploadSettings={\"fieldSeparator\":\"\\t\",\"allowMultiLineText\":true,\"allowQuoteInField\":true,\"fieldNamesInFirstRow\":true,\"startingQuote\":\"\\\"\",\"endingQuote\":\"\\\"\",\"lineSeparators\":\"\\\\n,\\\\r\\\\n,\\\\r\",\"trimFields\":true,\"skipEmptyRows\":false,\"charset\":\"UTF-8\"};type=application/json" \
-F "downloadSettings={\"useTimestampInstant\":false,\"overwrite\":true,\"isUTC\":false,\"writeUuidAsString\":true,\"rowBatchVersion\":\"ORIGINAL\",\"bigDecimalPrecision\":38,\"bigDecimalScale\":10,\"roundingMode\":\"HALF_UP\",\"compressionKind\":\"NONE\"};type=application/json" \
--output converted.orc
Show All APIs