Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
pawwy1415
Creator III
Creator III

Extracting data from share point into Qliksense

Hi,

I’m getting below error “Bad Zip File” when loading data  into QlikSense from a SharePoint Excel-file “xyz” .  Please can you guys suggest whats I am doing wrong.


LET vPath = 'http://connect.ukmkt.ad.ge.corp.local/sites/it/pmm/pre-project/BusinessChange/itfsc/Shared%20Documen...   .. this link when we open file directly


LET vPath = 'http://connect.ukmkt.ad.ge.corp.local/sites/it/pmm/pre-project/BusinessChange/itfsc/default.aspx   -- this link open sharepoint and tab where this file is save  .. from file saved here we just need one sheet..


FROM [$(vPath)abc and xyz lmn pqr stu.xlsx]

(ooxml, embedded labels, header is 3 lines, table is [TGP - Applications]);


I've tried both option directly taking the link when we download the file and also

Thanks



0 Replies