8

I am trying to write a script for analyzing changes to a Google Sheets document. When I look at the version history inside of Google Sheets I see what appears to be a complete history of the document going back to 2014. However, when I try to retrieve the history using Google Drive API (which is the only API that seems to support this, it doesn't seem to be supported in Google Sheets API directly?) I only get 226 revisions going back approximately 5 years. I have implemented support for calling iteratively using the getNextPageToken(), and I do get two chunks (one size 200 and one size 26) so I don't think it is related to this. It seems the API really only wants to present in 226 revisions. I get the same result when using Google's API explorer.

https://issuetracker.google.com/issues/70101398

Morty
  • 1,706
  • 1
  • 12
  • 25
  • 1
    It seems to be a bug, I also got an incomplete list of `revisionID`. You can [create/file an issue](https://b.corp.google.com/issues/new?component=191650&template=823909), as they can explain why revision.list() behaves like this. – Mr.Rebot Dec 02 '17 at 21:39
  • Mr. Rebot: Thanks – Morty Dec 03 '17 at 09:11
  • This just bit me as well; were you able to get a resolution to this? – Chrest Apr 05 '19 at 16:00
  • 3
    @Chrest: Unfortunately not - I created an issue in Google's system and other people have "starred" it and written they have the same issue etc. but nothing has happened :( – Morty Apr 19 '19 at 23:35
  • 1
    The issue is still very much present and it is very annoying. – Marcus Mar 27 '20 at 13:35

0 Answers0