File Transfer (SFTP)
The File Transfer nodes allow you to work with files on remote SFTP servers. You can read, write, list, rename, and delete files -- all through a secure SSH connection.
Every File Transfer node requires an SFTP connection.
Available Nodes
| Node | Description |
|---|---|
| SFTP Stream Read | Read and parse structured data files (CSV, JSON, XML, etc.) from an SFTP server |
| SFTP Stream Write | Write data items to a file on an SFTP server in a structured format |
| SFTP List Files | List files and directories with metadata (name, size, modified date) |
| SFTP Delete | Delete a file from an SFTP server |
| SFTP Rename / Move | Rename or move a file on an SFTP server |
Common Patterns
Read, Process, Archive
A typical file processing workflow:
- SFTP List Files to find new files matching a pattern
- SFTP Stream Read to parse each file into data items
- Process the data (transform, filter, load into a database, etc.)
- SFTP Rename / Move to move processed files to an archive directory
- SFTP Delete to clean up temporary files if needed
Write and Compress
- Collect data from upstream nodes
- SFTP Stream Write with GZIP compression enabled to write a compressed file
- Use the output file path in downstream notifications
TIP
All file path fields support templates, so you can build dynamic paths using data from upstream nodes -- for example, including dates or IDs in filenames.
WARNING
Path traversal (e.g., ../../etc/passwd) is automatically blocked. All paths are validated to stay within the SFTP connection's configured root directory.