Prerequisites: SFTP server credentials and outbound network access. Familiarity with Cron Schedule and Transform.
Build an SFTP integration workflow from template #105: download CSV files hourly, transform data, and upload results to a processed folder.
What this template does
- Hourly Schedule — cron trigger (
0 * * * *). - Download from SFTP — reads
/data/incoming/*.csv. - Process Data — transform node.
- Upload to SFTP — writes
/data/processed/result.json.
Step 1 — Load the template
- Studio → Templates → search
SFTP File Transfer. - Load template #105.
Step 2 — SFTP credentials
- Set host, port, username, and password (or key) on both SFTP nodes.
- Store secrets in
{{$var.sftpPassword}}via Global Variables.
Step 3 — Transform logic
- Edit the Process Data expression to map CSV columns to your JSON schema.
- Run Dry Run with a sample file payload if SFTP is unavailable in test.
Step 4 — Schedule and monitor
- Adjust cron for your batch window.
- Review Jobs → History for failed transfers.
Related tutorials
- File Drop Automation — local folder watch pattern.
- Schedule a Nightly Job — cron basics.