CODEWITHSUNDEEP
javagoogle-apps-scriptgoogle-api
Luana Clarice
Luana Clarice

Reputation: 21

How to create a Google Form using Google Apps Script Execution API + Java?

I tried a simple Java command-line application that makes requests to the Google Apps Script Execution API. Something like this: https://developers.google.com/apps-script/guides/rest/quickstart/java#prerequisites. But it doesn't work.

Google Apps Script Editor:

function createForm() {

  var form = FormApp.create('New Form');

}

Java Error:

Credentials saved to /home/palmaslab/.credentials/script-java-quickstart.json
com.google.api.client.googleapis.json.GoogleJsonResponseException: 401 Unauthorized
        at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:145)
        at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
        at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
        at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:321)
        at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1056)
        at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:419)
        at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:352)
        at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:469)
        at org.gradle.AppsScriptApiQuickstart.main(AppsScriptApiQuickstart.java:188)

Upvotes: 1

Views: 1176

Answers (2)

Alberto Crespo
Alberto Crespo

Reputation: 2519

Seems you have to authorize previously the scopes. Maybe it could help you: Manual authorization scopes for Sheets, Docs, and Forms

Upvotes: 0

Android Enthusiast
Android Enthusiast

Reputation: 4960

API returning an HTTP 401 response when calling the API. These error could indicate any of:

Token expiry, token revocation, token not authorized for needed scope, request not authorized correctly with OAuth 2.0 protocol. You may also check Forms Service for more information regarding forms services

Here's a related issue of 401: Unauthorized: Google apps script and execution API: latest version of script throws error

Upvotes: 1

Related Questions