Search K
CSV to JSON
Convert between CSV and JSON formats in both directions. Upload a CSV or TSV file to get a JSON array of objects, or upload JSON (an array of objects, or an object wrapping one) to get a CSV file.
API Endpoint
POST /api/v1/tools/files/csv-json
Accepts multipart form data with a CSV, TSV, or JSON file and a JSON settings field.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| pretty | boolean | No | true | Pretty-print JSON output with indentation |
Example Request
CSV to JSON:
bash
curl -X POST http://localhost:1349/api/v1/tools/files/csv-json \
-H "Authorization: Bearer si_your-api-key" \
-F "file=@users.csv" \
-F 'settings={"pretty": true}'JSON to CSV:
bash
curl -X POST http://localhost:1349/api/v1/tools/files/csv-json \
-H "Authorization: Bearer si_your-api-key" \
-F "file=@users.json" \
-F 'settings={}'Example Response
json
{
"jobId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"downloadUrl": "/api/v1/download/a1b2c3d4-e5f6-7890-abcd-ef1234567890/users.json",
"originalSize": 1500,
"processedSize": 2200
}Notes
- Conversion direction is auto-detected from the input file extension:
.csvor.tsvproduces.json, and.jsonproduces.csv. - The
prettyparameter only affects JSON output. When set tofalse, the output is a compact single-line JSON string. - JSON input can be an array of objects, an object with a single key holding such an array (like
{"data": [...]}), or a flat object of scalar values. Each object becomes a row, and each key becomes a column header. A flat object comes out as a two-columnkey,valuetable. Objects with several top-level keys, and empty arrays, are rejected. - TSV (tab-separated values) files are supported alongside CSV.
