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.
The default value is 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. |