5 March 2021

Introducing The New and Improved TOPdesk OData Feed

Business Intelligence is booming. In the knowledge that “data is the new oil”, companies are doing everything they can to access and analyse their business-critical data, before using these insights to fine-tune the way their company operates moving forward.

As such, the global Business Intelligence tools market—worth $23.1 billion in 2020—is expected to grow at a Compound Annual Growth Rate (CAGR) of 7.6% between now and 2025.

But if companies truly want to be data-driven then they need to do more than simply invest in a swanky new tool—they need to ensure that this tool has enough data to work with.

There’s little point investing in an all-singing, all-dancing piece of Business Intelligence software if you can't fuel it with the right kind of data.

That’s where the TOPdesk OData feed comes in.

What is the TOPdesk OData feed?

In short, the TOPdesk OData feed allows companies to access their data held within the TOPdesk platform and send it over to their reporting tools (such as Power BI), where it can then be put to good use.

Originally released in February 2018, the OData feed used to only offer data from Incident Management and Supporting Files. However, we’ve invested heavily in OData in recent times—meaning it’s now better than ever.

Recent OData developments

Over the past couple of years, customers have typically had three hurdles when it came to effectively using the TOPdesk OData feed:

  1. They were unable to use permissions
  2. They were unable to access enough data
  3. They sometimes ran into performance issues

The latest version, OData Feed V3, marks the first step of our journey to eradicate the 3 problems listed above. Take permissions, for example.

Previously, if a colleague wanted to run a report, you had to give them full access to all data in TOPdesk—or you had to run the report yourself as the admin.

Now, however, you have more flexibility: picking and choosing which team members can access which particular types of data.

But wait—what about the other two problems?

Don’t worry, we haven’t forgotten about them. Adding permissions functionality is just the first step to making the OData feed more comprehensive. We’ve had to create these permissions within a brand new system. Now that this system has been properly developed, it will also be able to house any new modules and fields that we add going forward.

We’ve also made significant strides towards improving the OData feed performance, especially with regards to the Asset Management and Incident Management feeds. Now, you can use your own TOPdesk reporting wizard to easily create simple Asset Management reports within the TOPdesk platform itself.

What’s next for the TOPdesk OData feed?

Now that we’ve included new and improved permissions functionality, our next step is to add even more modules and fields to the OData feed. For instance, we plan on soon rolling out the Supporting Files module.

This module will allow you to access more data, more easily than before—allowing you to segment your data according to Persons, Operators, and Branches. Imagine you want to see how many salespeople have encountered incidents with your CRM software, for example.

With OData’s upcoming updates, this process will be a breeze.

Reporting, like never before

We firmly believe in the power of data reporting—that’s why we’ve invested so much time and energy into improving our OData feed.

We want to make it as easy as possible for our customers to access crucial data that lies within the TOPdesk platform, before migrating this over to their own business intelligence platform.

Companies that have a firm grasp over their data and reporting processes undoubtedly wield a competitive advantage. With the ever-increasing pace of change, fuelled by an explosion in the amount of data available to companies, it’s more crucial than ever before to clearly understand what your data is telling you and to act on these insights.

Thanks to OData, you’ll be sure to catch all pivotal insights hidden within your TOPdesk platform—and you’ll make your entire reporting process quicker, easier, and more comprehensive.

How to get started

So now it’s over to you—try making your own OData report today and let us know how it goes!

To help you on your way, here's a tutorial on how to configure Power BI. For other BI tools (including Excel), the configuration process is similar. But when you need help, don't hesitate to reach out! 

Watch the Power BI tutorial.

Laurens van der Heijden

Laurens van der Heijden, Product Owner APIs