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.
qua_get_oauth_authorization_url_d365 [ @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.
|Column name||Data type||Description|
|URL||varchar(2083)||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;