SSIS Components for Microsoft SharePoint

Build 25.0.9434

GetOAuthAuthorizationURL

Generates the SharePoint authorization URL needed for OAuth authentication. Helps users grant permissions to third-party applications.

Input

Name Type Required Description
CallbackUrl String True The URL where SharePoint will redirect the user after they have authorized your application. This must match the Reply URL configured in the SharePoint/Azure AD app settings.
Scope String False The permissions requested from the user. Defines the level of access the application will have after authentication.

The default value is AllSites.Manage.

State String False A custom value sent with the callback to maintain session state and prevent cross-site request forgery (CSRF) attacks.
Prompt String False Determines how the authentication prompt is displayed. Defaults to 'select_account' (prompts the user to select an account). Other options: 'None' (no prompt), 'login' (forces the user to enter credentials), and 'consent' (displays the OAuth consent dialog for granting permissions).

Result Set Columns

Name Type Description
URL String The generated authorization URL that must be entered into a web browser. This URL allows the user to obtain the verifier token and authorize the application to access SharePoint.

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