qua_get_oauth_authorization_url_d365

Gets an authorization URL from the data source. The authorization URL can be used to generate a verifier required to obtain the OAuth token.

Beforehand, you may wish to register your own Azure application and use the procedure to obtain its own OAuth credentials.

Syntax

qua_get_oauth_authorization_url_d365
    [ @connection_name = ] 'connection_name'
  , [ @callback_url = ] 'callback_url'
  [ , [ @state = ] 'state' ]

Arguments

[ @connection_name ] - VARCHAR with an existing Dynamics 365 connection name; A value has to reference Dynamics 365 aware service which you are going to authorize your Azure application for.

[ @callback_url ] - VARCHAR; The URL the user will be redirected to after authorizing your application.

[ @state ] - NVARCHAR; this field indicates any state that may be useful to your application upon receipt of the response. Your application receives the same value it sent, as this parameter makes a round-trip to Dynamics authorization server and back. Uses include redirecting the user to the correct resource in your site, using nonces, and mitigating cross-site request forgery.

Result Sets

Column name Data type Description
URL varchar(2083) The authorization URL that will need to be opened for the user to authorize your app.

Permissions

By default, users with permission Control connection can execute this stored procedure.

Example

EXEC [qua_get_oauth_authorization_url_d365] 'QueronaDynamicsTechnical', 'http://localhost:33333', NULL;