Is there a way in google-apps-script to find out if the Google folder is empty?

I would like to write a google apps script to delete every empty folder in my Google drive, which method / property should I use to check the current folder (I can write a loop) is really empty, id est without any file or any other subfolder inside?

And what happens if you delete the folder that contains some files? Are these files deleted or do they become orphans (if they are associated only with the folder, of course)?

Thanks.

-cordialmente,

tiziano solignani, da ο£Ώ Mac http://blog.solignani.it

This is what I encoded after the first helpful answer, I just inserted the pagination:

function FindEmptyFolders() { var pageSize = 200; var folders = null; var token = null; var i = null; Logger.clear() do { var result = DocsList.getAllFoldersForPaging(pageSize, token); folders = result.getFolders(); token = result.getToken(); for (var i = 0; i < folders.length; i++) { for(n=0;n<folders.length;++n){ if(folders[n].getFiles().length==0 && folders[n].getFolders().length==0){ folders[n].setTrashed(true) Logger.log(folders[n].getName()) Logger.log(folders[n].getUrl()) } } } } while (folders.length == pageSize); MailApp.sendEmail('solignani@solignani.it', 'Script eliminazione folders vuoti Log', Logger.getLog()); } 
+2
google-drive-sdk google-apps-script
source share
1 answer

this code does the job

 function testForEmptyFolders() { var folders = DocsList.getAllFolders() for(n=0;n<folders.length;++n){ if(folders[n].getFiles().length==0 && folders[n].getFolders().length==0){ folders[n].setTrashed(true) Logger.log(folders[n].getName()) } } } 

The registrar shows the names of the deleted folders

+2
source share

All Articles