Please search through existing issues first to ensure that the bug has
not already been reported.

Please provide a short description of the issue:

It seems that Execution API doesn't work with Service Account Oauth. Is this by design? if so the reported error behavior is very strange.

The token seems to be valid and properly scoped, since I don't get a 401 error.
I get two kinds of errors

- this one if I include parameters.. (there's nothing wrong with the parameters - i get the same error regardless of what i use for parameter types..

{
"error": {
"code": 400,
"message": "Invalid JSON payload received. Unknown name \"parameters\": Cannot bind query parameter. 'parameters' is a message type. Parameters can only be bound to primitive types.",
"status": "INVALID_ARGUMENT",
"details": [
{
"@type": "type.googleapis.com/google.rpc.BadRequest",
"fieldViolations": [
{
"description": "Invalid JSON payload received. Unknown name \"parameters\": Cannot bind query parameter. 'parameters' is a message type. Parameters can only be bound to primitive types."
}
]
}
]
}

And this one if I don't include parameters.

[15-10-23 10:51:27:191 BST] {
"error": {
"code": 404,
"message": "Requested entity was not found.",
"status": "NOT_FOUND"
}
}

The target script is published as an API executable, and works ok when I use a regular OAUTH2 token from a server application.

Please provide a small sample script that reliably reproduces the issue.
The sample should run as-is or with minimal setup, without external
dependencies.

The code is a little large to reproduce here since it contains code to create service account token as well.

It can be found here
https://script.google.com/a/mcpher.com/d/1PqmDSzGO6DwhxwAJWyq8xDmiiAbOTse2KoB4MCoziAtrIpYnEdmHhI1K/edit?usp=drive_web

What steps will reproduce the problem?
1. get a service account and download the json
2. change the fileid to the service account drive file
3. run testexecutionAPI

What is the expected output? What do you see instead?
errors as above...

What is the project key (found under "File > Project properties")? The
project key does not give the Apps Script team access to your source
code or data. We use it to look up debug information about your script.

M-dipVp-nmaoC2XRYyy9nIiz3TLx7pV4j

Please provide any additional information below.

The payload seems valid -- with parameters
UrlFetchApp.fetch([https://script.googleapis.com/v1/scripts/M9Bz3CpKhkwFxMs-wGDnwWSz3TLx7pV4j:run, {headers={authorization=Bearer ya29.FQK-iB8gKiQ2Oh6Fvdr54b-6HNtVNzPPWn4fu3i-uZglT0cw39s8j0WTwC62LW3EnbXfcA}, method=POST, payload={devMode=true, function=trythis, parameters=[{sheetName=lookup, id=1f4zuZZv2NiLuYSGB5j4ENFc6wEWOmaEdCoHNuv-gHXo}]}, muteHttpExceptions=true}])

without parameters ---

UrlFetchApp.fetch([https://script.googleapis.com/v1/scripts/M9Bz3CpKhkwFxMs-wGDnwWSz3TLx7pV4j:run, {headers={authorization=Bearer ya29.FQLqpdXD_BVAKLFr6GOeCG9hVgS5cciV7Q6NuieeqKTj9Q-LMsoJpVCyGLIKMmqctD_wzQ}, method=POST, payload={devMode=true, function=trythis}, muteHttpExceptions=true}])

To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.

Issue 36763096

Mentioned issues (7)

Links (24)

Issue metadata