RenderDelimitedText@1
Node RenderDelimitedText@1 renders an array of records into one delimited-text document for fixed layouts: one row per record, one column per configured entry. A column is a constant, a value read from the record, or empty (a reserved field).
The node writes no quoting, on purpose: fixed-layout formats usually have no escaping convention, so quotes would reach the receiver as payload. For real CSV with quoting, a header and per-column formatting use ConvertToCsv@1.
Adapter Prerequisites
Node Configuration
For fields path, targetPath, targetValueWriteMode, and targetValueKind, see Overview. path selects the source array; every element must be an object.
transformations:
- type: RenderDelimitedText@1
path: $.rows
targetPath: $.text
delimiter: "|"
lineEnding: Lf
columns:
- value: "H" # constant
- valuePath: $.id # value of the record
required: true
- {} # empty, reserved field
- valuePath: $.name
| Property | Type | Required | Default | Description |
|---|---|---|---|---|
path | string | Yes | - | JSON path of the source array |
targetPath | string | Yes | - | Path where the document is written as one string |
delimiter | string | No | | | Exactly one character between columns; not a line break |
lineEnding | enum | No | Lf | Lf or CrLf; never taken from the operating system |
trailingNewLine | bool | No | true | A line end after the last row |
onDelimiterInValue | enum | No | Fail | What happens to a value that contains the delimiter, CR or LF: Fail, Replace or Strip |
replacement | string | No | empty | Substitute used by Replace; must not contain the delimiter or a line break |
columns | array | Yes | - | Output columns in order: value (constant), valuePath (relative, single-valued) or neither (empty), required |
Behavior
- A number is written as its raw JSON token (
0.00stays0.00), a boolean asTrueorFalse, an absent or null value as an empty cell. An object or array at avaluePathis refused. - A value with the delimiter, CR or LF is refused (
Fail) or rewritten with a warning (Replace,Strip); it is never passed through, because it would shift every following column. requiredfails the node when the rendered value of that column is empty.- An empty array writes an empty string; the write is never skipped. A
paththat is not an array, or a record that is not an object, fails the node.
The configuration properties are documented in the API reference.