SFTP - Download Files to Workflows

Overview

Quickly export one or more files from an SFTP Server. The match type selected greatly affects how this Blueprint works.

This Blueprint requires read permissions in order to download from the SFTP server.

Variables

Name	Reference	Type	Required	Default	Options	Description
Host	SFTP_HOST	Alphanumeric	✅	None	-	Domain or IP address of the SFTP server to connect to.
Port	SFTP_PORT	Integer	✅	22	-	Number for the port to connect to. `22` is used by default.
Username	SFTP_USERNAME	Alphanumeric	➖	None	-	Value of the configured username in the SFTP server.
Password	SFTP_PASSWORD	Password	➖	None	-	Value of the configured password associated to the username on the SFTP server.
RSA Key File	SFTP_RSA_KEY_FILE	Alphanumeric	➖	None	-	The file name of an RSA key you would like to use for authentication. Typically downloaded to Workflows in a previous step.
SFTP File Name Match Type	SFTP_SOURCE_FILE_NAME_MATCH_TYPE	Select	✅	exact_match	Exact Match: exact_match Regex Match: regex_match	Determines if the text in "SFTP File Name" will look for one file with exact match, or multiple files using regex.
SFTP Folder Name	SFTP_SOURCE_FOLDER_NAME	Alphanumeric	➖	None	-	Name of the folder where the file is stored in the SFTP server. Leaving blank will default to the root directory.
SFTP File Name	SFTP_SOURCE_FILE_NAME	Alphanumeric	✅	None	-	Name of the target file in the SFTP server. Can be regex if "Match Type" is set accordingly.
Workflows Folder Name	SFTP_DESTINATION_FOLDER_NAME	Alphanumeric	➖	None	-	Folder where the file(s) should be downloaded. Name of the folder where the file is stored in the SFTP server. Leaving blank will default to the root directory.
Workflows File Name	SFTP_DESTINATION_FILE_NAME	Alphanumeric	➖	None	-	What to name the file(s) being downloaded. If left blank, defaults to the original file name(s).

YAML

Below is the YAML template

YAML


source:
  template: SFTP - Download Files to Workflows
  inputs:
    SFTP_HOST:
    SFTP_PORT: '22'
    SFTP_USERNAME:
    SFTP_PASSWORD:
    SFTP_RSA_KEY_FILE:
    SFTP_SOURCE_FILE_NAME_MATCH_TYPE: exact_match
    SFTP_SOURCE_FOLDER_NAME:
    SFTP_SOURCE_FILE_NAME:
    SFTP_DESTINATION_FOLDER_NAME:
    SFTP_DESTINATION_FILE_NAME:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 200
    - 202
    - 206
    - 207
    - 210