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.