Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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