Load data from an online csv file

[fauguste]

Is it possible to load data from csv files found on a website without downloading the csv files? It's an https website, not an FTP.

[Lisa_P]

Loading files from web resources

You can load files from web resources, such as FTP, HTTP or HTTPS, with a web file data connection. The file can be of any type supported by Qlik Sense. You need to make the following settings to the data connection.

Note:This functionality is not available in Kubernetes.

Settings for a web file data connection

UI item	Description
URL	Full URL to the web file you want to connect to, including the protocol identifier. Example: http://unstats.un.org/unsd/demographic/products/socind/Dec.%202012/1a.xls If you connect to an FTP file you may need to use special characters, for example : or @, in the user name and password part of the URL. In this case you need to replace special characters with a percent character and the ASCII hexadecimal code of the character. For example, you should replace : with '%3a', and @ with '%40'.
Name	Name of the data connection.

[fauguste]

I've established the web file connection, but I'm being told that "No table found in the HTML file".  I have multiple csv files on the website-see picture below.Is it because it's not an FTP website?

I've tried  the following (edited) URL to select that specific csv: https://iss............./pzrfchr_pebempl.csv    and I've tried https://iss.........edu:8443/#/  which is the URL for that whole page. I've tried other websites and it works when there are actual tables on the website and not csv files.

[ken4runner]

having the same problem, and havent found this documented anywhere yet.

[stevedark · Accepted solution]

Hi,

The ability to load directly from a CSV has been hampered by a security measure, designed to protect against injection of code into Sense.

This article may provide some useful insights into how you can get to your CSV files:
https://www.quickintelligence.co.uk/load-online-csv-into-qlik/

This may or may not work for you, based on what authentication is required and how the files are presented by the web server.

Hope it helps.

Steve

[Ayayo]

I am also having the same problem, Here is an alternative, just used this converter to convert CSV file or CSV URL into Qlik table format. hope it can help you.

https://tableconvert.com/csv-to-qlik

[Ken_T]

there is no web file connection right now in QLIK SAAS or QLIK CLOUD GOVERNMENT.... any suggestions for this on SaaS and QCG?