Skip to main content

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
PropertyTypeRequiredDefaultDescription
pathstringYes-JSON path of the source array
targetPathstringYes-Path where the document is written as one string
delimiterstringNo|Exactly one character between columns; not a line break
lineEndingenumNoLfLf or CrLf; never taken from the operating system
trailingNewLineboolNotrueA line end after the last row
onDelimiterInValueenumNoFailWhat happens to a value that contains the delimiter, CR or LF: Fail, Replace or Strip
replacementstringNoemptySubstitute used by Replace; must not contain the delimiter or a line break
columnsarrayYes-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.00 stays 0.00), a boolean as True or False, an absent or null value as an empty cell. An object or array at a valuePath is 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.
  • required fails the node when the rendered value of that column is empty.
  • An empty array writes an empty string; the write is never skipped. A path that is not an array, or a record that is not an object, fails the node.

The configuration properties are documented in the API reference.