Convert Excel to Avro using an API
Use our API to convert your Excel 2007+ (.xlsx) data to Apache Avro
Convert
to
POST
https://dataconverter.io/api/v1/convert/xlsx-to-avro
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
{ "sheetName" : "Sheet1", "startingRow" : 0, "lastRow" : -1, "startingColumn" : 0, "skipEmptyRows" : true, "fieldNamesInFirstRow" : true, "evaluateExpressions" : true, "useSheetColumnCount" : false }
-
downloadSettings
object
{ "writeUuidAsString" : true }
Request Sample
curl -X POST "https://dataconverter.io/api/v1/convert/xlsx-to-avro" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.xlsx;type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" \
-F "uploadSettings={\"sheetName\":\"Sheet1\",\"startingRow\":0,\"lastRow\":-1,\"startingColumn\":0,\"skipEmptyRows\":true,\"fieldNamesInFirstRow\":true,\"evaluateExpressions\":true,\"useSheetColumnCount\":false};type=application/json" \
-F "downloadSettings={\"writeUuidAsString\":true};type=application/json" \
--output converted.avro