Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Qlik Web Connectors allows loading Excel files (xls, xlsx) hosted in online file storage services such as Box, Dropbox, Google Drive and OneDrive directly into QlikView and Qlik Sense without having to save the file to disk first.
Different methods need to be applied to fetch files depending on what edition of Qlik Sense is used.
Note that the in-built Web Connectors are available are:
Unavailable at the moment are:
To connect to, for example an excel file, stored on Google Drive:
More information: Managing data sources in spaces.
You can add data files and data connections directly in shared and personal spaces. This enables data sources to be added outside of apps for use by other space members.
We use the query GetRawFileAsBinary of the appropriate connector in Qlik Web Connectors.
Once the binary content is sucessfully loaded in Qlik Web Connectors web console, you can create a webfile connection in QlikView or Qlik Sense to load data from Qlik Web Connectors.
In QlikView:
SaaS Topics:
Managing data sources in spaces.
Built-in Qlik Web Connectors
STT - Reloading Your Data in Qlik Sense Business
WebConnectors (not SaaS):
Data sources included in Qlik Web Connectors
Google Drive and Spreadsheets
OneDrive
Dropbox
Qlik Web Connectors authentication fails with error "Could not establish trust relationship for the ...
@Sonja_Bauernfeind is there any way to load web file in Qlik Saas ? like https://myurl.com/mywebspreadsheet.xlsx ?
It works fine in QlikView, it seems to be possible in entreprise edition (even if i'm getting a timeout ...) but i can't find a way to achieve that in Saas edition (i'm trying with rest connector and "with connection" but without result)
Hello @NicolasAimain1
We have an open idea for this in our Ideation platform. I would recommend voting for it and showing your support by adding additional weight to it.
https://ideation.qlik.com/app/#/case/281241
Until then, please post about your requirement in our Connectivity and Data Prep forum. There, you will be able to get assistance not only from our active agents but our community at large.
All the best,
Sonja