The New Wattsight API Has Officially Launched

Wattsight API WAPI
April 2, 2020

We are happy to share that our new API is now ready to replace the old Data Center. With the Wattsight API we will provide our customers with powerful tools to use when downloading, visualizing, aggregating and monitoring their data of interest.

Wattsight has for a long time provided data through the (now old) Data Center. This system has allowed customers to directly download updated data on demand, but only from predefined sets of data. The Data Center will soon belong to the past, as it is now being replaced by our new API. Unlike the old Data Center, our new API gives our customers direct access to our database. This is a foundational change from the Data Center since also Wattsight teams heavily rely on the API in the daily routines and automated processes. Our offering includes tools to download and visualize your data using the method and software of your choice. You can monitor when the data of your interest is being updated. With advanced aggregation tools, you can even automatically generate your own historical day-ahead forecasts. Let’s have a look at some highlights below. For detailed info on how to use the new API, please consult the documentation.

Direct access to the database

The old Data Center provided users with csv-files where the data range, aggregation, and data resolution were predefined. Because the new API gives the user direct access to our database, these limits are all gone. The users can now decide for themselves, the only limit is the customer’s subscription.

Direct access to the database also removes any lag between data publication from our side, and data download from your side. As soon as the data is available in the database, you can start reading it. This brings us to our event system, which will let you know whenever your data is updated.

Event system

With the event system, you can subscribe to updates of individual series and consume data as they arrive. This system has some limits with regards to the amount of open connections that can run in parallel, hence we recommend you to focus on the time sensitive updates first. Otherwise, you can easily poll curve timestamps and download when there are updates to curves like it has been recommended for files in the the now legacy Data Center. Here is an example on how to set up an event listener.

Aggregations and absolute/relative forecasts

The relative and absolute forecast functionalities are powerful tools used to investigate the development of the forecasts. An absolute forecast will show you how the forecast for a specific time has developed from the first to the last forecast instance. The relative forecast helps you concatenate forecasts from different issue dates. Here is an example on how to make your own relative forecast using the python library.

Web application, python library and Excel plugin.

We offer a wide selection of tools for you to download and visualize your data. The web application is especially useful when searching for curves, and is easy to use for quick visualisation of data. You can even plot the data aggregated how you like, as well as plotting relative and absolute forecasts.

Our python library gives you an easy way to integrate your data into your own code. The library provides a large variety of useful tools, like aggregation methods and absolute/relative forecast functions. You can find many examples on how to use these tools in our API documentation, and on GitHub.

With the Excel add-in you can download data from our API directly into your own spreadsheets. Just download the add-in from the Microsoft Office Add-in library, and you are ready. We will over time expand the toolset available based on the feedback we get, so do not hesitate to reach out should we be lacking.

When and how do you make the transfer to the new API?

We are keeping the old Data Center operative for a year, until 1. February 2021. This is to give our customers time to make the transfer from the old Data Center to the new API. To make sure the transition will be as smooth as possible, we have made mappings of data from the Data Center to the corresponding curves in our new API. Read more about this mapping here.

Should you have further questions, please contact us at