This article will give you the first insights on how to use the PSOhub OData feed to generate your own reports. The OData feed can be used by any reporting tool that allows OData access.
Connect to OData using Excel (example)
Start a new Excel document. In here, go to Data - Get data - From other sources - OData feed
In the next screen, enter the following URL:
Press connect and you will see the screen below. Click on Basic and enter your login name and password that you use for PSOhub. After that, click connect.
The connection will now be made and all the available OData will be displayed in the next screen.
Select the data you want to load and press load. All the data is now available within Excel for you to use in your own reports.
Note: In the uncommon event that you are experiencing errors when loading your OData feed, there is a chance that you might have data that contains an apostrophe (') symbol. Various reporting tools are known to have issues processing this symbol. A solution can be to switch from the default UTF-8 to UTF-16 encoding. You can find information on how to do this in the documentation of the reporting software you are using.