GetOAuthAccessTokenCData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354
Obtains the OAuth access token to be used for authentication with various Google services.
|AuthMode||String|| The type of authentication mode to use.
The allowed values are APP, WEB.
The default value is WEB.
|Verifier||String||The verifier code returned by Google after permissions have been granted for the app to connect. WEB Authmode only.|
|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/bigquery.
|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, case, and trailing '/').|
|ApprovalPrompt||String|| Indicates if the user should be re-prompted for consent. The default is auto, so a given user should only see the consent page for a given set of scopes the first time through the sequence. If the value is force, then the user sees a consent page even if they have previously given consent to your application for a given set of scopes.
The allowed values are AUTO, FORCE.
The default value is AUTO.
|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. The Google Authorization Server roundtrips this parameter, so your application receives the same value it sent. Possible uses include redirecting the user to the correct resource in your site, nonces, and cross-site-request-forgery mitigations.|
Result Set Columns
|OAuthAccessToken||String||The authentication token returned from Google. This can be used in subsequent calls to other operations for this particular service.|
|OAuthRefreshToken||String||A token that may be used to obtain a new access token.|
|ExpiresIn||String||The remaining lifetime on the access token.|