infile
Local File
or URL
Or Data
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]"