Connectors
FTP / SFTP Input
Reads the files in a folder of an FTP, FTPS or SFTP server — merged into rows, or as one row per downloaded file.
When to use it
Use it for vendor drops delivered by FTP or SFTP.
In a pipeline
FTP / SFTP InputType ConversionExport Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Remote folder | text | — | /outbox (blank: the start folder) |
| File name pattern | text | — | * |
| Hand on | select | — | rows |
Example
Vendor price file
- Remote folder=/outbox
- File name pattern=prices*.csv
| SKU | Price |
|---|---|
| T-100 | 4.5 |
| C-200 | 7.2 |
Worth knowing
- Write sftp:// before the host (or use port 22) for SFTP, ftps:// for FTP over TLS; plain FTP otherwise.
- A relative Remote folder starts from the connection's Start folder.
- Only files directly in the folder are read (not sub-folders).