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;