javascript - Google Apps Script: trying to read a text file from Google Drive with .getAs(MimeType.PLAIN_TEXT)

Question

I'm stuck into trouble trying to read an HTML file from a Google Drive. So

I tried :

1. to get a text with a help of UrlFetchApp.fetch("https://googledrive.com/host/{folderID}/{filename}.html"), but it fetches some google css file instead of mine.

2. to convert a file from blob to a text string with file.getAs(MimeType.PLAIN_TEXT), and it just outputs "Blob" without any file content. How can I extract a file text without any specific libraries?

  var dApp = DriveApp;
  var folderIter = dApp.getFoldersByName("Лаборатории ФББ");
  var folder = folderIter.next();
  var filesIter = dApp.getFilesByName("Labs.html");

  var filelist = [];
  var propfiledate = 0;
  var propfilename;

  while(filesIter.hasNext()){

    var file = filesIter.next();
    var filename = file.getName();
    var fileurl = file.getUrl();
    var filedate = file.getDateCreated();

    if(filedate >= propfiledate){

      var propfiledate = filedate;
      var propfileurl = fileurl;
      var propfilename = filename;
      var propfile = file;

    }
  }

  Logger.log(propfile);

  // 1st try var myHtmlFile = UrlFetchApp.fetch(propfileurl);
  // 2nd try var myHtmlFile = propfile.getAs(MimeType.PLAIN_TEXT);
  // 3rd try var myHtmlFile = propfile.getBlob().text();
  
  var ss = SpreadsheetApp.create("test");
  SpreadsheetApp.setActiveSpreadsheet(ss);
  var sheet = ss.getActiveSheet();

  sheet.appendRow(myHtmlFile.toString().split("
"));

  Logger.log(propfiledate);
  Logger.log(propfilename);
  Logger.log(propfileurl);
}

question from:https://stackoverflow.com/questions/65885342/google-apps-script-trying-to-read-a-text-file-from-google-drive-with-getasmim

Answer 1

Using Apps Script on a dummy HTML file, you can get the HTML data that is inside of it.

Using DriveApp getFilesByName(name) method you retrieve the file by the name.

This will return a FileIterator since there can be many files with similar names.

Then you can get the file blob with getBlob() and the blob data as a string with getDataAsString()

I have managed to get the dummyHTML.html file data by using this previously mentioned methods:

function myFunction() {
  var files = DriveApp.getFilesByName("dummyHTML.html");
  while (files.hasNext()) {
    var file = files.next();
    Logger.log(file.getBlob().getDataAsString());
  }
}