Excel Add-In for Microsoft SharePoint

Build 24.0.9175

GetOAuthAccessToken

Acquires the OAuth access token from SharePoint.

Input

Name Type Required Description
AuthMode String False The type of authentication mode to use. The allowed values are APP, WEB.
Verifier String False The verifier token returned by SharePoint after using the URL obtained with GetOAuthAuthorizationURL. Required for only the Web AuthMode.
CallbackUrl String False The URL the user is redirected to after authorizing your application.
Scope String False The scope or permissions you are requesting from the user.
State String False Any value that you wish to be sent with the callback.
Prompt String False Defaults to 'select_account', which prompts the user to select an account while authenticating. Set to 'None', for no prompt, 'login' to force user to enter their credentials, or 'consent' to trigger the OAuth consent dialog after the user signs in. The consent dialog asks the user to grant permissions to the app.

Result Set Columns

Name Type Description
OAuthAccessToken String The authentication token returned from SharePoint.
OAuthRefreshToken String A token that you can use to obtain a new access token.
ExpiresIn String The remaining lifetime for the access token in seconds.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175