CODEWITHSUNDEEP
google-apps-scriptgoogle-cloud-platformpostmanhttp-status-code-403google-apps-script-api
Jaden Ranzenberger
Jaden Ranzenberger

Reputation: 69

Making a request to the Google Apps Script API through postman

I am attempting to remotely execute a google apps script function using the apps script api through a postman request.

I first get credentials from the Google API Playground

Then they are inputted into postman as OAuth2 credentials, and inputted in the headers like this: enter image description here

Then the appropriate link is requested: enter image description here

Then the body prepared: enter image description here

And then the response after making the request: enter image description here

Postman is returning an error 403, which, according to Google's documentation

indicates that "the Cloud Platform project used to authorize the request is not the same as the one used by the script." An error 403 is an authorization error and can mean many things, but let's assume that the error is what google proclaims it to be.

I have full control over the GCP project utilized by my script, but I'm not aware of where to find the project that was used to authorize the request.

Where might I gain access to this GCP project so I can assign my script to this project, thereby eliminating the 403 error?

Thanks!

Upvotes: 2

Views: 2854

Answers (2)

St3ph
St3ph

Reputation: 2290

To query a Google URL using a valid Access token with Postman you can log the access token from apps script and use it after.

In your apps script after validating scope, i.e. running a first time the script, log the token :

function logToken(){
  Logger.log(ScriptApp.getOAuthToken());
}

Then in Postman query the Google URL by setting in the header the access token :

"Authorization": "Bearer THE_ACCESS_TOKEN"

Security warning : for security reason I have to tell you that an access token is valid 1 hour so technically if you grant full drive scope to your app with this access token we can browse all your Drive.

Upvotes: 1

John Hanley
John Hanley

Reputation: 81336

To use OAuth Access Tokens from the OAuth Playground with Apps Script, you need to specify the correct Client ID and Client Secret from the same project.

In the OAuth Playground. Click on the gear icon (top right). Select "Use your own OAuth credentials". Then enter the Client ID and Secret ID created in the same project as Apps Script.

Upvotes: 4

Related Questions