SSIS Components for Google Sheets

Build 20.0.7587

GetOAuthAuthorizationURL

Obtains the OAuth authorization URL for authentication with various Google services.

Input

Name Type Description
Scope String The scope of access to Google APIs. By default, access to all APIs used by this data provider will be specified.

The default value is https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/spreadsheets.

CallbackURL String Determines where the response is sent. The value of this parameter must exactly match one of the values registered in the APIs Console (including the HTTP or HTTPS schemes, capitalization, and trailing '/').
Prompt String This field indicates the prompt to present the user. The default is CONSENT, so a given user will see a consent page every time, even if they have previously given consent to the application for a given set of scopes. If it is set to SELECT_ACCOUNT, the user will be prompted to select the account to connect to. Lastly, if it is set to NONE, no authentication or consent screens will be displayed to the user.

The allowed values are NONE, CONSENT, SELECT_ACCOUNT.

The default value is CONSENT.

AccessType String Indicates if your application needs to access a Google API when the user is not present at the browser. This parameter defaults to OFFLINE. If your application needs to refresh access tokens when the user is not present at the browser, then use OFFLINE. This will result in your application obtaining a refresh token the first time your application exchanges an authorization code for a user.

The allowed values are ONLINE, OFFLINE.

The default value is OFFLINE.

State String Indicates any state which may be useful to your application upon receipt of the response. Your application receives the same value it sent, as this parameter makes a round-trip to the Google authorization server and back. Uses include redirecting the user to the correct resource in your site, nonces, and cross-site-request-forgery mitigations.

Result Set Columns

Name Type Description
URL String The URL to complete user authentication.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587