Retrieving CreatedBy - Modified Person Name of Different Versions of a SP Online Document after Getting Versions using REST API

(0) Share

Report

Posted on by sc0rpiongirl

112

Hi Community,

With an automate flow, after using REST API call to get all versions info of SharePoint online library document, the output result I got is something like below the screenshot show. One piece of data that I really need is the name of the person who modified each version, in the metadata it appeared to be the "CreatedBy" data point. The challenge is the documents I need to check all versions not really from a SP Lists, and the output file doesn't provide anything that indicate the person ID / name etc. information. Is there a way to get the "CreatedBy" (modified by of each version) using other actions in a flow?

The CreatedBy "uri" in full is showing like this:

"CreatedBy": {
"__deferred": {
"uri": "https://abc.sharepoint.com/sites/name/_api/SP.FileVersion1f8c8ebe-c372-48ac-b97d-c8f1f1513944/CreatedBy"
}

Any suggestions would be greatly appreciated! 💐

Categories:

General topics

All responses (7)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
What REST endpoint are you using? Created By is actually represented by the AuthorId.

It is a Lookup Field so you need to use the Expand property.

/Sudeep/_api/web/lists/getbytitle('Documents')/items?$select=Title,Author/Name&$expand=Author l
sc0rpiongirl 112 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the suggestion. Looking at this api, looks like this needs to be lists. I got the versions using this line:
_api/web/getFileByServerRelativeUrl('@{triggerBody()?['text']}')/Versions
where triggerBody text is "RelativeLink" that is passed from power app. I have a gallery of documents that are from SP online library, the URL for the documents are https://abc.sharepoint.com/sites/sitename/libraryname/document.docx for example. With the RelativeLink, I retrieve all the versions but as my screenshot showed, there is no list ID, library name, item name nor item ID in the versions output. You suggested code means I need to use the document title? I could try but I am not sure it will work...
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Try to retrieve the versions using this endpoint

_api/web/lists/getbytitle('Documents')/items(95)/versions
sc0rpiongirl 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply. I have tried that but it only yielded the latest version instead of all versions, which is puzzling. I documented this exhausting exercise exhaustedly in a separate thread because it focuses on a different topic. (https://powerusers.microsoft.com/t5/General-Power-Automate/Use-REST-API-to-Retrieve-All-Versions-of-a-SharePoint-Online/m-p/2716575

it’s supposed to be a straightforward flow but apparently it wasn’t in my case.
sc0rpiongirl 112 on at

Like
a
(0)

Report
Copy link

Link copied!

I should report back that I just ran the flow with the endpoint you suggested ie using getByTitle('Documents')/Items(IteamID), actually it returned 404 file does not exist.

The goal is to get all versions with the key information including VersionLabel, Modified Time (Created), IsCurrentVersion, URL (to that version) and Modified By (CreatedBy), as we were to be able to see when we are in SP library right clicking on the 3 dots >> Version History. So far, I am not sure how to get the last piece of information ie CreatedBy for every version (not just the latest version which I could obtain quite straightforwardly.)

Thank you!
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Did you specify the ID of the Document item?

YourSiteUrl/_api/web/lists/getbytitle('Documents')/items(95)/versions
Verified answer

sc0rpiongirl 112 on at

Like
a
(0)

Report
Copy link

Link copied!
Yes. In fact, after trying several different uri, I finally got the result via this:

_api/Web/Lists(guid'ListGUID')/Items('ItemID')/Versions

Thank you for your suggestions which helped me to explore more options.