Skip to content

export.ExportMain.Interface.ExportFormatTypeJsonlOptions

Christian d'Heureuse edited this page Nov 16, 2026 · 1 revision

tedious-plus / export/ExportMain / ExportFormatTypeJsonlOptions

Interface: ExportFormatTypeJsonlOptions

Defined in: export/ExportMain.ts:54

Options for the JSON Lines format (JSONL), with one JSON value per line.

The column values are converted as follows:

SQL data type JSON value
NULL null
bit true or false
Numeric types, except bigint Number, e.g. 123.45
bigint Object, e.g. {"$bigint": "9007199254740993"}
String types, uniqueidentifier, xml String
date String, e.g. "2026-11-16"
time String, e.g. "12:34:56.789"
datetime, smalldatetime, datetime2, datetimeoffset String in UTC, e.g. "2026-11-16T12:34:56.789Z"
Binary types, rowversion String with hex digits, e.g. "0102abff"

Time values have a precision of milliseconds. decimal and numeric values are converted to JavaScript numbers by Tedious and may therefore lose precision.

Properties

rowShape?

rowShape?: "object" | "array";

Defined in: export/ExportMain.ts:71

The shape of the rows.

  • "object": Each row is written as a JSON object, e.g. {"id": 1, "name": "abc"}. The column names must be unique.
  • "array": Each row is written as a JSON array, e.g. [1, "abc"]. The first line contains the column names, e.g. ["id", "name"].

Default Value

"object"

type

type: "jsonl";

Defined in: export/ExportMain.ts:59

The format type.

Clone this wiki locally