CODEWITHSUNDEEP
node.jsgoogle-apps-scriptgoogle-apps-script-api
Tri Nguyen
Tri Nguyen

Reputation: 11138

ScriptError using Google Apps Script Execution API

Following these guides https://developers.google.com/apps-script/guides/rest/quickstart/target-script and https://developers.google.com/apps-script/guides/rest/quickstart/nodejs, I am trying to use the Execution API in node to return some data that are in a Google Spreadsheet.

I have set the script ID to be the Project Key of the Apps Script file. I have also verified that running the function in the Script Editor works successfully.

However, when running the script locally with node, I get this error:

The API returned an error: Error: ScriptError

I have also made sure the script is associated with the project that I use to auth with Google APIs as well.

Does anyone have any suggestion on what I can do to debug/ fix this issue? The error is so generic that I am not sure where to look.

UPDATE: I've included a copy of the code in this JSBin (the year function is the entry point) https://jsbin.com/zanefitasi/edit?js

UPDATE 2: The error seems to be caused by the inclusion of this line var spreadsheet = SpreadsheetApp.open(DriveApp.getFileById(docID));

Upvotes: 0

Views: 1112

Answers (2)

Tri Nguyen
Tri Nguyen

Reputation: 11138

It seems that I didn't request the right scopes. The nodejs example include 'https://www.googleapis.com/auth/drive', but I also needed to include 'https://www.googleapis.com/auth/spreadsheets' in the SCOPES array. It seems like the error message ScriptError is not very informative here.

In order to find what scopes you'd need, to go the Script Editor > File > Project Properties > Scopes. Remember to delete the old credentials ~/.credentials/old-credential.json so that the script will request a new one.

Upvotes: 4

Spencer Easton
Spencer Easton

Reputation: 5782

EDIT: With the update in information I took a closer look and saw you are returning a non-basic type. Specifically you are returning a Sheet Object.

The basic types in Apps Script are similar to the basic types in JavaScript: strings, arrays, objects, numbers and booleans. The Execution API can only take and return values corresponding to these basic types -- more complex Apps Script objects (like a Document or Sheet) cannot be passed by the API.

https://developers.google.com/apps-script/guides/rest/api

In your Account "Class"

this.report = spreadsheet.getSheetByName(data.reportSheet);

old answer:

'data.business_exp' will be null in this context. You need to load the data from somewhere. Every time a script is called a new instance of the script is created. At the end of execution chain it will be destroyed. Any data stored as global objects will be lost. You need to save that data to a permanent location such as the script/user properties, and reloaded on each script execution.

https://developers.google.com/apps-script/reference/properties/

Upvotes: 0

Related Questions