Connecting to Dynamics 365 Business Central using an OAuth Token

Published: Sep 21, 2021

Connecting to Dynamics 365 Business Central using an OAuth Token

Published: Sep 21, 2021

If your Dynamics 365 Business Central tenant is setup to authenticate with OAuth, follow the steps below to setup an OAuth token.

Setting up the application in Azure:

  1. Navigate to portal.azure.com
  2. Search for App registrations in the top search bar and select App registrations.
  3. Click New Registration and enter a name for the application.
  4. Choose the appropriate Supported Account Type, most companies will use “Accounts in this organizational directory only”.
  5. For the Redirect URI, choose Web and enter the correct URL based on deployment/region.
    • This is specific to your SmartConnect region, so it will vary slightly depending on that.  When setting up an Oauth Business Central connection, the redirect URL will be displayed in the connection window.
  6. Click Register.
  7. Click “Certificates & secrets” in the navigation on the left.
  8. Click “New client secret”.
  9. Give the secret a description and choose how long you want the secret to last.  It is important to note that when the secret expires any connections using this secret will no longer connect successfully until a new secret is generated and used in the connection. Make sure to have a process in place for someone to create another secret and update any SmartConnect connections prior to the secret expiring in the future.
  10. Click Add to generate the new secret. Copy and save the Value somewhere as it will not be fully visible again once you navigate away from the Azure Portal.
  11. Click on “API Permission” in the navigation bar on the left.
  12. Click “Add a permission” and choose Dynamics 365 Business Central.
  13. Select Delegated permission if it is not already and enable user_impersonation and Financials.ReadWrite.All and click Add permissions.
  14. Click on Overview in the navigation bar on the left.
  15. Copy and save the “Application (client) ID” value.
  16. With the Application ID and the Secret Value copied and saved from the application setup, the BC connection in SmartConnect can now be configured.

Setting up the connector in SmartConnect:

  1. Login to login.smartconnect.com if not already.
  2. Navigate to Connections and click the Create Connection button (or edit an existing BC connection).
  3. Select Dynamics 365 Business Central OData.
  4. Enter a description for the connector and check the “Use OAuth to Connect” option.
    • Note: The “Allow Long Timeout” and “Allow Retry of Failed Requests” options can also be checked, those options refer to enabling additional functionality within integrations using this connection.
  5. Enter your Service URL – this will be the base URL for OData services up to the /ODataV4/ portion of the URL (ie. https://api.businesscentral.dynamics.com/v2.0/<tenant-guid-here>/Production/ODataV4/). Your tenant GUID will be unique for each BC tenant/instance.
  6. The Tenant ID field should pull the GUID from the Service URL field if it was entered in a correct format.
  7. Enter the same Application Id (Client ID) from the application that was registered in the Azure portal. It can be found on the Overview page in Azure Portal.
  8. Enter the Client Secret value from the application, if the secret value was not saved when registering the application then a new secret and value will need to be created.
  9. Click Validate.  This will start the OAuth process and you will be directed to a Microsoft login if not already logged in.  If you were still logged in, you will be asked to grant permissions.  Click accept to grant the permissions.  If your user does not have the proper permissions, you will need to have an admin user grant the permissions.
  10. After successful validating you will be redirected back to the Dynamics 365 Business Central connector and can now choose your company.
  11. After successfully completing the validation and access steps, you can now save the connector.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters