Convert JSON to CSV using an API
Use our API to convert your JSON data to CSV
Convert
to
POST
https://dataconverter.io/api/v1/convert/json-to-csv
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
{ "fieldSeparator" : ",", "fieldNamesInFirstRow" : true, "startingQuote" : "\"", "endingQuote" : "\"", "newLine" : "\\n", "nullValuePolicy" : "EMPTY_STRING", "emptyStringValuePolicy" : "QUOTED_EMPTY_STRING", "forceQuote" : false, "charset" : "UTF-8" }
Request Sample
curl -X POST "https://dataconverter.io/api/v1/convert/json-to-csv" \
-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={\"fieldSeparator\":\",\",\"fieldNamesInFirstRow\":true,\"startingQuote\":\"\\\"\",\"endingQuote\":\"\\\"\",\"newLine\":\"\\\\n\",\"nullValuePolicy\":\"EMPTY_STRING\",\"emptyStringValuePolicy\":\"QUOTED_EMPTY_STRING\",\"forceQuote\":false,\"charset\":\"UTF-8\"};type=application/json" \
--output converted.csv