function doGet(e) { var p = e.parameter; var response = getData(p.document,p.from,p.query,p.where,p.is,p.isnot,p.and,p.or,p.equal,p.order,p.values); return ContentService.createTextOutput(response).setMimeType(ContentService.MimeType.JSON); } function getData(document,from,query,where,is,isnot,and,or,equal,order,values){ if(document == undefined) { var doc = SpreadsheetApp.getActive(); } else { var doc = SpreadsheetApp.openById(document); } if(from == undefined) { var sheet = doc.getSheets()[0]; } else { var sheet = doc.getSheetByName(from); } var numColumns = sheet.getLastColumn(); var fields = sheet.getRange(1,1,1,numColumns).getValues(); var data = []; var numRegs = sheet.getLastRow() - 1; if(numRegs > 0){ data = sheet.getRange(2,1,numRegs,numColumns).getValues(); } var numField1,numField2,numOrder; for(var i=0;i0) { response+= ','; } response+='{'; for(var j=0;j