infile
string
This is the input file: raw data, or URL. Choose one of the options of "Local File", "URL", or "Data"
curl -X POST "https://www.convertcsv.io/api/v1/csv2json/" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
bearer None
Bearer string to use in Auth for URLs used as input
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?bearer=78954237898937598" -F "infile=https://www.data.com/files/inputfile" -H "Authorization: Token [YOUR TOKEN]"
encoding string
File encoding - if not passed, the converter will attempt to determine the encoding by looking at the first few thousand bytes of the file. Typical values are: utf-8, utf-16.
You can see a list of all supported types here: https://docs.python.org/3/library/codecs.html
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?encoding=ascii" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
key string
Key value of target array in input data. By default the first repeating group is used (JSON array or XML repeating tag). See the "uselargest" option. If your JSON is not an array and you want to use the whole structure, then pass a dash -
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?key=id" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
limit integer
Limit number of output records to N, i.e. 100. If you have a large output file, use this option to limit your output.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?limit=10" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
lines boolean
Input file is JSON Lines (JSON ND). This is auto-detected so setting this option allows auto-detection to be skipped. If converting to JSON - then use this to output JSON Lines.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?lines=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
noheading boolean
Do not output CSV headers.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?noheading=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
outdelimiter string
Output file delimiter, i.e. : See also: outtab, outpipe, outsemi
Depending on our operating system and delimiter, you may have to quote the delimiter in the OS shell, or URL encode the delimiter if used in a query string.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv" -F "infile=@[YOUR FILE]" -F outdelimiter=":" -H "Authorization: Token [YOUR TOKEN]"
outpipe boolean
Output delimiter is |. This is a convenience method sense | has special meaning in some command line shells. In the API query string, it is easier to use than encoding the query string. See also: outdelimiter, outtab, outsemi
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?outpipe=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
outsemi boolean
Output delimiter is semi-colon. This is a convenience method sense semi-colon has special meaning in some command line shells. In the API query string, it is easier to use than encoding the query string. See also: outdelimiter, outtab, outpipe
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?outsemi=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
outtab boolean
Output delimiter is Tab. This is a convenience method sense Tab is difficult to specify. See also: outdelimiter, outsemi, outpipe
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?outtab=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
password string
Password for URL data source
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?password=bob&username=bee" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
quotingstyle string
Output quoting in CSV output, N=None, M=Minimal, A=ALL. A will wrap all fields in double quotes. M will only wrap if necessary. N will not wrap with double quotes but will backslash special characters.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?quotingstyle=A" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
sheetname string
Name of worksheet if outputting XLSX, default Sheet1
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?sheetname=Data" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
suppress boolean
Supress line break in data
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?suppress=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
table boolean
Generate ASCII table
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?table=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
timestamp boolean
Convert numeric timestamp to string
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?timestamp=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
token None
Token string to use for authorization when using a URL endpoint as input
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?token=78954237898937598" -F "infile=https://www.data.com/files/inputfile" -H "Authorization: Token [YOUR TOKEN]"
uselargest boolean
Choose largest array to convert. You typically will want to use "key" instead.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?uselargest=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
username string
Username for URL data source. This is only used when URLs are the data source. See password also.
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?username=johnny&password=xyz" -F "infile=https://www.xyz.com/myinputfile.csv" -H "Authorization: Token [YOUR TOKEN]"
xlsx boolean
Generate Excel
curl -X POST "https://www.convertcsv.io/api/v1/json2csv?xlsx=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
