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.


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


[ @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




The authorization URL that will need to be opened for the user to authorize your app.


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


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

See also#