topic SaveToFile using Qlik Web Connector in Connectivity & Data Prep

SaveToFile using Qlik Web Connector

colinh — Thu, 17 Oct 2019 05:34:29 GMT

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-9d31-c4c9bd8b5bc2/download/privatehealth-01-oct-2019.zip" 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

Re: SaveToFile using Qlik Web Connector

vunguyenq89 — Fri, 18 Oct 2019 18:55:19 GMT

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.

Re: SaveToFile using Qlik Web Connector

colinh — Mon, 21 Oct 2019 00:12:09 GMT

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.

Re: SaveToFile using Qlik Web Connector

vunguyenq89 — Mon, 21 Oct 2019 09:40:09 GMT

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

Re: SaveToFile using Qlik Web Connector

colinh — Tue, 22 Oct 2019 03:51:57 GMT

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.

Re: SaveToFile using Qlik Web Connector

vunguyenq89 — Tue, 22 Oct 2019 09:30:15 GMT

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

Re: SaveToFile using Qlik Web Connector

colinh — Tue, 22 Oct 2019 10:30:42 GMT

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