How to connect with web file (SaaS and Client Managed)

[Dlopeze]

Hi to everyone,

I would like to connect to a web file, but unfortunately, it seems I'm making a mistake during the connection. This is my code:

LOAD * FROM [lib://data]
(url is [https://raw.githubusercontent.com/civio/covid-vaccination-spain/main/data.csv], html, utf8, embedded labels, table is @1);

Thank you in advance.

Daniel

[Sebastian_Linser · Accepted solution]

Hello @Dlopeze 

when i create a connection to webfile, with the URL specified in the text above

Then you can get the data e.g. like this:

Load * From [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);

or if you want not to load all but only specific elements

LOAD
 informe,
 "comunidad autónoma",
 "dosis Pfizer",
 "dosis Moderna",
 "dosis AstraZeneca",
 "dosis Janssen",
 "dosis entregadas",
 "dosis administradas",
 "% sobre entregadas",
 "personas con al menos una dosis",
 "personas con pauta completa",
 "personas con dosis adicionales",
 "última vacuna registrada"
FROM [lib://csv1]
(txt, utf8, embedded labels, delimiter is ',', msq);

just delete the lines which you don't want. For the moment both queries will retrieve 4663 lines with your web file.

best regards

Sebastian

[Dlopeze · Accepted solution]

Thank you for your reply Sebastian,

Unfortunately, the button about "select a web file" is not avaliable now in Qlik cloud. I found another way to get data using google Drive connector:

https://www.vizmind.eu/connecting-to-web-files-in-saas-editions-of-qlik-sense/

 Best regards,

Daniel

[Ken_T]

this post really needs a reply from Qlik ---- 
what are the possible ways to do a webfile / web file connection in SAAS/ Qik Cloud Government?
What are the current workarounds in SAAS/QCG for this GAP in product functionality?
This needs some good documentation, with some common real world examples.

when will webfile be added to SAAS/QCG?