Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. var file_id = '1JqbuqOQS5NSFqfPlxJG-DY1HIW9xZl_ddjQa_F2pUv4';
  2. var revisions = Drive.Revisions.list(file_id);
  3. var revision = revisions.items[revisions.items.length-1];
  4.  
  5. var revUrl = Drive.Revisions.get(file_id, revision.id).exportLinks["text/csv"] + "&access_token=" + ScriptApp.getOAuthToken();
  6.  
  7. var revString = UrlFetchApp.fetch(revUrl).getContentText();
  8.  
  9. var file_id = '1JqbuqOQS5NSFqfPlxJG-DY1HIW9xZl_ddjQa_F2pUv4';
  10. var revisions = Drive.Revisions.list(file_id);
  11. var revision = revisions.items[revisions.items.length-1];
  12.  
  13. // I modified following script.
  14. var revUrl = Drive.Revisions.get(file_id, revision.id).exportLinks["application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"] + "&access_token=" + ScriptApp.getOAuthToken();
  15. var blob = UrlFetchApp.fetch(revUrl).getBlob();
  16. var tempSSId = Drive.Files.insert({mimeType: MimeType.GOOGLE_SHEETS}, blob).id;
  17. var sheets = SpreadsheetApp.openById(tempSSId).getSheets();
  18. for (var i = 0; i < sheets.length; i++) {
  19. var csv = sheets[i].getDataRange().getValues().map(function(e) {return e.join(",")}).join("n");
  20. Logger.log(csv)
  21. }
  22. Drive.Files.remove(tempSSId);
  23.  
  24. var file_id = '1JqbuqOQS5NSFqfPlxJG-DY1HIW9xZl_ddjQa_F2pUv4';
  25. var sheetIds = SpreadsheetApp.openById(file_id).getSheets().map(function(e) {return e.getSheetId()});
  26. var token = ScriptApp.getOAuthToken();
  27. var revisions = Drive.Revisions.list(file_id);
  28. var revision = revisions.items[revisions.items.length-1];
  29. var reqs = sheetIds.map(function(e) {
  30. var revUrl = Drive.Revisions.get(file_id, revision.id).exportLinks["text/csv"] + "&access_token=" + token + "&gid=" + e;
  31. return {url: revUrl, muteHttpExceptions: true};
  32. });
  33. var res = UrlFetchApp.fetchAll(reqs);
  34. for (var i = 0; i < res.length; i++) {
  35. if (res[i].getResponseCode() == 200 ) {
  36. Logger.log(res[i].getContentText())
  37. }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement