Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Google Sheets Connector
  3. Google Sheets connections
  4. Synchronization tasks with Google Sheets Connector
  5. Mappings and mapping tasks with Google Sheets Connector
  6. Appendix A: Data type reference

Google Sheets Connector

Google Sheets Connector

Back Next

Generating OAuth 2.0 access tokens

Generating OAuth 2.0 access tokens

Google Sheets Connector uses OAuth 2.0 protocol to connect to Google Sheets. After you generate the client ID and client secret for your project, you must generate the OAuth 2.0 access tokens.

Step 1. Generate the authorization code

You must generate the authorization code to gain access to the current site and to generate a valid refresh token.
Perform the following steps to generate the authorization code:
  1. Enter the following URL in the Google chrome browser:
    https://accounts.google.com/o/oauth2/auth? access_type=offline&approval_prompt=auto&client_id=<client_id>&response_type=code&scope=https://www.googleapis.com/auth/spreadsheets&redirect_uri=<redirect_uri>
    For example,
    https://accounts.google.com/o/oauth2/auth?acess_type=offline&approval_prompt=auto&client_id=1234-abc54dfa6.apps.googleusercontent.com&response_type=code&scope=https://www.googleapis.com/auth/spreadsheets&redirect_uri=http://localhost
  2. Choose the Google Account for which you want to approve the access request.
  4. Click
    Allow
     to grant the permission to see, edit, create, and delete your spreadsheets in Google Drive. Click
    Allow
     to confirm.
    The redirect URL page includes the authorization code as a query string in the following format:
    https://<redirect_url>/?code=<authcode>&scope=https://www.googleapis.com/auth/spreadsheets
    The following image shows the authorization code as a query string in the URI:
    The image shows the authoization code as a query string in the URI.
  5. Copy the authorization code displayed in the URL.

Step 2. Generate the refresh token and access token

Google Sheets Connector uses a authorization code to generate an access token and a refresh token. Google Sheets Connector uses an access token to authorize and access Google Sheets. The access token expires after a period of time. When the access token expires, you can use the refresh token to generate a new access token.
Perform the following steps to generate the refresh token:
  1. Enter the following URL in the Postman application:
    https://accounts.google.com/o/oauth2/token
  2. Select the
    POST
     method.
  3. On the
    Body
     tab, select the
    x-www-form-urlencoded
     body type.
  4. On the
    Body
     tab, add the following key-value pairs:
    Key
    Value
    grant_type
    Enter
    authorization_code
    .
    code
    Enter the authorization code that you generated in step 1.
    client_id
    The client_id value present in the JSON file.
    client_secret
    The client_secret value present in the JSON file.
    redirect_uri
    The redirect_uri value present in the JSON file.
    For example,
    http://localhost
    .
    The following image shows the
    Body
     tab where you can add the key-value pairs to generate the refresh token:
    The image shows the key-value pairs to generate a refresh token and access token in the Body tab.
  5. Click
    Send
    .
    The refresh token and access token is generated in the
    Response
     tab. The following image shows the refresh_token and access_token in the
    Response
     tab:
    The following image shows the refresh_token and access_token in the Response tab.
    Refresh token is generated only when you set the
    access_type
     parameter to
    offline
     in the initial request to obtain the authorization code. The
    expires_in
     field specifies the remaining time period of the access token in seconds.
  6. Save the refresh token and access token in a secured location.

Step 3. Refreshing an access token

When the access token expires, you can use the refresh token to generate a new access token.
Perform the following steps to generate the access token:
  1. Enter the following URL in the Postman application:
    https://accounts.google.com/o/oauth2/token
  2. Select the
    POST
     method.
  3. On the
    Body
     tab, select the
    x-www-form-urlencoded
     body type.
  4. On the
    Body
     tab, add the following key-value pairs:
    Key
    Value
    grant_type
    Enter
    authorization_code
    .
    client_id
    The client_id value present in the JSON file.
    client_secret
    The client_secret value present in the JSON file.
    refresh_token
    The refresh token that you generated in step 2.
    The following image shows the
    Body
     tab where you can add the key-value pairs to generate a new access token:
    The image shows the key-value pairs to generate a new access token in the Body tab.
  5. Click
    Send
    .
    The new access token is generated in the
    Response
     tab. The following image shows the new access token in the
    Response
     tab:
    The image shows the new access token in the Response tab.
0 COMMENTS
We’d like to hear from you!