April 13, 2023: New API release – affecting all users of Konsolidator Konnect®

We have rebuilt Konsolidator Konnect® to deliver a faster and better experience for our customers. This means that we will be replacing the existing API/data source with a new URL, which you get in the setup guides.
If you currently use Konnect® to extract data from Konsolidator, you must change your local files or scripts to receive your data from the new Konnect® before the old one reaches end of life. 

How will updating Konsolidator Konnect® benefit me?

Rebuilding Konnect® was necessary to improve loading time for our increasing customer base, and we have ensured that this update to Konsolidator Konnect® brings even more benefits, including:

• Improved performance: With the rebuilt Konnect®, you can pull data much more quickly.
• Availability of additional information: You will have additional information available for your reporting and streamlined field names across the tables.
• Ease-of-use: With the new Konsolidator Konnect®, you get an easy-to-use startup file for any Excel reporting.

What do performance, additional information, and ease-of-use mean?

Below you can read what improved performance, availability of additional information, and ease-of-use mean to you as a user.

Performance

From now on, all calls to the primary data tables will require a single value filter on both Year, Month, Source, and Structure. The new Konsolidator Konnect® will be the same type of data endpoint you know and are used to with the previous OData feed. However, significant changes have been made to optimize the performance.

The two key changes are:

• Konnect® has been rebuilt from the ground up with a brand new architecture
• Industry-standard fair use policies including limitation per server call via mandatory filters

Additional information available

You will find many updates in the new Konsolidator Konnect® with changes to and additional information in the tables based on our customers' feedback.

Some of the most significant changes are:

• Local account information is now available when retrieving uploaded numbers
• All sources are now available in the same table for consolidated numbers
• Consolidated numbers are now debit/credit as opposed to presentation style to align with the rest of the financial figures in Konnect®.
• Field names have been streamlined across the tables

Find the full list of changes by table, including what information is ready now and what will come later, here:  

What data is available (in detail per table)

Ease-of-use

With the new Konsolidator Konnect®, you get an easy-to-use startup "KonnectFramework" file for any Excel reporting. "KonnectFramework" is an Excel Workbook with predefined tables and queries to ensure optimal data retrieval. The file has an easy-to-use setup sheet to select which tables to retrieve and limit data as needed.

Another benefit is that this file takes Power Query programming out of the equation for the end user. You can, of course, still access the data source the same way you have been used to, but keep in mind that limiting data per server call is mandatory, as explained above.