Access Token

Gist

Overview

This GAS sample is for retrieving access token to use OneDrive APIs using Google Apps Script.

In this script, the authorization code is automatically retrieved.

Demo

Usage

In order to use this, both accounts of Google and OneDrive (MSN) are required.

Google side

1. Copy and paste the sample script to your script editor. You can use the standalone script for this.
2. Deploy Web Apps.
   • On the Script Editor
     • File
     • -> Manage Versions
     • -> Save New Version
     • Publish
     • -> Deploy as Web App
     • -> At Execute the app as, select “your account”
     • -> At Who has access to the app, select “Only myself”
     • -> Click “Deploy”
     • -> Copy URL of “latest code” (This is important!)
     • -> Click “OK”
3. URL of “latest code” is https://script.google.com/macros/s/###/dev. So please modify this URL. Replace from “dev” to “usercallback” for the URL. And copy this modified URL.
   • From : https://script.google.com/macros/s/###/dev
   • To : https://script.google.com/macros/s/###/usercallback

OneDrive side

1. Log in to Microsoft Azure portal.
2. Search “Azure Active Directory” at the top of text input box. And open “Azure Active Directory”.
3. Click “App registrations” at the left side bar.
   • In my environment, when I used Chrome as the browser, no response occurred. So in that case, I used Microsoft Edge.
4. Click “New registration”
   1. app name: “sample app name”
   2. Supported account types: “Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts (e.g. Skype, Xbox)”
   3. Redirect URI (optional): Web
      • URL: https://script.google.com/macros/s/###/usercallback
   4. Click “Register”
5. Copy “Application (client) ID”.
6. Click “Certificates & secrets” at the left side bar.
   1. Click “New client secrets”.
   2. After input the description and select “expire”, click “Add” button.
   3. Copy the created secret value.

By above operation, the preparation is done.