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]"
query string
This is the SQL SELECT statement to run. The table name is determined either by the input file name or the tablename parameter.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery" -F "infile=@[YOUR FILE]" -F "query=select * from example order by 1" -H "Authorization: Token [YOUR TOKEN]"
tablename string
SQL table name
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?tablename=invoice_detail" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
empty string
Specify comma separated field positions to convert empty fields to NULL. Default is to not convert to NULL if a text field.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?empty=1,5" -F "infile=@[YOUR FILE]" -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/csvquery?encoding=ascii" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
exclude string
Exclude these fields in conversion. Use this if you want to convert all fields except these.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?exclude=5" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
exnulls string
Do not output NULL for NULL in these fields. Many CSV files have NULL for NULL fields in a database table. The default is to convert those to NULL in SQL for instance, or null in JSON, however, NULL can be a legitimate value. Use this option to exclude fields from the default conversion.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?exnulls=5" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
fields string
Include these fields in conversion. You specify fields by their position, starting at 1. If you wanted the first 5 fields, you can type 1,2,3,4,5 or 1-5. The default is to include all fields.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?fields=1,2,3" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
index string
Columns to create index on, i.e. 3,4. If generating SQL statements, this will generate a "CREATE INDEX" SQL statement.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?index=3,4" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
json boolean
Generate JSON output
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?json=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
jsonl boolean
Generate JSONL/JSONND output. This format has fully valid JSON on each line.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?jsonl=1" -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/csvquery?key=id" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
noheader boolean
Input CSV file has no column headings
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?noheader=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
nulls string
Convert 'NULL' to a NULL SQL value or null JSON value. Many popular tools export the string NULL in place of NULL values in tables. By default, the converter will convert ALL NULL values to a NULL SQL value or null JSON value. If you use this option, only the fields specified will be converted. See also exnulls.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?nulls=1,5,6" -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/csvquery?password=bob&username=bee" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
skiplines integer
Skip/Ignore N record at top of input file. You may have a CSV file with empty lines or extra verbiage at the top. Use this option to skip those lines.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?skiplines=2" -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/csvquery?username=johnny&password=xyz" -F "infile=https://www.xyz.com/myinputfile.csv" -H "Authorization: Token [YOUR TOKEN]"
xin boolean
Input file is an Excel file with either .xlsx or .xls extension. If your column headers do not start on line 1, then use the "skiplines" option to skip to the header or data.
curl -X POST "https://www.convertcsv.io/api/v1/csvquery?xin=1" -F "infile=@[YOUR FILE]" -H "Authorization: Token [YOUR TOKEN]"
