Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pull content from Sharepoint

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

1 Solution

Accepted Solutions
6 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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

avinashelite

Cool happy learning

Anonymous
Not applicable
Author

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