Global Resource Properties

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

Connection Settings

Set global resource in the adapter properties, " Global Resource Settings" within the Control Panel.

Item name	Required/Optional	Use of Variables	Description	Remarks
Name	Required	Not available	Enter the name of the connection setting.

Item name	Required/Optional	Use of Variables	Description
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 the refresh token of OAuth 2.0 authentication. The refresh token issued by [Publish refresh token] will be displayed.

Item name	Description	Remarks
Publish refresh token	Start the "Authorization Code Setup" dialog. When you perform the settings after retrieving the authentication code, [Refresh token] will be issued.
Connection Test	Checks connection to Google Sheets.	If succeeded, it shows the authentication user information for a refresh token.

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

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

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 Cloud Platform.	Check application authentication information setting on Google Cloud Platform.
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].