Make an API With Google Sheets and Google Apps Script 

but when i deploy it with "only myself" it's working

I haven't heard of that one before, but I have tried similar services and they have rate limits and they're really slow

thanks

It's working for me.

just create another empty list and push the present list into it and return the new list and you are done ; )

yes, just replace doGet with doPost

Doc is undefined

PropertiesService.getScriptProperties().setProperty("key", doc.getId());

It was one of the builtin MacOS ones, but they got rid of it recently :(

@@cukmekerb Version please?

It’s still in mojave and maybe catalina

try saving it and redeploying. sometimes gas doesn't recognize a save

TypeError: Cannot read property 'getLastRow' of null (line 7, file "Code")

+1 Doesn't work

Did you get it to work?

What exactly does the error say?

You can do that with web app

and running the script, I got the message in terminal: "TypeError: Cannot read property 'parameter' of undefined"

the code: function doGet(request){ var query = request.parameter.q; var parameters = 2; var sheetname = "Sheet1"; var doc = SpreadsheetApp.openById(PropertiesService.getScriptProperties().getProperty("key")); var sheet = doc.getSheetByName(sheetname); var lastrow = sheet.getLastRow; var rows = []; var range = sheet.getRange(2, 1, lastrow, parameters); var values = range.getValues(); for(var row in values){ rows.push([]); for(var col in values[row]){ rows[row].push(values[row][col]); } } if(query != null){ var rowstoreturn = rows.filter(a => a[0] == query); return ContentService.createTextOutput(JSON.stringify({"date":rowstoreturn, "error":false})).setMimeType(ContentService.MimeType.JSON); } return ContentService.createTextOutput(JSON.stringify({"date":rows, "error":false})).setMimeType(ContentService.MimeType.JSON); } function setup(){ var doc = SpreadsheetApp.getActiveSpreadsheet(); PropertiesService.getScriptProperties().setProperty("key", doc.getId()); }

there are but they're very high

Hey, I just watched your animatronic tutorial, it was really cool! I don't know java, but python is a really great language that I wish I could cover more. If you have any ideas for a python video, lmk. Also, I just subscribed to your channel.

@@cukmekerb Hi i was not able to use this link in postman.. how can i do that..?

Same here

use parameters