FTP.DOWNLOAD

Download a file from a FTP server as a BinaryStream object. (Introduced from Perfion 2023-R1)

Properties

From

Name of the Input Data Source. The input-source must contain a file-path. Remark: Some FTP-server require the file-path start with a forward slash (/).

To

Name of the Output Data Source.
The output-source will always be a BinaryStream object.

Parameters

@FTP

The FTP connection. The syntax for the FTP connection:

FtpHost=<server name or ip>;FtpPort=<portnumber>;username=<username on server>; password=<password in plaintext>

FtpHost is mandatory and to specify FTP protocol use ftp, sftp or ftps as scheme like ftps://test.com. A FtpHost without a scheme is defaulted to ftp://

Lookup from a named Connection defined in Perfion Go to Administration -> Remote Queries and open a query to see available Remote Connection names:
@REMOTECONNECTIONNAME=FtpServer

Example

Below example will download the specified file /FileName.xls from the FTP server specified in the Administration → Remote Connections.

Â