Output node
JSON File
Write rows as an array or newline-delimited JSON.
What it does
Writes the incoming rows as JSON: either one array document holding every row, or newline-delimited JSON with one object per line. Each row becomes an object whose keys are your column names. Empty cells are left out of the object entirely rather than written as null, which is the one behavior that tends to surprise people downstream.
Inputs and outputs
| Inputs | One. |
| Outputs | None. This node ends a pipeline. |
When to use it
- Export a result for an API or a JSON-consuming tool
- Produce NDJSON for a streaming or log pipeline that reads a record at a time
- Hand a structured extract to a developer
Examples
Array document
Format: array → [ {"id":1, …}, {"id":2, …} ]One valid JSON file, but the reader has to parse the whole thing at once.
NDJSON
Format: lines → one object per line
Readable a record at a time, and easy to append to.
Empty result
no rows in → []
Array format still writes a valid, empty document rather than nothing at all.
Tips
- Find the file on the run's detail page once the run finishes.
- A Test run leaves you nothing to download; press Run for a real file.
- A null cell is OMITTED from its object rather than written as null. If the other side counts on every key being present, fill the gaps upstream with Fill Missing.
- Choose lines (NDJSON) when the file is large or the reader takes a record at a time; choose array when something has to parse the file whole.
- Column names become the object keys exactly as they are spelled, capitals included.