Convert JSON to ORC using an API
Use our API to convert your JSON data to Apache ORC
Convert
to
POST
https://dataconverter.io/api/v1/convert/json-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
{ "treeNodes" : [ { "name" : "object", "fieldName" : "data_object", "xpathExpression" : "/object/data/array/object", "recordBreak" : true, "field" : false }, { "name" : "title", "fieldName" : "title", "xpathExpression" : "/object/data/array/object/title", "recordBreak" : false, "field" : true }, { "name" : "lang", "fieldName" : "lang", "xpathExpression" : "/object/data/array/object/lang", "recordBreak" : false, "field" : true }, { "name" : "price", "fieldName" : "price", "xpathExpression" : "/object/data/array/object/price", "recordBreak" : false, "field" : true } ] }
-
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/json-to-orc" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.json;type=application/json" \
-F "uploadSettings={\"treeNodes\":[{\"name\":\"object\",\"fieldName\":\"data_object\",\"xpathExpression\":\"/object/data/array/object\",\"recordBreak\":true,\"field\":false},{\"name\":\"title\",\"fieldName\":\"title\",\"xpathExpression\":\"/object/data/array/object/title\",\"recordBreak\":false,\"field\":true},{\"name\":\"lang\",\"fieldName\":\"lang\",\"xpathExpression\":\"/object/data/array/object/lang\",\"recordBreak\":false,\"field\":true},{\"name\":\"price\",\"fieldName\":\"price\",\"xpathExpression\":\"/object/data/array/object/price\",\"recordBreak\":false,\"field\":true}]};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