Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Comments on Problems with Google Apps Script API JavaScript "How to... Execute function"
Post
Problems with Google Apps Script API JavaScript "How to... Execute function"
As this is the first question about Google Apps Script, here is a very brief description: it is a platform that helps people easily get programmatic access to Google apps data like Gmail messages, Google Drive files, etc. and also to certain elements that can't be accessed through one of the Google APIs. It offers a web-based IDE and has its own API.
The Google Apps Script API docs include a quickstart section, having subsections for different languages / platforms including JavaScript.
I thoroughly reviewed the quickstart overview and the JavaScript subsection and got it to work, but when trying the "How too... Execute a function" I got stuck; more specifically, I'm getting 404 errors.
References:
- Google Apps Script REST API overview page: https://developers.google.com/apps-script/api/concepts.
- JavaScript quickstart instructions: https://developers.google.com/apps-script/api/quickstart/js
- The How To... Execute a function: https://developers.google.com/apps-script/api/quickstart/target-script
This is my environment:
- Google Workspace account. I'm the domain administrator.
- New Google Cloud project, created following the quickstart instructions
- New Google Apps Script project, created using the quickstart instructions
Hardware and Installed Software
- Mac Mini Apple M1, MacOS Ventura 13.4.1.
- Google Chrome
- Visual Studio Code
Steps to reproduce the problem
- Read the links included above.
- Create the target script.
- Create the file from the JavaScript quickstart. Default name
index.html
. - Create the file from the How to... Execute function. Default name index.js
- Modify
index.html
to loadindex.js
. - Modify
index.html
in such a way that instead of callingcreateScript()
callcallScriptFunction()
. - Create the Google Cloud standard project.
- Enable the Apps Script API.
- In the API section of the Cloud project, go to credentials.
- Add the ApiKey. Take note of it.
- Add the Web client
- Add the allowed URI. If you will run this locally add
http://localhost:8080
. - Create the OAuth consent screen
- Grab the Google Cloud project id and add it to the Google Apps Script project on Project settings.
- Deploy Google Apps Script as API executable
- Get the script Id.
- Add the ApiKey, Client Id to the
index.html
file. - Add the script Id to the
index.js
file. - Open
index.html
using Google Chrome. - Click the button Authorize and follow the OAuth authorization flow.
- Open the Google Chrome DevTools Console.
Here you will find the error message.
1 comment thread