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.