scriptDB API for JavaScript

Here’s a slideshare primer

JavaScript client API for Google Apps Script API primer from Bruce McPherson

Before I start, I have to mention a couple of compromises for this initial version.

• oAuth2 is not implemented (it is in VBA). This is because Google Apps Script (which handles the scriptDB requests) cannot handle cross domain requests unless the webapp is public facing. See this blogpost for more detail. This is a problem for now, but I will update when I find a workaround.
• I have only tested on FireFox and Chrome. It may not work on various IE. Maybe I’ll get round to dealing with that at some point.
• Big volumes will probably hit Google Apps Script quota issues, although I do use batching, skipping and limits to try to contain this.
• I’m using jQuery, and everything is orchestrated with jQuery promises.

Asynchronicity

Implementing this is javaScript has been much more complicated than in VBA, mainly because everything is being done asynchronously using aJax. Combining batching with asynchronicty has been tricky.  I’m using promises to bring it under some semblance of control.

Some more detail on this topic

• scriptDb JavaScript api examples
• Authenticating scriptDb JavaScript API
• Creating your own scriptDB environment – this is actually how to set up the handler for A VBA API for scriptDB, but since they use the same one, the process is exactly the same.
• scriptdbcom implementation
• testing the API