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: 
makumar-shire
Contributor
Contributor

Qlik Office 365 Sharepoint Connector - How to retrieve version history from SharePoint List

Hi All,

I am using Qlik o365 SharePoint Connector to pull the data  from SharePoint list. When we are puling the data it shows only the current item not the version history. Is there any way to retrieve the version history from SharePoint list ?

Thanks in advance.

Manish

2 Replies
Darren_Ball
Employee
Employee

Hi,

Yes, this should be possible.

If within QWC you can identify the file that you want the version history of, then if you look in the response for that file you'll see a field called Versions_Feed. This can then be used in the DataFeed table to see the revision history.

So, assuming that the connector is authenticated, here's a step by step example.

  1. I have an excel file in a folder, which has 4 revision history entries in Sharepoint
  2. Go to the ListFiles table and in the Folder box, enter the folder that the file can be found. In my case i enter /Shared Documents/DB test folder
  3. This returns all the files in that folder. I find the one i want called book.xlsx and scroll to the right looking for a field called 'Versions_Feed'. Copy the value, which will look something like "Web/GetFileByServerRelativePath(decodedurl='/Shared%20Documents/DB%20test%20folder/Book.xlsx')/Versions"
  4. Go to the GetDataFeed table and paste this value in to the feed box and hit run.
  5. I see that there are 3 rows returned representing the stats of the previous 3 revisions.

A point here, in Sharepoint there were 4 revision entries, but 1 of these represented the current version. The connector returned the 3 previous revisions and not the current version, because you get those stats from the ListFiles data that's returned in point 3 above.

I hope this makes sense and helps. If not, let me know.

Darren

Qlik Web Connectors - Lead Product Designer

brencz
Contributor
Contributor

this solution worked for me! I was also interested in getting all of the versions for all items of an entire SP list without having to create a loop. Is this possible?