/**

 * Enable Drive Advanced API in services

 */

/**

 * getSharedDrives

 * @return {array} array of objects

 * 

 * Object:

 * -name: Name of shared drive

 * -kind: drive#drive

 * -id:  driveId

 * -Users[]

 *  .driveId

 *  .driveName

 *  .role : - owner - organizer - fileOrganizer - writer - reader

 *  .email

 *  .type : - user - group - domain - anyone

 * 

 */

function getSharedDrives() {

  let page = '';

  let pageToken = '';

  let SharedDriveList = [];

  do {

    page = Drive.Drives.list({

      //change to your domain name

      domain: 'myuba.be',

      maxResults: 10,

      pageToken: pageToken,

      projection: 'full',

    })

    SharedDriveList = SharedDriveList.concat(page.items)

    pageToken = page.nextPageToken;

  } while (pageToken)

  //return object

  for (dr = 0; dr < SharedDriveList.length; dr++) {

    // Users[].0= email

    // Users[].1=fileOrganizer|organizer

    // Users[].2=group|user

    SharedDriveList[dr].Users = getPermissionsList_(SharedDriveList[dr].id, SharedDriveList[dr].name)

  }

  return SharedDriveList;

  Logger.log('einde')

}

/**

 * Helper function

 * getPermissionsList_

 * @param {string} driveId, string with driveId

 * @param {string} driveName, string with driveName

 * @return {array} array of objects

 * Users[]

 *  .driveId

 *  .driveName

 *  .role : - owner - organizer - fileOrganizer - writer - reader

 *  .email

 *  .type : - user - group - domain - anyone

 */

function getPermissionsList_(driveId, driveName) {

  // THIS IS IMPORTANT! The default value is false, so the call won't 

  // work with shared drives unless you change this via optional arguments

  const args = {

    supportsAllDrives: true

  };

  // Use advanced service to get the permissions list for the shared drive

  let pList = Drive.Permissions.list(driveId, args);

  //Put email and role in an array

  let editors = pList.items;

  var arr = [];

  for (var i = 0; i < editors.length; i++) {

    let permissions = {}

    permissions.driveId = driveId

    permissions.driveName = driveName

    permissions.role = editors[i].role

    permissions.email = editors[i].emailAddress

    permissions.type = editors[i].type

    arr.push(permissions)

  }

  return arr

  Logger.log(arr);

}

/**

 * Helperfunction 

 * setPermissionsList_

 * @param {object}

 * 

 */

function setPermissionsList_({ driveId, role, email, type }) {

  //role can be - owner - organizer - fileOrganizer - writer - reader

  //type can be - user - group - domain - anyone

  const response = Drive.Permissions.insert(

    {

      role: role,

      type: 'user',

      value: email,

      type: type,

    },

    driveId,

    {

      supportsAllDrives: true,

      sendNotificationEmails: true,

      fields: 'emailAddress,role',

    }

  );

  console.log('Shared Drive shared with %s', response.emailAddress);

}

/**

 * MapDriveUserRole

 * 2d table of users and shared drives and their role/type

 * 

 * 

 *  

 */

function MapDriveUserRole(sheetname) {

  try {

    let SharedDrivelist = getSharedDrives()

    let arr = [[]]

    arr.shift()

    // create header row = all shared drives

    var headers = []

    let Emails = []

    for (let s = 0; s < SharedDrivelist.length; s++) {

      headers[s] = SharedDrivelist[s].name

      for (let u = 0; u < SharedDrivelist[s].Users.length; u++) {

        Emails.push(SharedDrivelist[s].Users[u].email)

      }

    }

    headers.sort()

    headers.unshift('Email')

    arr.push(headers)

    // create Unique user list based on addresses used in shared drives

    var UEmails = []

    let ue = 0

    for (let i = 0; i < Emails.length; i++) {

      let idx = UEmails.indexOf(Emails[i])

      if (idx == -1) {

        UEmails[ue] = Emails[i]

        ue++

      }

    }

    UEmails.sort()

    //Create 2D array

    for (let r = 0; r < UEmails.length; r++) {

      let rec = new Array(headers.length)

      rec[0] = UEmails[r]

      arr.push(rec)

    }

    // fill array

    for (let s = 0; s < SharedDrivelist.length; s++) {

      // column nmmer

      let col = headers.indexOf(SharedDrivelist[s].name)

      //get user info

      for (let u = 0; u < SharedDrivelist[s].Users.length; u++) {

        let row = UEmails.indexOf(SharedDrivelist[s].Users[u].email) + 1

        arr[row][col] = SharedDrivelist[s].Users[u].role

      }

    }

    let Sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetname);

    Sheet.getRange(1, 1, arr.length, arr[0].length).setValues(arr);

    SpreadsheetApp.flush();

    Logger.log('einde')

  } catch (e) {

    Logger.log(e)

  }

}

Shared drive: Find files by name

De DriveApp method GetFilesByName werkt uitsluitend op het mydrive stuk.

var file_info = DriveApp.getFilesByName(Emails.EmailInfo[r]);
Deze kan je niet gebruiken om files bij hun naam te vinden op de shared drive, waardoor het copieren van een file met een specifieke naam (vb template file) niet op deze wijze lukt.

Wat wel lukt is de file benaderen met zijn id vanuit DriveApp.

Om de file op een shared drive terug te vinden aan de hand van zijn naam, kan je enkel gebruik maken van de Drive.Files.list method, met als titel de naam van de file en de zoekfunctie op alle drives .
Drive.Files.list.

Nadien kan je wel met de ID toegang krijgen via de DriveApp  lib.

Wanneer je corpora= "drive" gebruikt, moet je de ID van de shared drive meegeven waarop gezocht moet worden.
const res = Drive.Files.list({ corpora: "drive", driveId: driveID , includeItemsFromAllDrives: true, supportsAllDrives: true, maxResults: 1000, q: `title='${filename}'` });
Deze vind je terug als je de shared drive opend op het hoogtes niveau, in de url:
https://drive.google.com/drive/folders/0AIK9039F_k-iUk...

Wanneer je echter over alle drives heen wil zoeken, kan je dit enkel door gebruik te maken van de userKey en de Corpora allDrives.
const res = Drive.Files.list({ userKey: CurrentUserID, corpora: "allDrives", includeItemsFromAllDrives: true, supportsAllDrives: true, maxResults: 1000, q: `title='${filename}'` });