Version History with Check in Comments

[DM85]

I'm trying to connect to documents within a sharepoint library and pull back the version history including the check in comments. For some reason I can get all of the comments for previous versions, but not the current/latest version.

For example I have File A - the current version is 1.5 with checkincomment Approved by Final Approver, but when I pull back the data in Power Query I see every version except the latest one

Name	Version	Modified	Checkincomment
File A	1.1	12:01	Draft file created
File A	1.2	12:03	First approval requested
File A	1.3	12:10	Approved by 1st approver
File A	1.4	12:37	Approved by 2nd approver

Is there a way to pull the latest version through and merge the two queries?

[Expiscornovus · Accepted solution]

Hi @DM85,

Just to double check. What methods/Uri are you using in your API calls. Can you share your REST API call?

I have seen different results when people tried using the items method instead of directly interacting with the file versions. Below is an example of a similar discussion:

https://sharepoint.stackexchange.com/questions/276668/get-comments-of-previous-versions-checked-in-i...

[DM85]

@Expiscornovus thank you - this worked

[lbendlin]

Might not even need an API call for that.  See if you can change the view.

How to display the last check-in comment in a document library | SharePoint Maven

[DM85]

@lbendlin thank you - this is good to know when trying to pull the comments into the library