Fetch the files of suspended users

Question

Is there a method in google apps script to get the files of a suspended owner based on his/her email id? I am literally trying to implement transfer drive files to a new owner using google apps script, I am using this code to find the details of all the suspended users:

/**
 * Fetches the suspended user details from the AdminDirectory.
 */
function fetchUser() {
  // Set the constant options only once.
  const options = {
    domain: 'xyz.com',
    orderBy: 'email',
    query: 'isSuspended=true',
    maxResults: 500,
    fields: "nextPageToken,users"
  };
  // Could log the options here to ensure they are valid and in the right format.

  const results = [];
  do {
    var search = AdminDirectory.Users.list(options);
    // Update the page token in case we have more than 1 page of results.
    options.pageToken = search.nextPageToken;
    // Append this page of results to our collected results.
    if(search.users && search.users.length)
      Array.prototype.push.apply(results, search.users);
  } while (options.pageToken);
  //Logger.log(results);

  for(var k = 0; k < results.length; k++){
     var fullEmail = results[k].primaryEmail;
     Logger.log(fullEmail);
     fetchFiles(fullEmail);
  }
}

/**
 * Fetches the files of the suspended users based on their email.
 */
function fetchFiles(email){
  var pageToken;
    var filesList = Drive.Files.list({  // Invalid value error is thrown here, I am not sure if this the right way to use Drive API in google script
      domain: 'xyz.com',
      orderBy: 'email',
      q: "'email' in owners",
      maxResults: 500,
      pageToken: pageToken
    });  
  Logger.log('filesList:' +filesList);
}

I am trying to implement something like Transfer ownership of a file to another user in Google Apps Script, but is there some way by which I can fetch the files of the user from the details obtained from the above code which basically returns the following output:

[
  {
    orgUnitPath = /,
    ipWhitelisted = false,
    gender = {type = other},
    creationTime = 2017-06-13T14:38:44.000Z,
    isMailboxSetup = true,
    isEnrolledIn2Sv = false,
    kind = admin#directory#user,
    suspensionReason = ADMIN,
    isAdmin = false,
    suspended = true,
    emails = [{
      address = john.seb@xyz.com,
      primary = true
    }],
    lastLoginTime = 2017-09-12T00:27:00.000Z,
    isDelegatedAdmin = false,
    isEnforcedIn2Sv = false,
    changePasswordAtNextLogin = false,
    customerId = v12idsa,
    name = {
      givenName = John,
      familyName = Seb,
      fullName = John Seb
    },
    etag = "npJcgeAc7Xbfksfwer22344/sfasdfaffUDsfdsjfhsfhsdfw-ec",
    id = 1033392392142423424,
    primaryEmail = john.seb@xyz.com,
    agreedToTerms = true,
    includeInGlobalAddressList = true
  },
  ...
] 

I am trying to use the Drive API in the google apps script in order to access the files of suspended users using their email, but its throwing

"Invalid Value" error

for the line Drive.Files.list, I am not sure if this is the right way to use the DRIVE API in google script, is there any other way to use this api in google script?

Answer 1

In your function fetchFiles, you never use the input argument email. Instead, you query the Drive REST API for the literal text 'email' in owners. Since the text string 'email' is not a valid email address, you correctly receive the error message "Invalid value".

Rather than this code:

/**
 * Fetches the files of the suspended users based on their email.
 */
function fetchFiles(email){
  var pageToken;
    var filesList = Drive.Files.list({
      domain: 'jerseystem.org',
      orderBy: 'email',
      q: "'email' in owners",
      maxResults: 500,
      pageToken: pageToken
    });  
  Logger.log('filesList:' +filesList);
}

You should perform the substitution first, to set up all constant options (as I mentioned and demonstrated in your other question), and then repeatedly query the Drive API for the files owned by the user with that email address:

function fetchAllFilesOwnedByEmail(email) {
  const searchParams = {
    corpora: 'some corpora',
    orderBy: 'some ordering criteria',
    q: "'" + email + "' in owners",
    fields: 'nextPageToken,items(id,title,mimeType,userPermission)'
  };

  const results = [];
  do {
    var search = Drive.Files.list(searchParams);
    if (search.items)
      Array.prototype.push.apply(results, search.items);
    searchParams.pageToken = search.nextPageToken;
  } while (searchParams.pageToken);
  return results;
}

You need to review the Drive REST API documentation, see Drive.Files.list and Search for Files at minimum. Don't forget to enable the Drive advanced service if you haven't.

Also note that while the above code will resolve the "Invalid Value" error you get, it won't necessarily make the user's files show up, even if you're executing the code as the G-Suite admin. Your research should have turned up at least these two related questions:

1. How can an Admin access the Google Drive contents of all the users in a particular domain?
2. Most efficient process for transferring ownership of all of a user's files using the Google Drive API