FTP/SFTP Web connector

[BI_Dev]

Is there a way to specify date variable (today's date) while downloading files from SFTP ?

I have the SFTP connector setup, but SFTP has so many files with date stamps...only want to download file with today's date stamp in it.

Thank you much.

[J_Lindberg]

Hello @BI_Dev ,

I'm not sure if this question is related to the product Qlik Application Automation, but if it is, then you could use the block "List Files on SFTP" and include a condition block to see if the file name contains the current date. 

[Sonja_Bauernfeind]

Hello, @p_verkooijen and @BI_Dev I have moved this over to the Connectivity and Data Prep forum for the time being, but will ask our moderators if we intend to open a WebConnector-specific forum.

All the best,
Sonja 

[p_verkooijen]

@BI_Dev  use (S)FTPListFilesAndFolders, determine the file you want to download.
Then use FTPDownload to download this file

You could also use wildcards in the FTPDownload to determine the possible files to download.

See https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Data-So...

[BI_Dev]

Thank you @p_verkooijen ...wondeing if we can use date function like date'(today())'as the file changes daily with regards to date.

[p_verkooijen]

@BI_Dev  no, you need to use FTPListFilesAndFolders to see what files are available and filter the response to the relevant files to be downloaded using FTPDownload.