IllegalArgumentException being thrown when trying to authenticate with google sheets api #93

Activity

1. sqrrrl commented on Dec 3, 2019

   

   sqrrrl

   on Dec 3, 2019

   Member

   More actions

   Check your client secrets file to make sure it's correct. Possible that you downloaded credentials in the wrong form.

   That error indicates it's not in the expected format as isn't either for a server-side web app or installed (desktop) app. Corresponding code: https://github.com/googleapis/google-api-java-client/blob/master/google-api-client/src/main/java/com/google/api/client/googleapis/auth/oauth2/GoogleClientSecrets.java
2. sqrrrl

   self-assigned this

   on Dec 3, 2019
3. sqrrrl commented on Jan 21, 2020

   

   sqrrrl

   on Jan 21, 2020

   Member

   More actions

   Ping @aeslami3574 -- please verify your credentials are the correct type. Otherwise will close issue as not reproducible.
4. cdolek commented on Oct 15, 2020

   

   cdolek

   on Oct 15, 2020

   Last edited by cdolek

   More actions

   I had the same issue using the wrong credentials.json I have downloaded for a service account, created to access google sheets from a web application. I was banging my head until I discovered that I needed an OAuth credentials, set "Web Application" as application type json file that has been downloaded from google cloud console.

   My credentials file should looks like this:

   {
   	"web": {
   		"client_id": String,
   		"project_id": String,
   		"auth_uri": String,
   		"token_uri": String,
   		"auth_provider_x509_cert_url": String,
   		"client_secret": String
   	}
   }
   

   ❤️React with ❤️1Reacted by Rafael Luz
5. Johnny850807 commented on Apr 9, 2022

   

   Johnny850807

   on Apr 9, 2022

   Last edited by Johnny850807

   More actions

   My workaround: Don't use the client secrets, instead, directly build the credentials.

   Import this library

   <dependency>
           <groupId>com.google.auth</groupId>
           <artifactId>google-auth-library-oauth2-http</artifactId>
           <version>1.3.0</version>
   </dependency>

   InputStream in = SheetsQuickstart.class.getResourceAsStream(CREDENTIALS_FILE_PATH);
   if (in == null) {
           throw new FileNotFoundException("Resource not found: " + CREDENTIALS_FILE_PATH);
   }
   GoogleCredentials googleCredentials = GoogleCredentials.fromStream(in).createScoped(SCOPES);
   
   Sheets service = new Sheets.Builder(HTTP_TRANSPORT, JSON_FACTORY, new HttpCredentialsAdapter(googleCredentials))
                   .setApplicationName(APPLICATION_NAME)
                   .build();

   👍React with 👍11Reacted by Le Gall Benoit, Wee Hong, 전지환, khoahoang88, Leo Yang, Mikhail Kiselev, jhnct, Abdul Wahab Zahid, Alex Kott, HongtaiDu and 1 more

   ❤️React with ❤️5Reacted by 전지환, Javier Angel, Abdul Wahab Zahid, Alex Kott and lavaloop-official
6. weehong-1 commented on Jul 11, 2022

   

   weehong-1

   on Jul 11, 2022

   Last edited by weehong-1

   More actions

   My workaround: Don't use the client secrets, instead, directly build the credentials.

   Import this library

   <dependency>
           <groupId>com.google.auth</groupId>
           <artifactId>google-auth-library-oauth2-http</artifactId>
           <version>1.3.0</version>
   </dependency>
   

   InputStream in = SheetsQuickstart.class.getResourceAsStream(CREDENTIALS_FILE_PATH);
   if (in == null) {
           throw new FileNotFoundException("Resource not found: " + CREDENTIALS_FILE_PATH);
   }
   GoogleCredentials googleCredentials = GoogleCredentials.fromStream(in).createScoped(SCOPES);
   
   Sheets service = new Sheets.Builder(HTTP_TRANSPORT, JSON_FACTORY, new HttpCredentialsAdapter(googleCredentials))
                   .setApplicationName(APPLICATION_NAME)
                   .build();

   This is the most accurate answer until today.
   Hopefully, more developers can see this.

   👍React with 👍1Reacted by HongtaiDu
7. velikanov commented on Sep 15, 2022

   

   velikanov

   on Sep 15, 2022

   More actions

   My workaround: Don't use the client secrets, instead, directly build the credentials.

   Import this library

   <dependency>
           <groupId>com.google.auth</groupId>
           <artifactId>google-auth-library-oauth2-http</artifactId>
           <version>1.3.0</version>
   </dependency>
   

   InputStream in = SheetsQuickstart.class.getResourceAsStream(CREDENTIALS_FILE_PATH);
   if (in == null) {
           throw new FileNotFoundException("Resource not found: " + CREDENTIALS_FILE_PATH);
   }
   GoogleCredentials googleCredentials = GoogleCredentials.fromStream(in).createScoped(SCOPES);
   
   Sheets service = new Sheets.Builder(HTTP_TRANSPORT, JSON_FACTORY, new HttpCredentialsAdapter(googleCredentials))
                   .setApplicationName(APPLICATION_NAME)
                   .build();

   Works like a charm!
   If you see this - use this

   THANK YOU @Johnny850807
   Hey @google come on, update your docs!