CODEWITHSUNDEEP
google-drive-apidrive
Mickey D
Mickey D

Reputation: 347

Acquiring the Google Drive folder my google script is located

With the help of a nice article (https://www.labnol.org/internet/google-drive-tree/21198/), I just setup my first google script in Google Drive.

Quick Question: How may I get a running script /myFolder1/music/myFirstScript.gs, to determine it's running in /myFolder1/music?

This didn't work. I got the Url but nothing in the log file showed the correct answer.

  var files = DriveApp.searchFiles('title contains "GoogleTreeAgenda5"');
  while (files.hasNext()) {
    var file = files.next();
    Logger.log(file.getName());
    Logger.log(file.getUrl()); 
    Logger.log(file.getDownloadUrl());
    Logger.log(file.getDescription());
    Logger.log(file.getOwner());
    Logger.log(file.getParents());
    Logger.log(file.getParents()[0].getName());
    Logger.log("------------------------------");
  }

Longer Behind The Scenes Reason:

The file will be modified a bit so that each month I will create a new tree structure off the root with agenda topics and the script will create an html file from the directory tree which is based on topic. Basically it will be an outline creator based on the current location of the script file. So Let's say this month it's in: /myFolder1/music (so in other words it's /myFolder1/music/myFirstScript.gs. The script needs to determine that folder is /myFolder1/music so that I can have it print the tree structure starting from the folder it's located in to an html file..

In the example application provided by the site I noted above, there are 2 options to print the tree from the google script:

1) Tree starting from the root folder

var parentFolder = DriveApp.getRootFolder();

2) Starting from a particular folder (but I can't figure out and will need "Folder_Name" to be determined dynamically from the location where the .gs file is located)

var parent = DriveApp.getFoldersByName("FOLDER_NAME").next();

Upvotes: 1

Views: 277

Answers (1)

Mr.Rebot
Mr.Rebot

Reputation: 6791

I've used getScriptId() this will:

Gets the script project's unique id.

This id is also the unique id in the Google Drive. Then from there, create a recurring getParents() until you reach the root folder.

Here is the complete code:

function myFunction() {
var scriptID = ScriptApp.getScriptId();

//  Logger.log(scriptID)

// Log the name of every parent folder
 var driveFile = DriveApp.getFileById(scriptID); 
 var parentFolder = driveFile.getParents();
 while (parentFolder.hasNext()) {
   var folder = parentFolder.next();
   Logger.log(folder.getName());
 }  
}

NOTE:

There is no real or concrete path since a file can have multiple parents. It is also stated here in this related SO post.

Hope this helps.

Upvotes: 1

Related Questions