data-csv-to-json Edge Function — Data

data-csv-to-json — CSV to typed JSON array

Converts a CSV string to a typed JSON array, auto-inferring numbers, booleans, and null values.

---

API

POST /api/data-csv-to-json

Request body

Field	Type	Required	Default	Description
csv	string	✅	—	The CSV string to convert
delimiter	string	❌	','	Field delimiter
inferTypes	boolean	❌	true	Auto-cast numbers, booleans, null

Type inference rules (when inferTypes=true):

• Empty string → null
• "true" / "false" → boolean
• Numeric strings → number
• Everything else → string

Success response (200)

{
  "success": true,
  "data": {
    "data": [{ "name": "Alice", "age": 30, "active": true }],
    "headers": ["name", "age", "active"],
    "rowCount": 1
  }
}

Error responses

Code	HTTP	When
INVALID_INPUT	400	Missing csv field
INTERNAL_ERROR	500	Unexpected error

---

Usage

cURL

curl -X POST "$FUNCTION_URL" \
  -H "Content-Type: application/json" \
  -d '{"csv": "name,age,active\nAlice,30,true"}'

TypeScript / JavaScript (HTTP)

const response = await fetch(FUNCTION_URL, {
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({ csv: csvString, inferTypes: true }),
});
const { data } = await response.json();
console.log(data.data);

Direct import (Node / Bun / Deno)

import { csvToJson } from '@aerostack/functions/data-csv-to-json';

const { data, headers } = csvToJson({ csv: myCsvString });

---

Use Cases

• Converting spreadsheet exports to JSON before inserting into a database
• Processing CSV data from third-party integrations (analytics exports, CRM dumps)
• Feeding CSV data into an AI workflow that expects typed JSON

---

Notes

• Type inference applies to the trimmed value — " 30 " becomes 30 (number)
• Set inferTypes: false to keep all values as strings
• First row is always treated as the header row