SaveToFile using Qlik Web Connector

[colinh]

Hi

I'm trying to use the Qlik General Web Connector (May 2019) to download a file from a URL.  This worked using an older version of the connector, but I can't get the May 2019 version to work.  The connector is running as a service and is licenced.

I've selected the Request Method (GET), entered the Request URI, checked the "Is File" checkbox and entered the File Name.  I've added the folder that is in the File Name to deploy.config.  When I click on "Save Inputs and Run Table", the connector displays "Running... Making request to https://data.gov.au/data/dataset/8ab10b1f-6eac-423c-abc5-bbffc31b216c/resource/8d06d260-5b08-4d20-9d..." which is the file I am trying to download.  From there nothing else happens, it just hangs on that message until I cancel.  If I paste the URL into the browser the file is downloaded.

This does work with an older version of the connector, but that doesn't give the required script for Standard Mode.

Any suggestions?

Thanks

[vunguyenq89 · Accepted solution]

It's a known bug in Qlik Web Connector version May 2019 in service mode. Check articles https://support.qlik.com/articles/000082262 and https://support.qlik.com/articles/000085752 for work-around solution.

[colinh]

Thanks, adding <FileSystemAccessAllowedPaths>*</FileSystemAccessAllowedPaths> to deploy.config resolved the issue from the connector page.  I had put in the full folder path previously, that doesn't work but the * does.

So now I've copied the script from the Qlik Sense (Standard Mode) sheet into an app and reloaded it.  I now get the error "No qualified path for file: ***".  I've created the web connector as a variable and followed all the rest of the instructions.  When I paste the URL into a browser the file downloads, but it won't download when I run the script.

I'm not sure which file needs to be qualified, the URL or the destination path, and how I would need to change it.

[vunguyenq89]

Can you show screenshot of the error message when reloading, or part of the script log where the error is reported?

[colinh]

Below is the full log file output.  I'm also attaching a PDF documenting the full process I've followed, with a screenshot of the error message.  Thanks!

2019-10-22 03:31:30      Execution started.

2019-10-22 03:31:30      Qlik Sense Server Version     12.421.3

2019-10-22 03:31:30      CPU Target     x64

2019-10-22 03:31:30      Operating System     Windows Server 2012 R2 Standard  (64 bit edition)

2019-10-22 03:31:30      Wow64 mode     Not using Wow64

2019-10-22 03:31:30      Language     0409 English English

2019-10-22 03:31:30      Country     USA United States United States

2019-10-22 03:31:30      MDAC Version     6.3.9600.16384

2019-10-22 03:31:30      MDAC Full Install Version     6.3.9600.16384

2019-10-22 03:31:30      PreferredCompression     2

2019-10-22 03:31:30      EnableParallelReload     1

2019-10-22 03:31:30      ParallelizeQvdLoads     1

2019-10-22 03:31:30      AutoSaveAfterReload     0

2019-10-22 03:31:30      BackupBeforeReload     0

2019-10-22 03:31:30      EnableFlushLog     0

2019-10-22 03:31:30      UserLogfileCharset     65001

2019-10-22 03:31:30      OdbcLoginTimeout     -1

2019-10-22 03:31:30      OdbcConnectionTimeout     -1

2019-10-22 03:31:30      LongestPossibleLine     1048576

2019-10-22 03:31:30      MaxCoreMask     -1

2019-10-22 03:31:30      WebFileTimeout     0

2019-10-22 03:31:30      WebFileUserAgent     Mozilla/5.0

2019-10-22 03:31:30      DontUseInternetCache     1

2019-10-22 03:31:30      ScriptWantsDbWrite     false

2019-10-22 03:31:30      ScriptWantsExe     false

2019-10-22 03:31:30      ICU_FOR_CHARACTER_CLASSIFICATION true

2019-10-22 03:31:30      ICU_FOR_CODE_PAGES     true

2019-10-22 03:31:30      ICU_FOR_COLLATION     true

2019-10-22 03:31:30      ICU_FOR_LOCALE_INFO     true

2019-10-22 03:31:30      ICU_FOR_SUPPORT_INFO     true

2019-10-22 03:31:30      ICU_FOR_TIME_ZONE_INFO     true

2019-10-22 03:31:30      LogFile CodePage Used:     65001

2019-10-22 03:31:30      UseMemoryFillPattern     1

2019-10-22 03:31:30      ScriptMode     Standard (limits system access)

2019-10-22 03:31:30      SequentialThreadCount     20

2019-10-22 03:31:30      NumberOfCores (effective)     6

2019-10-22 03:31:30      ReloadCodebase     Bnf

2019-10-22 03:31:31      Reload ID     2e32f7a5-7adf-4cfb-842f-3ecd26402049

2019-10-22 03:31:31      Reload Executed By     UserDirectory=INTERNAL; UserId=sa_scheduler

2019-10-22 03:31:31      Process Executing     Qlik Sense Server

2019-10-22 03:31:31      Process ID     5308

2019-10-22 03:31:31      Grpc version     7.0.0

2019-10-22 03:31:31      Protobuf version     3.6.1

2019-10-22 03:31:31 0002 SET ThousandSep=','

2019-10-22 03:31:31 0003 SET DecimalSep='.'

2019-10-22 03:31:31 0004 SET MoneyThousandSep=','

2019-10-22 03:31:31 0005 SET MoneyDecimalSep='.'

2019-10-22 03:31:31 0006 SET MoneyFormat='$#,##0.00;-$#,##0.00'

2019-10-22 03:31:31 0007 SET TimeFormat='h:mm:ss TT'

2019-10-22 03:31:31 0008 SET DateFormat='M/D/YYYY'

2019-10-22 03:31:31 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

2019-10-22 03:31:31 0010 SET FirstWeekDay=6

2019-10-22 03:31:31 0011 SET BrokenWeeks=1

2019-10-22 03:31:31 0012 SET ReferenceDay=0

2019-10-22 03:31:31 0013 SET FirstMonthOfYear=1

2019-10-22 03:31:31 0014 SET CollationLocale='en-US'

2019-10-22 03:31:31 0015 SET CreateSearchIndexOnReload=1

2019-10-22 03:31:31 0016 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

2019-10-22 03:31:31 0017 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'

2019-10-22 03:31:31 0018 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

2019-10-22 03:31:31 0019 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'

2019-10-22 03:31:31 0020 SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y'

2019-10-22 03:31:31 0022 let vQwcConnectionName = 'Qlik Web Connector (insightsense_colin)'

2019-10-22 03:31:31 0024 WebConnector_SaveToDisk:

2019-10-22 03:31:31 0025 LOAD

2019-10-22 03:31:31 0026     status as SaveToDisk_status,

2019-10-22 03:31:31 0027     action as SaveToDisk_action

2019-10-22 03:31:31 0028 FROM [Qlik Web Connector (insightsense_colin)]

2019-10-22 03:31:31 0029 (URL IS [http://localhost:5555/data?connectorID=WebConnector&table=SaveToDisk&url=https%3a%2f%2fdata.gov.au%2fdata%2fdataset%2f8ab10b1f-6eac-423c-abc5-bbffc31b216c%2fresource%2f8d06d260-5b08-4d20-9d31-c4c9bd8b5bc2%2fdownload%2fprivatehealth-01-oct-2019.zip&isFile=True&fileName=C%3a%5cQlik+Data%5cPrivateHealth%5cprivatehealth-01-oct-2019.zip&overwriteIfFileExists=True&appID=], qvx)

2019-10-22 03:31:31      Error: No qualified path for file: Qlik Web Connector (insightsense_colin)

2019-10-22 03:31:31      Execution Failed

2019-10-22 03:31:31      Execution finished.

[vunguyenq89 · Accepted solution]

According to the script log, issue seems to be here:

FROM [Qlik Web Connector (insightsense_colin)]

 You missed the lib:// prefix before the webfile connection name. Add this prefix to the variable definition:

let vQwcConnectionName = 'lib://Qlik Web Connector(insightsense_colin)'

BR,

Vu Nguyen 

[colinh]

Doh!  You're right, I missed that out.  Simple solution in the end, thank you!