/*Code.gs*/ function doPost(e) { /*###################### DRIVE FUNCTIONS ######################*/ // upload file to Root if ( e.parameter.func == "upFile" ) { return uploadFile(e.parameter.name,e.parameter.data,e.parameter.mime) } // upload file to Folder else if ( e.parameter.func == "upFileToFolder" ) { return uploadFileToFolder(e.parameter.name,e.parameter.data,e.parameter.mime,e.parameter.targetID) } } function doGet(e) { /*###################### AUTHENTICATION FUNCTIONS ######################*/ //test authenticated if ( e.parameter.func == "authenticate" ) { return authUser(); } /*###################### DRIVE FUNCTIONS ######################*/ //download a file by ID - roughly no greater than @ 1mb else if ( e.parameter.func == "downloadAFile" ) { return downloadAFile(e.parameter.fileID); } //create folder in root else if ( e.parameter.func == "folder" ) { return createFolder(e.parameter.name); } // create folder in a folder else if (e.parameter.func == "folderToFolder" ) { return createFolderInFolder(e.parameter.name,e.parameter.targetID) } //return list of folder names and IDs in root else if ( e.parameter.func == "getListRootFolders" ) { return getRootFolders(); } //return list of file names and IDs in root else if ( e.parameter.func == "getListRootFiles" ) { return getRootFiles(); } //return list of folder names and IDs from folder else if ( e.parameter.func == "getListFoldersInFolder" ) { return getListOfFoldersInFolder(e.parameter.targetID); } //return list of file names and IDs from folder else if ( e.parameter.func == "getListFilesInFolder" ) { return getListOfFilesInFolder(e.parameter.targetID); } //return list of file names and IDs by type from folder else if ( e.parameter.func == "getListFilesInFolderByType" ) { return getFilesInFolderByType(e.parameter.targetID,e.parameter.mtype); } //delete a file else if ( e.parameter.func == "deleteFile" ) { return deleteFile(e.parameter.fileID); } //delete a folder, but only if it is empty else if ( e.parameter.func == "deleteFolder" ) { return deleteFolder(e.parameter.folderID); } //share file by Id else if ( e.parameter.func == "shareFile" ) { return shareFile(e.parameter.fileID,e.parameter.email,e.parameter.call); } //share folder by Id else if ( e.parameter.func == "shareFolder" ) { return shareFolder(e.parameter.folderID,e.parameter.email,e.parameter.call); } //share file by access/permission else if ( e.parameter.func == "setSharingFile" ) { return setSharingFile(e.parameter.fileID,e.parameter.access,e.parameter.permission); } //share folder by access/permission else if ( e.parameter.func == "setSharingFolder" ) { return setSharingFolder(e.parameter.folderID,e.parameter.access,e.parameter.permission); } //move folder to another folder else if ( e.parameter.func == "moveFolderToFolder" ) { return moveFolderToFolder(e.parameter.folderID,e.parameter.targetID); } //move folder to root else if ( e.parameter.func == "moveFolderToRoot" ) { return moveFolderToRoot(e.parameter.folderID); } //move file to another folder else if ( e.parameter.func == "moveFileToFolder" ) { return moveFileToFolder(e.parameter.fileID,e.parameter.targetID); } //move file to root else if ( e.parameter.func == "moveFileToRoot" ) { return moveFileToRoot(e.parameter.fileID); } /*###################### SPREADSHEET FUNCTIONS ######################*/ //create sheet in root else if ( e.parameter.func == "sheet" ) { return createSheet(e.parameter.name); } // create sheet in a folder else if (e.parameter.func == "sheetToFolder" ) { return createSheetInFolder(e.parameter.name,e.parameter.targetID) } //get range data from sheet else if ( e.parameter.func == "getSheetRange" ) { return getSheetRangeData(e.parameter.sheetID,e.parameter.gridName,e.parameter.data); } //get data from sheet else if ( e.parameter.func == "getSheetData" ) { return getSheetData(e.parameter.sheetID,e.parameter.gridName); } //get grid names from sheet else if ( e.parameter.func == "gridList" ) { return getGridNames(e.parameter.sheetID); } //append row of data to specified sheet/grid else if ( e.parameter.func == "appendRowToSheet" ) { return appendRowToSheet(e.parameter.data,e.parameter.sheetID,e.parameter.gridName); } //add new grid to sheet else if ( e.parameter.func == "insertGrid" ) { return insertGridToSheet(e.parameter.name,e.parameter.sheetID); } //query sheet else if ( e.parameter.func == "queryData" ) { return queryData(e.parameter.sheetID,e.parameter.gridName,e.parameter.query); } //set data sheet else if ( e.parameter.func == "setDataToSheet" ) { return setDataToSheet(e.parameter.sheetID,e.parameter.gridName,e.parameter.data); } //set data to cell else if ( e.parameter.func == "setDataToCell" ) { return setDataToCell(e.parameter.sheetID,e.parameter.gridName,e.parameter.data,e.parameter.cellRef); } //set data to range else if ( e.parameter.func == "setDataToRange" ) { return setDataToRange(e.parameter.sheetID,e.parameter.gridName,e.parameter.data,e.parameter.a1Range); } //call utility property else if ( e.parameter.func == "utility" ) { return gdcutil(e.parameter.sheetID,e.parameter.gridName,e.parameter.call); } //return data in column else if ( e.parameter.func == "columnData" ) { return returnColumnData(e.parameter.sheetID,e.parameter.gridName,e.parameter.column); } //insert column with data else if ( e.parameter.func == "insertColumnData" ) { return insertColumnData(e.parameter.sheetID,e.parameter.gridName,e.parameter.column,e.parameter.data); } //delete column else if ( e.parameter.func == "deleteColumn" ) { return deleteColumn(e.parameter.sheetID,e.parameter.gridName,e.parameter.column); } //return data in row else if ( e.parameter.func == "rowData" ) { return returnRowData(e.parameter.sheetID,e.parameter.gridName,e.parameter.row); } //insert row with data else if ( e.parameter.func == "insertRowData" ) { return insertRowData(e.parameter.sheetID,e.parameter.gridName,e.parameter.row,e.parameter.data); } //delete row else if ( e.parameter.func == "deleteRow" ) { return deleteRow(e.parameter.sheetID,e.parameter.gridName,e.parameter.row); } //get named range data else if ( e.parameter.func == "getNamedRangeData" ) { return getDataNamedRange(e.parameter.sheetID, e.parameter.name); } //set named range else if ( e.parameter.func == "setNamedRange" ) { return setNamedRange(e.parameter.sheetID,e.parameter.gridName,e.parameter.a1Range,e.parameter.name); } } // ########## doGet End ############