check file in FTP

[stefano_marson]

Hello everybody,

in QlikSense, I would need to test the possible presence of a .csv file, within an FTP site, before uploading it.
I was thinking of using the filesize() function as I have done in the past with QlikView.
But it doesn't work: the variable vFileExists  always returns 0 even if the file exists.

This what I wrote:

LET vFileExists = not isNull(filesize('ftp://sense:Yu7..P4nW6L4@ftpecomm.dmospa.local/daElaborare/SENSE2023.csv'));

Maybe I'm doing the syntax wrong?

Thanks in advance

stefano

[marcus_sommer]

FTP doesn't support the usual file-functions. You will need specialized ftp-functions maybe you could evaluate the return of ftp mdir or as an alternatively you transfers the files in beforehand to a local drive with mget or similar functions. Here a starting point: ftp mdir | Microsoft Learn