SSIS Components for Smartsheet

Build 24.0.9062

GetOAuthAuthorizationURL

Gets the Smartsheet authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to Smartsheet.

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 that Smartsheet will return to after the user has authorized your app.
Scope String False The scope or permissions you are requesting.

デフォルト値はREAD_SHEETS READ_USERS READ_CONTACTS WRITE_SHEETS ADMIN_SHEETS CREATE_SHEETS DELETE_SHEETSです。

State String False The same value for state that you sent when you requested the authorization code.

Result Set Columns

Name Type Description
URL String The URL to be entered into a Web browser to obtain the verifier token and authorize the data provider with.

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