Forum Discussion

Nick's avatar
Nick
Frequent Visitor
10 years ago

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 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Well, you can get version history like so:

 

http://<server>/<site>/_layouts/versions.aspx?list={litsID}&ID=<itemID>

 

Here are some resources that might assist:

http://stackoverflow.com/questions/24423657/sharepoint-2013-get-splistitem-versions-via-rest

http://www.c-sharpcorner.com/UploadFile/anavijai/how-to-get-the-file-versions-in-sharepoint-2013-online-using/

https://social.msdn.microsoft.com/Forums/en-US/79945c1d-1581-4441-bc13-14d119aa6a64/document-version-history-via-rest-api?forum=sharepointdevelopmentprevious

s-roberts's avatar
s-roberts
Helper I
5 years ago

Is there any update for this solution, considering this was a post from 2016? 

These solutions work well in PBI Desktop but when publishing to the service I'm unable to refresh the dataset.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, s-roberts  ,

     

    Try the solution suggested by Chris Webb here.

    As I understand it, you need to hide away part of the API call's string from Power Query and append it during the run, so the code would look like this:

    Web.Contents("<your-webpage>",[RelativePath = "<continuation of the API call>"])

    I was able to pull in full version history and be able to set auto-refresh on the Service. 

     
    Thanks 
    Evan
    • NickTT's avatar
      NickTT
      Helper III
      5 years ago

      I tweaked mine to use RelativePath and it still works fine from the Desktop but still fails to load with a refresh. I am using SharePoint online. Any tips?

      • NickTT's avatar
        NickTT
        Helper III
        5 years ago

        I found a work around. Load the data into a DataFlow first. In your Dataflow there is an Options button. In there click Project Options. Check the box "Allow combining data from multiple sources. This could expose sensitive or cofidential data to an unauthorized person.". With that set the query can now pull the data from both SharePoint and WebContent.