Reading from Sharepoint as XML

punitpopli — Thu, 30 Nov 2017 04:07:42 GMT

Hi Experts,

I came across one of the QVW in which the data is pulled in the QVW from a Sharepoint as XML and when i access the Sharepooint I am unable to find the file on SP.

Would like to know which file the code is reading from SP as XML?

Load *

FROM

Sharepointlink (XmlSimple, Table is [xml/data/row]);

Can anyone please help me on this?

Thanks in advance

Punit

Re: Reading from Sharepoint as XML

punitpopli — Tue, 26 Dec 2017 07:49:37 GMT

Hi All,

Finally i found the exact table my QVW was referring on the Sharepoint site.

QVW was pulling the table on the sharepoint site using XML, the table will be created as a list in the SP site which has its own site address i.e. http://...

how to get to the list name and IP :

a. At the last of the XML link their will be a GUID i.e. List={}, which is unique for a SP site and a list name will be tagged to the list id.

b. You can seek help from the SP admin, then can provide the details on the list name

c. You can use the list name to pull the data as a Internet file from QlikView.

Hope this will help.

Regards,

Punit

topic Reading from Sharepoint as XML in QlikView

Reading from Sharepoint as XML

Re: Reading from Sharepoint as XML