Global Resource Properties

For details on OAuth 2.0 connection setting, refer to "Google Apps Adapter OAuth 2.0 Connection Setting Guide".

Connection Settings

Set global resource in the adapter properties, " Global Resource Settings" within the Control Panel, or in WebConsole.
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name of the connection setting.
  
Required settings
Item name Required/Optional Use of Variables Description Remarks
Client ID Required Only environment variables are available. Enter OAuth 2.0 Client ID for Authentication.  
Client secret Required Only environment variables are available. Enter OAuth 2.0 Client secret for Authentication.  
Refresh token Required Only environment variables are available. Enter OAuth 2.0 Refresh token for Authentication.  
Property Action
Item name Description Remarks
Publish refresh token Connect to Google Sheets and publish refresh token.
  • Not supported in WebConsole.
Connection Test Checks connection to Google Sheets.
  • If succeeded, it shows the authentication user information for a refresh token.

Component pool settings

Component pool settings can be managed from "Global Resource Settings" within Control Panel.

Security

Security Settings can be managed from "Global Resource Settings" within Control Panel or from WebConsole.

Main exceptions

Exception name Causes Solution
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify the [<Property name>].
OAuth2ProblemException
invalid_client		 [Issue refresh token...] operation failed due to existence of failure in the specified [Client secret]. Check [Client secret].
org.apache.oltu.oauth2.common.exception.OAuthRuntimeException
Unauthorized		 Failure exist in [Client ID] or [Client secret]. Check [Client ID] or [Client secret].
Application authentication information is edited by the operation of application administrator on Google Developers Console. Check application authentication information setting on Google Developers Console.
com.google.api.client.auth.oauth2.TokenResponseException
400 Bad Request { "error" : "invalid_grant" }		 Failure exist in [Refresh token]. Check [Refresh token].
com.google.api.client.auth.oauth2.TokenResponseException
400 Bad Request { "error" : "invalid_grant", "error_description" : "Token has been revoked." }		 Application access right was undone by the user operation of service provider side. Perform OAuth 2.0 authentication again, and set the newly issued token to [Refresh token].