topic Re: Missing data when loading data from sharepoint into QlikView in QlikView

Missing data when loading data from sharepoint into QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please can someone advise how I can get all the SharePoint list content into Qlikview, when I load the data using the Web file under File type select Xml them html. the below error ocurs

Reference to undeclared namespace prefix:'ie' 'html/head/script': LOAD script%Table, %Key_html_F13842F4E7969BCE

when I use Web Files, under File Type select Html, its loads but not the entire list. It loads the page of this.

Please can someone advise how I can get all 30 pages on my sharepoint list into QlikView

Re: Missing data when loading data from sharepoint into QlikView

Or — Mon, 20 Nov 2017 12:36:45 GMT

Load (Stuff)

FROM [http://YourPathHere/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={ListIDGoesHere}] (XmlSimple, Table is [xml/data/row]);

See:

Reading Data from Sharepoint lists into QlikView

Re: Missing data when loading data from sharepoint into QlikView

Anonymous — Mon, 20 Nov 2017 12:45:47 GMT

Hi OR Shoham,

I tried that loading it as mention about however its not working. my problem is the data pulls in however instead of 900+ it pulls in 30

Re: Missing data when loading data from sharepoint into QlikView

Anonymous — Mon, 20 Nov 2017 13:18:36 GMT

Hi Nokuthula and Or Shoham,

I am able to read SharePoint list from qlikview desktop using both the methods html - using direct link as present on the SharePoint list web browser and using the RPc call method (created ViewGUID and ListGUID link like Or shoham has mentioned. Both these are working on the qlikview desktop but when I published my qvw , both fail the task. The task fails in both cases.

Any tips how to make the task pass at QlikView publisher end. Am I supposed to make any setting at the QmC publisher end for the task to pass? Should the url created be entered somewhere. Or does the id have to be given special permission. How to do this so that task passes. Please give me solution for it to pass using your experience.

Regards.

Re: Missing data when loading data from sharepoint into QlikView

Or — Tue, 21 Nov 2017 08:21:24 GMT

I can confirm that this method works. If you're only getting 30 records, you're probably trying to read it as a web page instead of defining a list. That method does not work properly (unless the list is very short).

Re: Missing data when loading data from sharepoint into QlikView

Anonymous — Tue, 21 Nov 2017 11:49:16 GMT

Hi, does this work at the Publisher. It failed tasks for me as described. Please suggest a solution at publisher end

Re: Missing data when loading data from sharepoint into QlikView

Anonymous — Sat, 25 Nov 2017 10:40:00 GMT

Hi or shoham, the error log I am getting is "Error : Invalid at the top le el of the document. On line number 2. On column :11. system ID: owssvr.dll?cmd=Display&XMLDATA=1&RowLimit=0&List={ListGuid}

Invalid at the top level of document. On line number:2. on column number :11. system ID: Same like above. execution failed.

The task is failing at publisher level when connecting to SharePoint list. What needs to be done here for it to pass. My publisher runs on a functional id. My id has been granted access to read the list and I am using my id in the Distribute so that only I can see this after reload. Please tell me what needs to be done here for the task to pass.