topic Re: SFTPDownload Qlik Web Connectors path format error in Connectivity & Data Prep

SFTPDownload Qlik Web Connectors path format error

George_HRB — Tue, 16 May 2023 15:08:45 GMT

Hello, I am using SFTPDownload from QlikWebConnectors version 1.1.15.28825 on Qlik Sense April 2020 qliksenseserver 13.72.3.

I am able to connect to an external SFTP location using an SFTP client, so I know the credentials are ok.

The Remote path is simply "/" as my raw data files, which I would like to do a wildcard load on, are "/NAME*.csv".

My Target directory is local to the Qlik Sense server, ie. "lib://FOLDER".

Whenever I "Save Inputs & Run Table" I get "Unsupported path format. Parameter name: path" with no returned FileCount.

I've tried everything within the support site on these error codes but can't seem to be able to resolve this issue and download the data files.

Can you please help? Thank you!

Re: SFTPDownload Qlik Web Connectors path format error

EdgarOlmos — Wed, 24 May 2023 00:33:43 GMT

Hi.

In Qlikwebconnectors settings is a parameter that you need to move to access the folder in the servers.

Regards

Re: SFTPDownload Qlik Web Connectors path format error

Roza — Wed, 24 May 2023 07:28:56 GMT

hi @George_HRB,

"lib://FOLDER" is not a valid value as it's a Sense connection name. you need to set the actual folder path, like "c:\MyFolder" and as @EdgarOlmos mentioned, please ensure that Qlik Web Connectors has access to the folder (see Allow file system access for specified paths)

Re: SFTPDownload Qlik Web Connectors path format error

George_HRB — Wed, 24 May 2023 17:30:41 GMT

Thank you Edgar- I confirm that this was already set up as you indicated in the deploy file...

Re: SFTPDownload Qlik Web Connectors path format error

George_HRB — Wed, 24 May 2023 17:32:53 GMT

Hello Roza,

Thank you very much for your input- you were correct! I updated the folder path to the local one in its place, and this corrected the issue- I was able to access the files.

Thanks very much for your help!

George