Fortnox driver not showing in QueryTool Beta 24.1.113

[sda]

Since the release of 24.1.113 Beta allowing connection to Fortnox API, adding the driver to our Settings.xml does not show the connection in our connection list.

The setup we used:

    <connection name="My Fortnox">
      <database
        order="10"
        alias="fnx"
        provider="Fortnox"
        userLogonCodeMode="Auto"
        passwordMode="Auto"
        connectionString="api-client-id=[ofbuscated];api-redirect-url=https://cloud.invantive.com/app/setup/databases/new/fortnox/token;api-token-url=https://apps.fortnox.se/oauth-v1/token"
        AllowConnectionPooling="false" />
    </connection>

If we rename provider="Fortnox" to another one like SqlServer then the connection appears

It is important for us to move to Query Tool since Invantive Cloud is limited to 900s query execution time.

The (nice) view Fortnox.Views.VoucherLines gets 5000 records in 392s…
we are all the time timeout-ed so we can’t get all data in a complete year.

[forums]

Selection of blue “Discovery” button on Invantive Query Tool logon screen should add the following entry to %USERPROFILE%\invantive\settings-discovery.xml:

    <connection
      name="Fortnox"
      IconResourceName16="fortnox_16.png"
      authentication="Default"
      sortingOrder="2594"
      description="{res:itgen_product_description_fortnox}"
      id="e3807831-b497-4ecb-8de5-595d79440f01">
      <database
        order="10"
        provider="Fortnox"
        userLogonCodeMode="Auto"
        passwordMode="Auto"
        AllowConnectionPooling="false" />
    </connection>

The reason the driver specification in settings.xml is not shown is probably a syntax error. Databases with errors are automatically hidden to ease interoperability across versions of Invantive SQL, although it can be confusing.

Please make sure to use Invantive Query Tool 24.1.113-BETA or newer.

The client ID and secret are provided by Invantive and do not need to be specified.

As an alternative to the UniversalSQL-editor with a significant higher timeout of 6 hours you can run a query using Invantive Bridge Online. The URL is available with the database.

The Bridge Online driver in Query Tool can access Fortnox then, even from release 24.0 of Invantive Query Tool:

[sda]

Thks.

Having copied:

 <connection
      name="Fortnox"
      IconResourceName16="fortnox_16.png"
      authentication="Default"
      sortingOrder="2594"
      description="{res:itgen_product_description_fortnox}"
      id="e3807831-b497-4ecb-8de5-595d79440f01">
      <database
        order="10"
        provider="Fortnox"
        userLogonCodeMode="Auto"
        passwordMode="Auto"
        AllowConnectionPooling="false" />
    </connection>

Still Fortnox is not shown.

[forums]

The only possible remaining reason could be a license key that does not yet support Fortnox. A new license key for your company has been generated and will be delivered within 2 hours via email and the screen License Keys on Invantive Cloud.

Please install that license key as documented on:

Install License Key on Independent GUI Products on Windows

Go to Dutch version This articles provides the steps to install a license key on all Invantive software products running without integration into Microsoft Office, running on Microsoft Windows. A license key is part of a subscription. A subscription has a unique code beginning with L followed by digits. Each subscription can have multiple license keys. A license key is approximately 2,000 characters long and does not begin with an L. For Microsoft Office-integrated products such as Invantive …

And try again.

[sda]

Licence key was the issue. Thanks.