
Overview
The FTP and SFTP sources let you retrieve data files from remote file servers. This is useful for scheduled feeds from partners, legacy systems, or any infrastructure that publishes data via FTP/SFTP.FTP Configuration
Required Fields
Optional Fields
SFTP Configuration
Required Fields
Authentication
SFTP supports two authentication methods:- Password
- Private Key
Authenticate using a username and password.
Supported File Formats
FTP/SFTP automatically detects the file format. The following formats are supported:Compressed files (
.gz, .zip) are automatically decompressed before parsing.PGP Decryption
FTP and SFTP sources support fetching PGP-encrypted files. WhenpgpPrivateKey is configured, files are decrypted transparently before decompression and parsing.
Both armored (
.asc) and binary (.pgp, .gpg) encrypted files are supported.
See the PGP Decryption guide for details on key generation, supported formats, and error handling.
Wildcard Paths
You can use a wildcard (*) in the file name to match multiple files. This is useful when:
- A new file is exported periodically with a different name (e.g.
/exports/products_20240101.csv,/exports/products_20240102.csv) - Data is split across multiple files in the same directory
/exports/products_*.csv— matches all CSV files starting withproducts_in the/exports/directory/data/*.json— matches all JSON files in the/data/directory
File Processing Modes
When using wildcard paths, you can configure how files are selected via theprocessType field:
Reelevant-Hosted SFTP
For datasources configured via the platform, Reelevant can also provide an SFTP endpoint where your systems can push files directly. This is useful when:- Your infrastructure prefers to push data rather than have it pulled
- You want to update data files without accessing the Reelevant platform
How It Works
- Reelevant connects to the FTP/SFTP server using the provided credentials.
- The file at the configured path is located. If a wildcard is used, matching files are listed.
- Files are downloaded, decompressed if needed, and parsed based on the detected format.
- Fields are extracted and made available for mapping.
- On subsequent syncs, files are re-fetched according to the configured processing mode.