Upodi Reporting Keys have access to your entire Upodi database through an OData-protocol. OData is an OASIS standard that lets you consume the REST API directly.
This allow you to poll the data directly into your favourite Business Intelligence tool, or even into excel, as most Business Intelligence tools will have an option to read directly from an OData protocol.
Creating and using a Report Key
Go to your API-key section in Upodi and create a new API-key. Choose the type Reporting Key.
This key can be accessed on the URL https://reporting.upodi.io/odata/ via the Open Data Protocol and requires basic authentication with any Username and a Password which is the API-key with report access.
curl --location --request GET 'https://reporting.upodi.io/odata/' \
--header 'Authorization: Basic base64-encoded {username:ReportKey}' \
--header 'Content-Type: text/plain' \
For example Microsoft Excel can also be used to read from the reporting key. Read more on Retrieving data from Upodi to excel.