topic Pull content from Sharepoint in QlikView

Pull content from Sharepoint

Anonymous — Mon, 27 Feb 2017 15:05:11 GMT

All, I have a requirement to pull a SharePoint list into Qlikview. The content should show up in Qlikview in same format(with bulleted points, paragraphs, etc). Further, I want to write back i.e to make changes in QlikView to this content and this updates the SharePoint list.

Please guide me the steps to achieve this. Please be as detailed as possible as I am new to coding of SharePoint and QV writeback capabilities. Our preference is to use in house QV capabilities. if not possible we can go for extension objects.

Thanks

Samy

Re: Pull content from Sharepoint

avinashelite — Mon, 27 Feb 2017 16:02:56 GMT

check this

Write back

Writting data from Qlikview to SharePoint

Reading the data :

Reading Data from Sharepoint lists into QlikView

Re: Pull content from Sharepoint

Anonymous — Mon, 27 Feb 2017 17:07:44 GMT

Thanks!

I followed the links and it appears in order to pull data from SP 2013, we need to follow the below link:

How to Fetch a Sharepoint 2013 List using REST interface

In following the above link, I am not sure what to change in the standard link mentioned:

FROM [http://server/site/_api/web/lists/getbytitle(‘Title’)/Items?$Top=$(vListCount)] (XmlSimple, Table is [feed/entry]);

Thanks!!

Re: Pull content from Sharepoint

avinashelite — Tue, 28 Feb 2017 05:21:18 GMT

You need change the URL after http:// .... add your url hear and the corresponding list/file name

Re: Pull content from Sharepoint

Anonymous — Tue, 28 Feb 2017 14:12:32 GMT

Thanks Avinash. I was able to construct the URL after little struggle.

Re: Pull content from Sharepoint

avinashelite — Tue, 28 Feb 2017 14:18:40 GMT

Cool happy learning

Re: Pull content from Sharepoint

Anonymous — Tue, 28 Feb 2017 14:50:35 GMT

I have a question related to formatting, however since it is a new issue, I raised another thread. If you get a chance, can you please into this?

Sharepoint data format issues