Excel Add-In for Google Analytics

Build 24.0.9062

GetOAuthAuthorizationURL

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

Input

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

デフォルト値はhttps://www.googleapis.com/auth/analytics.readonlyです。

CallbackURL String False This field 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 forward slash ('/').
Prompt String True This field indicates the prompt to present the user. It accepts one of the following values: NONE, CONSENT, SELECT_ACCOUNT. The default is SELECT_ACCOUNT, so a given user is prompted to select the account to connect to. If it is set to CONSENT, the user sees a consent page every time, even if they have previously given consent to the application for a given set of scopes. Lastly, if it is set to NONE, no authentication or consent screens are displayed to the user.

デフォルト値はSELECT_ACCOUNTです。

AccessType String True This field 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 results in your application obtaining a refresh token the first time your application exchanges an authorization code for a user.

使用できる値は次のとおりです。ONLINE, OFFLINE

デフォルト値はOFFLINEです。

State String False This field indicates any state that 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. Possible uses include redirecting the user to the correct resource in your site, using nonces, and mitigating cross-site request forgery.

Result Set Columns

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062