Loading data from Sharepoint list

[alec1982]

Hi,

anybody knows how to load data from a sharepoint list using the URL or any method.

Thxs,

[alec1982]

ou can load a list via.

LOAD

    ows_aaaaa,

    ows_bbbbb,

    %Key_xml_98C49F546A18E856    // Key to parent table: xml

FROM [http://<path to list>/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={EAAAA340-01EF-40B6-8AB7-8BD5DF076947}] (XmlSimple, Table is [xml/data/row]);

in the script

The tricky thing is to get the Listname: {EAAAAA.....

My way to do this is link the List to Excel, then look at the connection properties to get the Listname:

<LIST><VIEWGUID>{A75A8452-A561-4CFB-92B1-9D02E292320C}</VIEWGUID><LISTNAME>{EAAAA340-01EF-40B6-8AB7-8BD5DF076947}</LISTNAME><LISTWEB>http://<path to list>//_vti_bin</LISTWEB><LISTSUBWEB></LISTSUBWEB><ROOTFOLDER>/sites/germany/coll/wup/IT/Lists/Dell Bestellungen</ROOTFOLDER></LIST>

Once you have the full URL, just link a webfile as XML in Qlikview. You will get fieldnames like ows_xxxx and just need to rename.

I hope this helps.

Regards

Norbert