Function parseCsvBuffer

apps/sim/lib/table/import.ts:99–128

(
  input: Buffer | Uint8Array | string,
  delimiter = ','
)

 * For HTTP uploads prefer {@link createCsvParser} so the file isn't buffered.
 */
export async function parseCsvBuffer(
  input: Buffer | Uint8Array | string,
  delimiter = ','
): Promise<{ headers: string[]; rows: Record<string, unknown>[] }> {
  const { parse } = await import('csv-parse/sync')

  let text: string
  if (typeof input === 'string') {
    text = input
  } else if (typeof Buffer !== 'undefined' && Buffer.isBuffer(input)) {
    text = input.toString('utf-8')
  } else {
    text = new TextDecoder('utf-8').decode(input as Uint8Array)
  }

  // double-cast-allowed: shared csvParseOptions() loses the `columns: true` literal that drives
  // csv-parse's record-vs-string[][] overload, but `columns: true` is always set so records are objects
  const parsed = parse(text, csvParseOptions(delimiter)) as unknown as Record<string, unknown>[]

  if (parsed.length === 0) {
    throw new Error('CSV file has no data rows')
  }

  const headers = Object.keys(parsed[0])
  if (headers.length === 0) {
    throw new Error('CSV file has no headers')
  }

  return { headers, rows: parsed }
}

/**
 * Infers a column type from a sample of non-empty values. Order matters: we