Skip to content

SFTP Read ​

Read a file from an SFTP server with optional CSV / TSV / JSON / JSON Lines / XML parsing.

Requires an SFTP connection.

Configuration ​

FieldDescriptionNotes
SFTP ConnectionThe SFTP connection to useRequired. Select from your configured SFTP connections.
File PathPath to the file on the SFTP serverRequired. Supports templates. Example: /exports/report.csv
Parse FormatHow to parse the downloaded bodyraw (default), json, jsonl, csv, tsv, or xml

Input ​

The node accepts an optional file_path input. If the File Path field is left empty, the node extracts a path from upstream data (looking for file_path, path, or file fields).

Output ​

Returns {path, filename, size, content_type, modified_at, parse_format, content} where:

FieldDescription
pathThe full path that was read
filenameThe filename portion of path
sizeFile size in bytes
content_typeMIME type (best-effort; may be empty for SFTP)
modified_atLast-modified timestamp
parse_formatEchoes the parse_format setting
contentParsed body — string for raw, []map[string]any for csv/tsv/jsonl, map/[]any for json/xml

Streaming ​

Per-item fan-out: when wired downstream of an SFTP List Files node, SFTP Read processes one file per upstream item using {{ item.path }} (or whatever template you set for File Path).

TIP

The multi-file selection (single / multiple / latest with pattern matching) and built-in gzip decompression that earlier versions of this node supported have been removed. If you need to read several files, do SFTP List Files + SFTP Read with per-item fan-out. For compressed bodies, run the bytes through a downstream gzip-decode step.