With a couple of clicks, Appscript gives you a webserver including https certificate: for free!
Seriously? Does that mean I can push json-data into a spreadsheet (using appscript)?
Yes! Just make sure you’ll follow the CORS / authentication-logic below.
Not interested in CORS / authentication, but still curious about appscript? Read how to teach yourself appscript here
CORS caveats
Before you do your happy-dance (which you should), please understand appscript + CORS comes with a few exceptions:
- GET requests: mostly yes
- POST request: it depends
- PUT/DELETE/OPTIONS: nope
Depends on what? Authentication and additional url-slug..
https://script.google.com/macros/s/...../exec was assumed as the appscript-url
Getting started with JSON
function doGet(request) {
var result = {foo:"bar"}
return ContentService.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON);
}
NOTE: for other mimetypes see here
Check Gexpress for a more simpler, express-style way of writing endpoints.
Banner 101
In order to get rid of the (not made by google) banner, you can try 2 things:
- create a google site and include the script
- include the script as an iframe on another domain (host on gitlab/github/bitbucket page e.g.)
DISCLAIMER: the author hasn’t tested this recently.