Output · Files

Write JSON

Saves the table as a JSON file: one array of objects, or one object per line.

Also known as: JSON Lines

How it works

Type the JSON file name (output.json by default) and pick a Location; blank means the project folder. Format is JSON array by default, one array with one object per row; NDJSON writes one object per line, which streams well into other tools. The write fails if the file already exists unless you tick Overwrite if the file already exists. Write formatted values writes values as they print upstream, which turns formatted numbers into strings. The written file is passed on downstream as a File.

Inputs and outputs

Settings

{
  fileName: string
  directory?: string
  format: "array"|"ndjson"
  overwrite?: boolean
  formatValues?: boolean
}

Example

A web app needs the latest product list. Set the JSON file to products.json, keep JSON array, tick Overwrite if the file already exists so each run refreshes it, and send the file on with S3 Sink.

More in Files

• Write CSV — Saves the table as a CSV file. It can create a new file, replace one (keeping a backup) or append to it; the delimiter, header and quoting are up to you.
• Write Excel — Writes one or more tables into named sheets of an Excel workbook. It can add to an existing workbook and keep its other sheets.
• Write Parquet — Saves the table as a compressed Parquet file that reloads fast here, in DuckDB, pandas or Spark. Good for large in-between results.
• Write XML — Saves the table as an XML file with one element per row. Both element names are up to you.
• Write HTML — Saves the table as a plain HTML page with one table and an optional title. For a styled report, use Write Report.
• Write Geo File — Saves a table with geometry as GeoJSON, GeoPackage, Shapefile or GeoParquet, ready to open in QGIS or ArcGIS. GeoParquet takes lon/lat data only.
• Write Locra Table — Saves the table with its column formats into one .ddtable file, so a colleague can pick it up in another project and see it printed the same way.