February 2016
Beginner to intermediate
456 pages
9h 18m
English
Content preview from Going GAS
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 17. Execution API
The Execution API is a brand-new API that enables you to run Apps Script functions from other processes via JSON REST requests, or by using a library specific to your development language. It is unusual among Apps Script–related APIs in that it is not intended to be run from Apps Script (although it can be—for example, to enable splitting and parallel execution of workloads), but rather to provide access to Apps Script capabilities from other platforms.
I’m very impressed by the potential of the Execution API, and have eagerly anticipated its release. There are libraries, quickstarts, and developer tools available for a number of platforms, as well as the REST API, on which the VBA integration solution introduced in this chapter is based.
The Execution API has some similarity to google.script.run, whose function is to enable add-on/ HtmlService communication between client and server. This capability will greatly enhance the ability of mobile-based apps and add-ons to access Apps Script functionality.
Although probably not the purpose for which it was envisioned, the Execution API is also a powerful tool to enable incremental migration from Office (or anything else) to Apps, and this chapter will concentrate on the process and code needed.
As with all the code examples, you should adapt and enhance the error handling to match your house requirements if you choose to use any of it in your projects. Note that the provided VBA libraries are primarily focused ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.