Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

katsafone
New Contributor III

HELP! - Working with REST data from SharePoint list in Load scripts

Hi,

Have spent some time trying to get this to work.

I have created a Qlik REST connection which connects fine to my SharePoint List:

https://domain/sites/_api/web/lists/getbytitle('Recommendations%20Master')/items

Using an adaptation of suggestions from Data load from Sharepoint 2013 (see script below) I want to load the SharePoint List data into a single table called Recommendations Master as the data seems to come down into many tables as a vertical listing (painful).

>>>>>

[Recommendations Master]:

Load

[RecID] as RecID,

    [ID] as ID,

    [Recommendations] as Recommendations

FROM [lib://ORIP Recommendations - REST]

(XmlSimple, Table is [feed/entry/content/properties]);

<<<<<

It is becoming very frustrating but any help on transforming data using Qlik REST connection to SharePoint List in order to utilise the related data as it appears in the SharePoint list original records will be greatly appreciated.

Thanks kindly.

Community Browser