Tag: Folder

I am trying to search through some files stored in a specific folder on Google Drive using Google Scripts. This is for creating a “Deployment Folder” for my school for the upcoming academic session.

Code below:

function SearchFiles(query) {

  //put the source content folder ID and destination Drive folder ID here
  srcContentFolderID="srcID";

  try{  
    var files = DriveApp.getFolderById(srcContentFolderID).searchFiles('(title contains "' + query + '")');
    while (files.hasNext()) {
      var file = files.next();
      var fileName = file.getName();
      var parents = file.getParents();
      while (parents.hasNext()) {
        var parent = parents.next();
        if(parent.getId() == srcContentFolderID){
          //found the correct source of the file. Log it.
          Logger.log("Parent name: " + parent.getName() + " File name:" + fileName);
        }
        else
          Logger.log("NOT FOUND: " + parent.getName() + " File name:" + fileName);
      }
    }
  } catch(e){
    Logger.log("ERROR: "+e.Message);
  }

I have two questions:

1. DriveApp.getFolderById(srcContentFolderID).searchFiles('(title contains "' + query + '")') doesn’t work. I get the following exception:
   

   Exception: Invalid argument: q at SearchFiles at Array.forEach GS_INTERNAL_top_function_call.gs

Only searching using DriveApp.searchFiles('(title contains "' + query + '")') does work, but it gives a lot of results.
I am trying to do this for hundreds of files, so I risk timing out if I have to sift through multiple search results for every query.

2. I want to know what is the best way to find out the top level directory parent of the resultant file (which resides under “My Drive”). Since I have the same file stored in multiple places, I want to make sure that the source of the file that I am picking up is the right one. I have made a really dirty hack, which is again time consuming which looks like this:

function getAllParents(file) {
  var retStr="";
  try{
    var folder;
    var parents = file.getParents();
    while(1) {
      while (parents.hasNext()) {
      var parent = parents.next();
      folder=parent;
      retStr = retStr + parent.getName() + "->";
      if(parent.getName() == "My Drive")
        throw Exception;
      }
      parents = folder.getParents();
    }
  }
  catch(e){
    return retStr;    
  }
}

I then use indexOf to look for a substring in retStr and move forward.

I have looked through StackExchange for quite some time to figure out why an exception is generated, to no avail. Appreciate any help on this!

Note: I have seen the following links:

https://stackoverflow.com/questions/35661979/searching-for-file-by-name-within-a-folder-in-google-drive-using-google-scripts

https://stackoverflow.com/questions/52100052/folder-searchfiles-method-raises-invalid-argument-q-error/52100980

https://developers.google.com/drive/api/v2/ref-search-terms

https://stackoverflow.com/questions/56596130/google-app-script-driveapp-getparents-not-working-as-expected