Output
Export JSON
Writes the incoming rows to a .json file in a folder you choose and passes the rows on unchanged.
When to use it
Use it when the result feeds an API, a script or an application that expects JSON rather than a spreadsheet.
In a pipeline
REST APISelect ColumnsExport JSON
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| File Name (without extension) | text | Yes | export |
| Output Directory | text | Yes | Server folder, e.g. exports (inside your workspace or an allowed folder) |
Example
Save API results as JSON
- File Name (without extension)=orders
- Output Directory=exports
| id | customer | total |
|---|---|---|
| 5001 | Acme Ltd | 240 |
| 5002 | Borne SA | 95 |
| id | customer | total |
|---|---|---|
| 5001 | Acme Ltd | 240 |
| 5002 | Borne SA | 95 |
The file holds one array of objects, one object per row, indented with two spaces.
Worth knowing
- Every row gets the same set of keys, with missing values written as null.
- Columns whose names start with two underscores are internal and are left out.
- The rows carry on downstream, so you can write JSON and a database table from the same branch.