SSIS Components for Microsoft Dynamics 365

Build 24.0.9175

GetOAuthAccessToken

Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Dynamics 365.

Input

Name Type Required Description
AuthMode String False Specifies the type of authentication being used. Use 'App' for Windows applications or 'Web' for web-based applications.

The default value is APP.

Verifier String False The verifier token returned by the service, required to obtain the access token. This is needed only when using the 'Web' authentication mode and is obtained by navigating to the URL provided by the GetOAuthAuthorizationUrl function.
CallbackUrl String False The URL to which the user is redirected after authorizing your application. This must match the Reply URL configured in the application's Azure AD settings.
State String False A value used to maintain application state between the authorization request and response. This value is echoed back by the Dynamics authorization server and can be used for purposes such as resource redirection, nonce generation, and cross-site request forgery mitigation.
Prompt String False Determines the behavior of the authentication prompt. Defaults to 'select_account' to prompt the user to select an account. Use 'None' for no prompt, 'login' to force credential entry, or 'consent' to trigger the OAuth consent dialog for granting permissions.

Result Set Columns

Name Type Description
OAuthAccessToken String The OAuth Access Token issued upon successful authentication. This token is used to access protected resources.
OAuthRefreshToken String An OAuth Refresh Token that can be used to obtain a new access token without requiring the user to reauthenticate.
ExpiresIn String The duration, in seconds, for which the access token is valid before it expires.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175