topic Re: FTP/SFTP Web connector in Qlik Automate

FTP/SFTP Web connector

BI_Dev — Wed, 08 Feb 2023 19:36:52 GMT

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.

Re: FTP/SFTP Web connector

J_Lindberg — Mon, 13 Feb 2023 13:59:12 GMT

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.

Re: FTP/SFTP Web connector

Sonja_Bauernfeind — Tue, 21 Feb 2023 15:28:49 GMT

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

Re: FTP/SFTP Web connector

p_verkooijen — Tue, 21 Feb 2023 15:46:53 GMT

@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-Source-Connectors/FTP-Connector.htm?_ga=2.23584956.766653115.1676980938-1949108102.1676980938

Re: FTP/SFTP Web connector

BI_Dev — Thu, 02 Mar 2023 19:24:28 GMT

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

Re: FTP/SFTP Web connector

p_verkooijen — Tue, 07 Mar 2023 15:33:23 GMT

@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.