Fortnox driver not showing in QueryTool Beta 24.1.113

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.

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:

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.

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:

And try again.

Licence key was the issue. Thanks.

1 Like

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.