Google Apps Scriptã§ãã¡ã€ã«ãã©ã«ãã®æ¢çŽ¢ãGASã
å€éšDBããªãç°å¢ã®å Žåãã¹ãã¬ããã·ãŒãã®ã¿ãå¯äžã®ããŒã¿èç©å Žæã«ãªããããªã®ã§ãããäŸãã°åæ¯åºã«åãã¹ãã¬ããã·ãŒãã«æžããããšããã®ã¯ãè²ã ãšäžå®ãªé¢ãããã ãã§ãªããèŠããããªããšããèŠæããã£ããããŸãããšãªããšãã¹ãã¬ããã·ãŒãã忝åºå¥ã«çšæããŠèšå ¥ããŠããããæ¬åºã¯ãããåéããäºã«ãªãããã§ããããã¡ãã¡æ¯åºã®ã¹ãã¬ããã·ãŒããéããŠã³ããã§ã¯éçç£çã§ãããšãªããšããããã®ãã¡ã€ã«ããªã¹ãåãããã®ãªã¹ããå ã«ã¹ã¯ãªããã§ããŒã¿åéãçéã«ãªããšæããŸãã
ããã§å¿ èŠã«ãªãã®ãä»åã®ãã¯ãªã®ã§ãããèªåãfilelistãšããã·ãŒãã«ãã¿ã³äžçºã§æå®ã®ã¹ãã¬ããã·ãŒãã®IDãæå®ãã©ã«ãå ããåéããfilelistãå ã«ããŒã¿ãéããã¹ã¯ãªãããåžžçšããŠããŸããfilelistã®æ§ç¯ãäž»ã«äŸãšããŠã³ãŒãã玹ä»ããŠãããŸããããã«ã¯ãæå®ãã©ã«ã以äžã®ãµããã©ã«ãå ã®ã¹ãã¬ããã·ãŒãå šãŠãèŠã«è¡ãããã«ãªã£ãŠããã®ã§ãããŸãGoogle Driveã§æ·±ãéå±€ãäœããšåŸã«ããããã¹ã¯ãªãããåãäžã§åé¡ã«ãªãã®ã§ããªãã¹ãæµ ãäœãããšãšãGoogle Driveã¯ã·ã³ããªãã¯ãªã³ã¯çã«åäžãã¡ã€ã«ãå¥ã®ãã©ã«ãã«ãé 眮ãåºæ¥ãã®ã§ããããå©çšããã®ãã¹ããŒãã¢ããã«å¹æçã§ããã
ç®æ¬¡
ä»å䜿çšããã¹ãã¬ããã·ãŒãç
- DriveAppã¯ã©ã¹ã®searchFoldersã¡ãœãããsearchFilesã¡ãœãã
- ä»å䜿çšããã¹ãã¬ããã·ãŒã
Google Driveã®ç¹åŸŽ
Google Driveãšãã®APIã®ç¹åŸŽãšããŠã以äžã®ç¹ãæããããŸãã
- ãã£ã¬ã¯ããªãšããæŠå¿µããããããããªãããããŸã§ãã人éããããããã圢ã§ããã£ã¬ã¯ããªããªãŒæ§é ã®ãããªã€ã³ã¿ãŒãã§ãŒã¹ã«ãªã£ãŠããã ãã§ããã¹ãŠã®ãã¡ã€ã«ãã«ãŒããã£ã¬ã¯ããªã«ååšããŠããç¶æ ãæãæµ®ãã¹ããšè¯ãã
- ç¹å®ã®ãã£ã¬ã¯ããªã«å±ããŠãããšããæ å ±ããã¡ã€ã«ãæã£ãŠããã
- keyã§ç®¡çãããŠãããããåããã¡ã€ã«åã®åããã¡ã€ã«ãåãã¬ãã«ã§ååšããããšãåºæ¥ãã
- æ€çŽ¢ãããéã«ããµããã£ã¬ã¯ããªãŸã§ç²Ÿæ»ããŠãããªãã
- 现ããæ€çŽ¢æ¡ä»¶ãèšå®ã§ãããã®ã®ãã¡ãã£ãšããŸãã¡ãªç¹ãå€ãã
- DriveAppãšDocsListã®ïŒã€ã®åããããªã¯ã©ã¹ããããŸããããDocsListã¯å»æ¢ãããŸããã
- çŸåšããã©ã«ãåäœã§ã®ã³ããŒãåºæ¥ãªãã
ãããªæãã§ãã
WindowsãmacOSã®ãããªOSäžã§ã®ãã¡ã€ã«ã®æ€çŽ¢ãšã¯å°ã ç°ãªãç¹ããããããæ£çŽãªæã決ããŠäœ¿ããããããã§ã¯ãªããããããè€æ°ã®ãã¡ã€ã«ã®keyãç¥ãå¿ èŠæ§ããããããªã±ãŒã¹ã§ã¯ãå¿ é ã®ãã¯ããã¯ã§ãããããã§åŸãkeyã®ããŒã¿ãå ã«ãããŒã¿ãåãã«è¡ããªã©ã®ã³ãŒããæžãããšã«ãªãããã§ãã
ãã¡ã€ã«ããã©ã«ããå¥ã®ãã©ã«ãã«ãæå±ããã
Google Driveã«ã¯ãUNIXã§èšããšããã®ãã·ã³ããªãã¯ãªã³ã¯ãã®ãããªæ©èœãå®ã¯ãããŸããæ®éã®ãã¡ã€ã«ãµãŒãã§ã¯ã¡ãã£ãšèŠãããªããã®ã§ãããïŒã€ã®ãã¡ã€ã«ããã©ã«ããè€æ°ã®ãã©ã«ãã«æå±ãããäºãå¯èœã§ããã©ã¡ããå®äœã§ããã·ã§ãŒãã«ããã§ã¯ãããŸããããã¡ã€ã«ã®ã¢ã¯ã»ã¹æš©éãè€éã«ãªã£ããããã®ã§ãåæ±ãæ³šæã®æ©èœã§ãããä»åã®ããã«ãã¡ãã¡ã«æ£ãã°ã£ãŠãåããããªãã¡ã€ã«ããïŒç®æã®ãã©ã«ãã«éããã«ã¯ãã£ãŠããã®æ©èœã§ãã
ããæ¹ã¯ç°¡å
- ãã¡ã€ã«ããã©ã«ããéžæãã
- Shift + ZããŒãæŒãïŒãã®ä»ã®ã·ã§ãŒãã«ããããŒã¯ãã¡ããåç §ïŒ
- ã¡ãã¥ãŒãåºãŠããã®ã§ãæå±å ãŸã§è¡ããããã«è¿œå ããéžæãã
- åäžã®ãã©ã«ãããã©ã«ããå¥ã®å Žæã«ã衚瀺ãããããã«ãªã
å³ïŒã©ã¡ããå®äœã衚ããŠããŸãã
ãŸãããã®äœæ¥ããããã¡ã€ã«ãã©ãã®ãã©ã«ãã«æå±ããŠããã®ãïŒãŸããæå±ã®è§£é€ãç°¡åã§ãã
- ãã®ãã¡ã€ã«ããã©ã«ããéžæãã
- å³äžã«ããïŒiïŒã®ãã¿ã³ãã¯ãªãã¯ããŠãã¡ã€ã«æ å ±ã®ãµã€ãããŒã衚瀺
- ãµã€ãããŒã®è©³çްã¿ããã¯ãªãã¯ãã
- ãã¹ã®é ç®ã«æå±å äžèЧãåºãŠãããâå°ãã¯ãªãã¯ãããšãæå±ã®è§£é€ãã§ãã
å³ïŒæå±å äžèЧãç°¡åã«ç¢ºèªã§ããŸãã
ãœãŒã¹ã³ãŒã
åäžã®ãã©ã«ãå ã®ãã¡ã€ã«ãåæãã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
var folderid = "ããã«æ¢çŽ¢å
ãã©ã«ãã®IDãå
¥ãã" function driveman(){ //Drive APIã§ç¹å®ã®ãã¡ã€ã«ããªã¹ããšããŠååŸ var key = folderid; var files = DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet' and '"+key+"' in parents"); //filelistã·ãŒãã«ç§»åãå
容ãã¯ãªã¢ãã var mvsheet = SpreadsheetApp.getActiveSpreadsheet(); mvsheet.getSheetByName("filelist").activate(); var sheet = SpreadsheetApp.getActiveSheet(); sheet.getRange("A2:B").clearContent(); //ãŸãã«ã¬ã³ããã£ã¬ã¯ããªå
ã®ãã¡ã€ã«ãªã¹ãã®æžã蟌㿠var Cell = SpreadsheetApp.getActiveSheet().getRange("A2");//offsetã®åç
§ç¹ã»ã«ãèšå® Cell.activate(); var i = 0; while(files.hasNext()){ var file = files.next(); Cell.offset(i, 0).setValue(file.getId()); Cell.offset(i, 1).setValue(file.getName()); i++; } //次ã«ãã©ã«ãããããæ€çŽ¢ãããã£ãå Žåã«ã¯ãã©ã«ããªã¹ãé
åã«æ ŒçŽãã var folderlist = new Array(); var folders = DriveApp.searchFolders("'"+key+"' in parents"); var j = 0; while (folders.hasNext()) { var folder = folders.next(); folderlist[j] = folder.getId(); j++; } //ãã©ã«ããªã¹ãã«åºã¥ããåãã©ã«ãããŒã®äžã®ãã¡ã€ã«ãæžãåºããŠãã for(var xx = 0;xx<folderlist.length;xx++){ var curFolder = folderlist[xx]; files = DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet' and '"+curFolder+"' in parents"); while(files.hasNext()){ var file = files.next(); Cell.offset(i, 0).setValue(file.getName()); Cell.offset(i, 1).setValue(file.getId()); i++; } } } |
- ä»åã¯ãfolderidã«æ€çŽ¢å¯Ÿè±¡ã®ãã©ã«ãã®IDãäºããå ¥ããŠãããŠããã®ã§ããããå ã«ãã©ã«ãã®æ¢çŽ¢ãå®è¡ãããã¡ã€ã«ã®IDãåæãããŠããŸãã
- Drive.searchFilesã§ã¯mimeTypeã«ãŠGoogleã¹ãã¬ããã·ãŒããæ¡ä»¶ã«æå®ããŠããŸãã®ã§ãä»ã®ãã¡ã€ã«ã¯ãããããªãããã«ãªã£ãŠããŸãã
ãµããã©ã«ããŸã§å«ããŠãã¡ã€ã«ãæ¢çŽ¢ããã³ãŒã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 |
//ãµããã©ã«ããŸã§å«ããŠãã¡ã€ã«æ¢çŽ¢ããã³ãŒã function driveman2(){ var ui = SpreadsheetApp.getUi(); var mvsheet = SpreadsheetApp.getActiveSpreadsheet(); //æå®ãã©ã«ãããæ¢çŽ¢éå§ //var str = DriveApp.getRootFolder().getId(); //ã«ãŒããã©ã«ãããæ¢çŽ¢ããå Žå var str = folderid; //Drive APIã§ç¹å®ã®ãã¡ã€ã«ããªã¹ããšããŠååŸ var key = str; var nowdir = key; var totalcount=0; //filelistã·ãŒãã«ç§»åãå
容ãã¯ãªã¢ãã var sheet = mvsheet.getSheetByName("filelist"); sheet.activate(); sheet.getRange("A2:B").clearContent(); //ãã©ã°é¡ var subfolderflag = 0; //1ãªãæãã0ãªãç¡ãã //次ã«ãã©ã«ãããããæ€çŽ¢ãããã£ãå Žåã«ã¯ãã©ã«ããªã¹ãé
åã«æ ŒçŽãã var folderlist = new Array(); var filelist = new Array(); var folders = DriveApp.searchFolders("'"+key+"' in parents"); var cntlist = 0; if(folders.length == 0){ //æ®éã«æå®ãã©ã«ãå
ã®ãã¡ã€ã«ã®ãªã¹ããæžãåºããŠçµäº var files = DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet' and '"+key+"' in parents"); while(files.hasNext()){ var fileman = files.next(); var temparray = []; temparray.push(fileman.getId()); temparray.push(fileman.getName()); filelist.push(temparray); cntlist = cntlist + 1; } //ããã·ãŒãžã£ã®çµäº return 0; }else{ //ãµããã©ã«ããã©ã°ãç«ãŠã subfolderflag=1; //æå®ãã©ã«ãå
ã®ãã¡ã€ã«ã®ãªã¹ããæžãåºã var files = DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet' and '"+key+"' in parents"); while(files.hasNext()){ var fileman = files.next(); var temparray = []; temparray.push(fileman.getId()); temparray.push(fileman.getName()); filelist.push(temparray); cntlist = cntlist + 1; } //ãã©ã«ããªã¹ãé
åã«æ ŒçŽãã while(folders.hasNext()){ var folder = folders.next(); folderlist.push(folder.getId()); } } //ãµããã©ã«ã以éã®ãã©ã«ãã®æ¢çŽ¢ã«ãŒãã³ while (subfolderflag == 1) { var nowponyo = folderlist.length; for(var i = 0;i<nowponyo;i++){ //0çªç®ã®é
åã®keyãååŸãã key = folderlist[0]; //æå®ãã©ã«ãå
ã®ãã¡ã€ã«ã®ãªã¹ããæžãåºã files = DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet' and '"+key+"' in parents"); while(files.hasNext()){ fileman = files.next(); var temparray = []; temparray.push(fileman.getId()); temparray.push(fileman.getName()); filelist.push(temparray); cntlist = cntlist + 1; } //ãã®keyã®ãã©ã«ãã«ã¶ãäžãããã©ã«ãããªã¹ãã¢ãã folders = DriveApp.searchFolders("'"+key+"' in parents"); nowdir = key; //ãã©ã«ããªã¹ãé
åã«æ ŒçŽãã if(folders.hasNext()==true){ while(folders.hasNext()){ var folder = folders.next(); folderlist.push(folder.getId()); } } //é
å0çªç®ãåé€ãšè©°ãã folderlist.splice(0,1); } //folderlistã空ãªãsubfolderflagã0ã«ãã if(folderlist.length == 0){ subfolderflag=0; } } //filelistæžã蟌ã¿åŠç var lastColumn = filelist[1].length;ãã//ã«ã©ã ã®æ°ãååŸãã var lastRow = filelist.length; ãããã//è¡ã®æ°ãååŸãã sheet.getRange(2,1,lastRow,lastColumn).setValues(filelist); //çµäºåŠç SpreadsheetApp.flush(); ui.alert("ãªã¹ãã¢ãããçµäºããŸããã"); } |
- ä»åã¯æ¡ä»¶ãä»ããŠãGoogle Spreadsheet圢åŒã®ãã¡ã€ã«ã ããæ¢çŽ¢ããŠããã¯ã¢ããããŠããŸãã
- æå®ãã©ã«ã以äžã«æå±ããŠããã¹ãã¬ããã·ãŒãã®IDãšååããªã¹ãã¢ããããŠããŸãã
- Google Driveã®ä»ã®ãã©ã«ãã«ãæå±ããããã¯ããã¯ã䜵çšãããšãïŒç®æã«ãã©ãã©ã®ãã©ã«ãã«å±ããŠãããã¡ã€ã«ãéããŠããããšãã§ããã®ã§ãã³ãŒãå®è¡ãæ©ãå®äºããŸãã
- ç¹å®ãã©ã«ãã§ã¯ãªããã«ãŒããã©ã«ãïŒãã€ãã©ã€ãçŽäžïŒããå§ããå Žåã¯ãDriveApp.getRootFolder().getId();ã§IDãååŸããããšè¯ãã
åºæºãã©ã«ãããäžã®ãã©ã«ãéå±€ããã¹ãŠãªã¹ãã¢ããããã³ãŒã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
//åºæºãã©ã«ãããäžã®ãã©ã«ãéå±€ããã¹ãŠãªã¹ãã¢ããããã³ãŒã function driveman3(){ //Drive APIã§ç¹å®ã®ãã¡ã€ã«ããªã¹ããšããŠååŸ var key = folderid; var nowdir = key; var totalcount=0; //folderlistã·ãŒãã«ç§»åãå
容ãã¯ãªã¢ãã var mvsheet = SpreadsheetApp.getActiveSpreadsheet(); mvsheet.getSheetByName("folderlist").activate(); var sheet = SpreadsheetApp.getActiveSheet(); sheet.getRange("A2:C").clearContent(); var Cell = SpreadsheetApp.getActiveSheet().getRange("A2");//offsetã®åç
§ç¹ã»ã«ãèšå® Cell.activate(); //ãã©ã°é¡ var subfolderflag = 0; //1ãªãæãã0ãªãç¡ãã //次ã«ãã©ã«ãããããæ€çŽ¢ãããã£ãå Žåã«ã¯ãã©ã«ããªã¹ãé
åã«æ ŒçŽãã var folderlist = new Array(); var folders = DriveApp.searchFolders("'"+key+"' in parents"); if(folders.length == 0){ //æ®éã«æå®ãã©ã«ãå
ã®ãã¡ã€ã«ã®ãªã¹ããæžãåºããŠçµäº }else{ //ãµããã©ã«ããã©ã°ãç«ãŠã subfolderflag=1; //folderlistã·ãŒããžæžã蟌㿠while(folders.hasNext()){ var folder = folders.next(); Cell.offset(totalcount, 0).setValue(folder.getName()); Cell.offset(totalcount, 1).setValue(folder.getId()); Cell.offset(totalcount, 2).setValue(nowdir); folderlist.push(folder.getId()); totalcount++; } } //ãµããã©ã«ã以éã®ãã©ã«ãã®æ¢çŽ¢ã«ãŒãã³ var sub = 1; while (sub == 1) { var nowponyo = folderlist.length; for(var i = 0;i<nowponyo;i++){ //0çªç®ã®é
åã®keyãååŸãã key = folderlist[0]; //ãã®keyã®ãã©ã«ãã«ã¶ãäžãããã©ã«ãããªã¹ãã¢ãã folders = DriveApp.searchFolders("'"+key+"' in parents"); nowdir = key; //folderlistã·ãŒããžæžã蟌㿠if(folders.hasNext()==true){ while(folders.hasNext()){ var folder = folders.next(); Cell.offset(totalcount, 0).setValue(folder.getName()); Cell.offset(totalcount, 1).setValue(folder.getId()); Cell.offset(totalcount, 2).setValue(nowdir); folderlist.push(folder.getId()); totalcount++; } } //é
å0çªç®ãåé€ãšè©°ãã folderlist.splice(0,1); } //folderlistã空ãªãsubfolderflagã0ã«ãã if(folderlist.length == 0){ sub=0; } } //çµäºåŠç SpreadsheetApp.flush(); SpreadsheetApp.getUi().alert("ãªã¹ãã¢ãããçµäºããŸããã"); } |
- folderlistã·ãŒãã«æå®ãã©ã«ã以äžã®ãã©ã«ãæ§é ããªã¹ãã¢ããããŸãã
- ãã®ãã©ã«ãã®IDãšæå±ããŠã芪ãã©ã«ãã®IDãèšè¿°ããŸãã
- çŸåšãGoogle Driveã¯ãã©ã«ãåäœã§ã®ã³ããŒãã§ããŸããããã£ãŠãGoogle Apps Scriptã§äœæãäœãããã ãã¡ã€ã«ã®è€è£œã¯ããµããã©ã«ããŸã§å«ããŠããã¹ãŠèªåã§æåã§è¡ãå¿ èŠæ§ããããŸãã
- folderlistã«åºæ¥äžãããªã¹ãã¯ãå·Šããããã©ã«ãåãããã®ãã©ã«ãã®IDããæå±ãã芪ãã©ã«ãã®IDããšãªã£ãŠããŸãã
ãã€ã³ã
æ€çŽ¢æ¡ä»¶æŠèŠ
- title ã»ã»ã»èŠããã«ãã¡ã€ã«åã§ã®æ€çŽ¢ããã
- fullTextã»ã»ã»èŠããã«å šææ€çŽ¢ããã®ã¯ãŒããå ¥ã£ãŠãããã¡ã€ã«ãæ€çŽ¢ããã
- mimeTypeã»ã»ã»ãã¡ã€ã«ã®åœ¢åŒãæ£çŽã¡ãã£ãšæå®ã«ã¯çããããä»åã®ãã¢ã®äžã€ã
- modifiedDateã»ã»ã»ç·šéæ¥ã§æ€çŽ¢ãããã
- lastViewedByMeDateã»ã»ã»æåŸã«èªåãèŠããã¡ã€ã«ã®æ¥ä»ã§æ€çŽ¢ãããã®ã
- trashedã»ã»ã»åé€ãããã¡ã€ã«ãæ€çŽ¢ããŽãç®±ãããã
- starradã»ã»ã»âãã€ãããã¡ã€ã«ãæ€çŽ¢ã
- parentsã»ã»ã»èŠªãã©ã«ãIDã«æå±ããŠãããã¡ã€ã«ãæ€çŽ¢
- ownersã»ã»ã»ãã¡ã€ã«ã®ãªãŒããŒã§æ€çŽ¢ãã
- writersã»ã»ã»ãã®ãã¡ã€ã«ã®ç·šéè ã§æ€çŽ¢ãã
- readersã»ã»ã»ãã®ãã¡ã€ã«ã®é²èЧè ã§æ€çŽ¢ãã
- sharedWithMeã»ã»ã»èªåãšå ±æããŠãããã¡ã€ã«ã«ã€ããŠæ€çŽ¢ãã
- ããªããããã«ã³ãŒããŒã·ã§ã³ïŒ" "ïŒã§ããã£ãäžã«ãªãã·ã§ã³ãæžãããšã
- æ¡ä»¶ã®æå®ã¯ã·ã³ã°ã«ã³ãŒããŒã·ã§ã³ïŒ' 'ïŒã§ããã£ãäžã«æžãããšã
- 倿°ãçšããå Žåã«ã¯ã¡ãã£ãšç¹å¥ãªæžãæ¹ããããäžã®æ¹ã«ããæ€çŽ¢æ¡ä»¶ã®äžéšã«å€æ°ã䜿çšãããåèã«ããŠãã ããã
- æ¯åºå¥ã«çšæããç¹å®ã®ã¹ãã¬ããã·ãŒããšããäºãããããå Žåã«ã¯ãæŽã«ãã¡ã€ã«åãæ±ºããŠæŒããŠãããå«ããšããæ¡ä»¶ãå ãããµããã©ã«ã以äžã«ãã®åç§°ãå«ãä»ã®ãã¡ã€ã«ãèšçœ®ããªããªã©ã®éçšã«ãŒã«ãå¿ èŠã§ãã
mimetypeã®æå®
1 |
DriveApp.searchFiles("mimeType = 'application/vnd.google-apps.spreadsheet'"); |
æ€çŽ¢æ¡ä»¶ã®äžéšã«å€æ°ãå©çšãã
1 |
DriveApp.searchFiles("'"+key+"' in parents"); |
è€æ°ã®æ¡ä»¶åŒãã€ãªããå Žåã«ã¯ãandãªã©ããããç¹ã¯ãä»ã®èšèªãšå€ãããããŸããã
ãµããã©ã«ã以äžãæ¢çŽ¢ãããããã«
ä»åã®ã¹ã¯ãªããã§ã¯ãæå®ãã©ã«ãå ã ãã§ãªããæå®ãã©ã«ãå ã«ãããµããã©ã«ã以äžã®ãã©ã«ãå å šãŠã®é äžã®ã¹ãã¬ããã·ãŒããåæãããšããä»çµã¿ã«ãªã£ãŠããŸãããã®çºãæ¢çŽ¢æ®µéã§ã¯ãã©ãã ãã®ãµããã©ã«ããé ããŠããã®ãã¯ããããŸãããããã§ãé åãšããŠfolderlistãçšæããæ°ãã«ãã©ã«ããçºèŠãããé åã«è¿œå ããçµäºãããã®ããé åããåé€ãããšããã«ãŒãã³ãå ¥ã£ãŠããŸããé åã®äžããé çªã«ãã©ã«ããæ¢çŽ¢ããŠããã®ã§0çªç®ãåé€ããŠããã®ã¯ããããããšã§ããïŒfolderlist.splice(0,1)ãããããã£ãŠããïŒ
æçµçã«ãã©ã«ããªã¹ãã空ã«ãªã£ãããæ¢çŽ¢ã¯çµäºããflielistã«æ ŒçŽãããŠãé åãäžæ°ã«ã¹ãã¬ããã·ãŒãã«æžã蟌ã¿ãããŸãã
Drive APIãå©çšããŠæŽã«æ å ±ãååŸãã
Google Apps Scriptã®DriveAppã«ããFileãååŸããŠãgetId()ã§ãã¡ã€ã«ã®IDãååŸå¯èœã§ãããFileã¯ã©ã¹ã§ååŸã§ããæ å ±ã¯éå®ãããŠããŸããIDãæš©éããã¡ã€ã«ãµã€ãºãURLãMimetypeãæçµæŽæ°æ¥ãªã©ã¯ååŸã§ããã®ã§ãããäŸãã°ãã¡ã€ã«ã«ä»ããããŠãããèª¬ææ¬ãã®æ å ±ãããã¡ã€ã«ã®ã¢ã€ã³ã³ããªããžã§ã³ïŒçïŒã®æ å ±ãªã©ã¯Drive APIãå©çšããªããã°ååŸåºæ¥ãŸããã
äœ¿ãæ¹ã¯ç°¡åã§
- ã¹ã¯ãªãããšãã£ã¿ã®å·Šãµã€ãããŒã®ãµãŒãã¹ã®ïŒãã¿ã³ãã¯ãªãã¯
- Drive APIãéžæããŠã远å ãã¿ã³ãæŒã
ããã§ãã¹ã¯ãªããããæäœå¯èœã«ãªããŸããäŸãšããŠèª¬ææ¬ã®ã³ã¡ã³ããçæ°ã¯ä»¥äžã®ã³ãŒãã§ååŸå¯èœã§ãã
1 2 3 4 5 6 7 8 9 10 11 12 13 |
//ãã¡ã€ã«ã®èª¬æãšçæ°ãååŸããŠè¿ãïŒDrive APIãå©çšïŒ function getrevisionlist(fileId){ //è¿åŽçšå€æ° var array = []; var rev = Drive.Revisions.list(fileId); //æçµçã®å€ãšèª¬ææãååŸãã array.push(rev.items.length); array.push(Drive.Files.get(fileId).description) //é
åãè¿ã return array; } |
Drive.Files.getã§æ§ã ãªæ å ±ãDrive.Revisions.listã§ãªããžã§ã³ãã¡ã€ã«ã®è©³çŽ°ãªæ å ±ãååŸå¯èœã§ãã
å³ïŒãã¡ã€ã«ã®èª¬ææ¬ã®æ å ±ãŸã§ååŸå¯èœ
å®è¡ãšçµæ
ã¹ãã¬ããã·ãŒãã®ã¡ãã¥ãŒããããã¡ã€ã«æ¢çŽ¢ããéããŸãã3åã®ã¡ãã¥ãŒãããããªã¹ãã¯æŽãæ¿ãã§ãªã¹ãã¢ãããããä»çµã¿ã«ãªã£ãŠããŸããæåã¯åç»ã®ãããªæãã«ãªããŸãããã©ã«ãéå±€ãè€éã§æ·±ããããšãã¿ã€ã ã¢ãŠãããæãããããŸãã®ã§ãå®çšæã«ã¯ãç¹å®ã®ãã¡ã€ã«ã¯ã·ã³ããªãã¯ãªã³ã¯çã«ãïŒã€ã®ç¹å®ãã©ã«ãã«ãã¡ã€ã«ãéããŠãããšè¯ãã§ãã
- åäžãã©ã«ã - æå®ãã©ã«ãçŽäžã®ãã¡ã€ã«ããªã¹ãã¢ããããŸãã
- ãµããã©ã«ãå«ã - æå®ãã©ã«ãçŽäžä»¥å€ã«ããµããã©ã«ã以äžããã¹ãŠæ¢çŽ¢ããªã¹ãã¢ããããŸãã
- ãã©ã«ãéå±€åæ - æå®ãã©ã«ã以äžã®ãã©ã«ãéå±€æ§é ãåæããŸãã
é¢é£ãªã³ã¯
- Drive SDK - Search for Files
- Enum MimeType
- Google Script to Import CSV file from file list
- Google Drive APIã«ãããã¡ã€ã«ç®¡ç (1/5) - ãã¡ã€ã«ïŒãã©ã«ãã®äžèЧãååŸãã
- Can the new DriveApp parameters be used to search a specific folder?
- What are the Google Apps MIME Types in Google Docs and Google Drive?
- MimeTypeäžèЧ
- How to create a GUID / UUID in Javascript?
- Advanced Drive Service