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 9. Drive and DriveApp
Native Office and Docs files are accessed by services specifically for that purpose from within both VBA and Apps Script. There are times that you may need to access other kinds of files directly from your Apps Script or VBA application. With VBA, you can access the local client machine’s filesystem to read and write supplementary files generated within the Office app.
Apps Script runs on Google servers so does not have access to the local client machine. Instead, these kinds of operations can be performed on Google Drive. However, if Drive client synchronization is enabled, reading and writing to Drive is essentially “accessing the client by proxy,” as any files written to Drive are copied to the client and vice versa.
Drive can be accessed in three ways from Apps Script, as outlined in Table 9-1.
| Interface | Description |
|---|---|
| DriveApp (Apps Script built-in service) | A simplified service for accessing the most commonly used capabilities through simple data structures |
| Drive (Apps Script advanced Google service) | Enables access to most of the Drive API capabilities, using the default (fairly complex) data structures. |
| Drive JSON API | Rest API to all of the Drive API features accessible via UrlFetchApp. OAuth 2.0 authentication required. |
Microsoft OneDrive
OneDrive is similar to Drive, has a JSON API, and uses OAuth 2.0 for authentication. You can access OneDrive from Apps Script using
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.