Global Resource Properties

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

Connection Settings

Set global resource in the adapter properties, " Global Resource Settings" within the Control Panel.
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.  
Redirect URI Required Only environment variables are available Enter the redirect URI.
  • Specify the redirect URI registered to the service provider.
  • You need to register the following URI with the service provider.
    http(s)://<The host name of the OS on which DataSpiderServer runs>:<Port number>/dataspider/oauth_2_0
  • When using HTTPS, you need to enable HTTPS settings in DataSpiderServer.
  • For more details about settings, refer to "HTTPS setting".
Refresh token Required Only environment variables are available. Enter the refresh token of OAuth 2.0 authentication. The refresh token issued by [Issue Token] will be displayed.  
Property Action
Item name Description Remarks
Issue 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

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

Security

Security setting is available from "Global Resource Settings" in control panel.

Main exceptions

Exception name Causes Solution
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify the [<Property name>].
AuthorizationException
<Detailed information...>		 Failed in authentication/authorization. Check [Client ID] or [Client secret].
Check the application authentication information settings on Google Cloud Platform.
TokenException
Token could not be obtained. <Detailed information...>		 Failed to do Token Request. Check the Authorization Code obtained in "Authorization Code Setup" dialog.
TokenException
Token could not be updated. <Detailed information...>		 Failed to do Refresh Request. Check [Issue Token] again.
com.google.api.client.auth.oauth2.TokenResponseException
401 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 [Issue Token] again.
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. Check [Issue Token] again.