When using dox42 D365 BC: Setting up the Microsoft Excel config file

  • Updated on Jul 22, 2025
  • Published on Jul 21, 2025
Prev Next

If you are working with dox42 D365 BC, bear in mind that your individual BC URL needs to be saved to your Excel config file.

Learn how to retrieve your BC URL and how to save it to your Excel config file.

Prerequisites

Steps

  1. In your download package, go to dox42_D365BC_DynamicsNAV\BC_Online\BC_online_connection_template and open the  BC_Connection Excel config file.

    Microsoft Excel config file template for BC

  2. Insert your specific Tenant ID into the AzureTenant column of your BC_Connection Excel config file. Learn how to retrieve app registration properties from your Entra ID admin center.

  3. A BC URL is composed as follows. Replace YOUR_TENANT_ID with your specific Tenant ID in order to get a specific BC OData V4 URL:

    1. Use https://api.businesscentral.dynamics.com/YOUR_TENANT_ID/Production for a production environment.

    2. Use https://api.businesscentral.dynamics.com/YOUR_TENANT_ID/YourSandbox for a sandbox.

  4. Insert your specific BC OData V4 URL into the BCURL column of your BC_Connection Excel config file.

  5. Fill in the other columns of your Microsoft Excel config file, using the app property values from your Entra ID admin center:

    1. Column AzureADApplicationID: Value of Application (client) ID in Entra ID admin center

    2. Column Add-In_RedirectURL: Value of Mobile and desktop applications > Redirect URI in Entra ID admin center

    3. Column Server_RedirectURL: Value of Web > Redirect URI in Entra ID admin center

    4. Column ClientSecret: Value of the Client secret in Entra ID admin center

      Note

      It is recommended that you use the Crypto data source to encrypt the value before storing it in this column.

  6. Save your Microsoft Excel config file.

Note

If you had difficulties following these steps, you will find alternative instructions below on how to obtain the specific BC OData V4 URL.

Alternative Steps for obtaining a specific BC OData V4 URL

  1. Carry out steps 1 and 2 described above.

  2. To retrieve the specific BC OData V4 URL:

    1. Log in to your D365 BC account.

    2. Open the search text field and enter: Web Services.
      A list with search results opens.

      Graphical user interface, text, application, email Description automatically generated, Bild

      Search results in Microsoft D365 Business Central

    3. Select the Web Services entry.
      The Web Services window opens.

    4. Copy any of the listed OData V4-URLs.

      Table Description automatically generated, Bild

      Web Services window in Microsoft D365 Business Central

  3. Go to your dox42 Add-In and select your data source in the Data Map Designer.

    1. Select the Connection Settings button.
      The Connection Settings window opens.

      Connection settings for Business Central with highlighted URL and data fields.

      Connection Settings of the BC data sources

    2. Select the Use specified URL directly checkbox.

    3. Enter the copied OData V4-URL into the URL text field.

      Connection settings for Microsoft Dynamics 365 with highlighted URL and data settings fields.

      BC OData V4 URL to be entered

  4. Select any white space.
    The entered URL is automatically converted to your BC OData V4 URL.
    Example: https://api.businesscentral.dynamics.com/v2.0/YourTenatID /Production/ODataV4/ or when using a sandbox: https://api.businesscentral.dynamics.com/v2.0/YourTenatID /YourSandboxName/ODataV4/

  5. Save the retrieved BC OData V4 URL to your Microsoft Excel config file.

    1. Therefore, create a new column: BCURL

    2. Paste the retrieved BC OData V4 URL into that column.

  6. Save your Microsoft Excel config file.

Result

You have created a specific BC OData V4 URL and saved it to your Excel config file.

Next steps