SSIS Components for Smartsheet

Build 25.0.9434

GetOAuthAuthorizationURL

Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.

To execute this stored procedure, you must specify at least the OAuthClientId connection property.

Additionally, you should also make sure the CallbackURL connection property or the 'CallbackUrl' input parameter matches with the 'App redirect URL' configured in your OAuth App Profile.

Input

Name Type Required Description
CallbackUrl String False The URL to which Smartsheet will redirect the user after they authorize your application. It must match the callback URL registered with your app.
Scope String False The specific permissions or actions that the app is requesting access to within the Smartsheet account, such as reading sheets or managing users.
State String False A unique value that maintains state between the request and callback. It can be used for request validation or to prevent cross-site request forgery (CSRF) attacks.

Result Set Columns

Name Type Description
URL String The authorization URL that the user must visit to grant the requested permissions and obtain an authorization code or verifier token for further API interactions.

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