Pull content from Sharepoint

[Anonymous]

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

[avinashelite · Accepted solution]

check this

Write back

Writting data from Qlikview to SharePoint

Reading the data :

Reading Data from Sharepoint lists into QlikView

[Anonymous]

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!!

[avinashelite]

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

[Anonymous]

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

[avinashelite]

Cool happy learning

[Anonymous]

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