6.7. Google Spreadsheet Resource Adapter Properties

Procedure 6.1. Obtaining an OAuth Refresh Token

1. Get an authorization code

   Click on the following link: Get Authorization Code
   Click on Allow access to allow the Teiid Google Connector to access the Google account in which the spreadsheet resides.

2. Obtain the refresh token

   Copy the authorization code from the previous step into the code field of the following POST request and run it from the command line:

   curl \--data-urlencode code=AUTH_CODE \
   --data-urlencode client_id=217138521084.apps.googleusercontent.com \
   --data-urlencode client_secret=gXQ6-lOkEjE1lVcz7giB4Poy \
   --data-urlencode redirect_uri=urn:ietf:wg:oauth:2.0:oob \
   --data-urlencode grant_type=authorization_code https://accounts.google.com/o/oauth2/token

   The refresh token will be in the response.