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;