FTP / SFTP / FTPS Path

Use this path to retrieve the file from an FTP server (FTP, SFTP or FTPS). The parameters required to configure this path are the URL and credentials of the server.

The credentials of the server can be a login/password or a login and an SSH private key (the SSH key can be password protected).

By default, the data sources use Binary transfer mode. To change it to ASCCI transfer mode, add ;type=A to the URL.

Examples:

  • Example of a URL to an FTP server:

    ftp://ftp.example.com/pub/employee.csv.

  • Example of a URL to an SFTP server:

    sftp://example.com//home/joe/employee.csv (note the two slashes after the host name)

  • Example of a URL to an FTP server with ASCII transfer mode enabled:

    ftp://example.com//pub/employee.csv;type=A

  • Example of a URL to an FTP server with ASCII transfer mode enabled retrieving all the files located at pub folder:

    ftp://example.com//pub/;type=A