Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

SaveToFile using Qlik Web Connector

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

2 Solutions

Accepted Solutions
vunguyenq89
Contributor II

Re: SaveToFile using Qlik Web Connector

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.

View solution in original post

vunguyenq89
Contributor II

Re: SaveToFile using Qlik Web Connector

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 

View solution in original post

6 Replies
vunguyenq89
Contributor II

Re: SaveToFile using Qlik Web Connector

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.

View solution in original post

Partner
Partner

Re: SaveToFile using Qlik Web Connector

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
Contributor II

Re: SaveToFile using Qlik Web Connector

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

Partner
Partner

Re: SaveToFile using Qlik Web Connector

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
Contributor II

Re: SaveToFile using Qlik Web Connector

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 

View solution in original post

Partner
Partner

Re: SaveToFile using Qlik Web Connector

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