如何在共享的GoggleDrive檔案夾中創建所有檔案夾的串列

我正在嘗試創建我所有的谷歌驅動器檔案夾的串列，并且我有以下腳本和一個指向我從哪里獲得腳本的問題的鏈接。我只是不確定如何實作它。我將驅動器 ID 放在第 6 行，然后運行它并收到此錯誤；誰能告訴我哪里出錯了？

使用 Apps 腳本在電子表格中列出共享云端硬碟的每個檔案和檔案夾

上午 11:08:37 錯誤
ReferenceError：未定義 gobj getFoldersInASharedFolder @ Folder Listing.gs:12

這是腳本

function getFoldersInASharedFolder() {
  let tr = [];
  let token = '';
  let page = 0;
  do {
    let r = Drive.Files.list({ corpora: 'drive', includeItemsFromAllDrives: true, supportsTeamDrive: true, supportsAllDrives: true, driveId: "???", pageToken: token,q: "mimeType = 'application/vnd.google-apps.folder'" });
    let obj = JSON.parse(r);
    tr.push(obj)
    token = obj.nextPageToken
  } while (token != null)

  let folder = DriveApp.getFolderById(gobj.globals.testfolderid);
  folder.createFile(`SharedDriveList ${Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss")}`, JSON.stringify(tr), MimeType.PLAIN_TEXT);

  let html = '<style>td,th{border:1px solid black;font-size: 16px;}</style><table><tr><th>Title</th><th>Id</th><th>Path</th></tr>';
  tr.forEach((o, i) => {
    o.items.forEach(item => {
      if (item.mimeType = "application/vnd.google-apps.folder") {
        html  = `<tr><td>${item.title}</td><td>${item.id}</td><td>${getPathAllDrivesFromId(item.id)}</td></tr>`;
      }
    })
  });
  html  = '</table><input type="button" value="exit" onclick="google.script.host.close()" />';
  SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html).setHeight(500).setWidth(1200), `Folders in: ${JSON.parse(Drive.Drives.get("driveid")).name}`);
}

uj5u.com熱心網友回復：

出現錯誤訊息是因為

let folder = DriveApp.getFolderById(gobj.globals.testfolderid);

使用gobjas 引數但未gobj宣告的嵌套屬性。

您可以通過正確宣告gobj或替換 gobj.globals.testfolderid為檔案夾 id（正確設定為字串）來修復此錯誤。

uj5u.com熱心網友回復：

評論解釋了如何使用這個功能

function getFoldersInASharedFolder() {
  const sharedriveid = "";//add the shared drive id here
  const storagefilefolderid = ""; //this where I was storing the response which I used when I was first building the script. It's not necessary to do this if you don't wish to.  You can just comment that code out of the script
  let tr = [];
  let token = '';
  let page = 0;
  do {
    let r = Drive.Files.list({ corpora: 'drive', includeItemsFromAllDrives: true, supportsTeamDrive: true, supportsAllDrives: true, driveId: sharedriveid, pageToken: token,q: "mimeType = 'application/vnd.google-apps.folder'" });//drive id for the shared drive that you wish all of the folders from
    let obj = JSON.parse(r);
    tr.push(obj)
    token = obj.nextPageToken
  } while (token != null)

  let folder = DriveApp.getFolderById(storagefilefolderid);//the folder id for the file that stores the results
  folder.createFile(`SharedDriveList ${Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm:ss")}`, JSON.stringify(tr), MimeType.PLAIN_TEXT);

  let html = '<style>td,th{border:1px solid black;font-size: 16px;}</style><table><tr><th>Title</th><th>Id</th><th>Path</th></tr>';
  tr.forEach((o, i) => {
    o.items.forEach(item => {
      if (item.mimeType = "application/vnd.google-apps.folder") {
        html  = `<tr><td>${item.title}</td><td>${item.id}</td><td>${getPathAllDrivesFromId(item.id)}</td></tr>`;
      }
    })
  });
  html  = '</table><input type="button" value="exit" onclick="google.script.host.close()" />';
  SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html).setHeight(500).setWidth(1200), `Folders in: ${JSON.parse(Drive.Drives.get(sharedrivedid)).name}`);
}

標籤：谷歌应用脚​​本谷歌驱动API谷歌工作区谷歌驱动器共享驱动器

上一篇：GoogleApps腳本中的表格資料操作

下一篇：Link組件內的NextJS按鈕