Forum Discussion
Nick
9 years agoFrequent Visitor
Getting SharePoint List items with full history version?
Hi, We do have a SharePoint list to manage Fleet inventory of asset: mainly their attribution (who own it) and their status (active, lost, broken, etc.). We did activated the SharePoint Version ...
llaumans
9 years agoFrequent Visitor
Hi Nick,
did you ever figure out how to retrieve the history for items in a SharePoint list so you could run historical reports on your data? I would be very interested to learn how you managed to get this done!
Thanks in advance!
Kind Regards,
Lucas
Nick
9 years agoFrequent Visitor
Hi Lucas,
The current workaround I'm currently using since I don't have access to SharePoint DB/Framework is via R script:
Here I'm taking snapshot of Group, Status, Id, and ExtractDate data into a local CSV file, everytime I'm refreshing the Data Source.
Not fancy but it does the job for now.
Hope that will help.
Nick