OData Feed

Pulling data into Power BI

Definition from from https://www.odata.org/ 

OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.

OData RESTful APIs are easy to consume. The OData metadata, a machine-readable description of the data model of the APIs, enables the creation of powerful generic client proxies and tools.

OData in Nimbus

The full history of completed Nimbus sessions (according to retention policy) and their attributes, is exposed through an OData interface. This means that in order to extract the historical data available for your tenant, it is necessary to connect with a connector that supports OData, and query such data using OData syntax. There are various tools that can be used to achieve this. One example is given in the Use Case - Connecting to OData via Postman.

💡An OData connector is also used for pulling data into Power BI

Nimbus OData Connector URLs

Using the Nimbus Power BI Template – in conjunction with user credentials in one of the Nimbus Reporting Roles – you can get access to the Nimbus Odata feed. The OData connection is already pre-programmed for you in the Nimbus Power BI Template, so all you have to do, is add the URL relevant to your tenant, from the ones listed below.

Once connected via the provided OData URI serviceUri, the user is presented with the set of entities available from the Nimbus Reporting Model .

INC Nimbus OData Connector URLs

Switzerland 01 https://api.ch-01.luware.cloud/v1/odata
Switzerland 02 https://api.ch-02.luware.cloud/v1/odata 
Germany 01 https://api.dewe-01.luware.cloud/v1/odata
Germany 02 https://api.dewe-02.luware.cloud/v1/odata
United Kingdom 01 https://api.ukso-01.luware.cloud/v1/odata
Australia 01 https://api.aue-01.luware.cloud/v1/odata
West Europe 01 https://api.euwe-01.luware.cloud/v1/odata
East United States 01 https://api.use-01.luware.cloud/v1/odata
Nimbus Power BI data cluster OData connector URLs

✅ Make sure to configure your web proxies to allow access to these domains or whitelist the complete *.luware.cloud domain.

💡Good to know: Our Nimbus Power BI Template will be regularly updated to make use the latest OData interface features. Make sure to check back on the Nimbus BI Template Release Notes to follow changes on our Nimbus Reporting Model and – in extension – the Template and Odata feed itself.

 

Odata Tables

Below is a list of OData tables available by connection string.

Odata Table Where to find details Related KB pages
Callers Slowly Changing Dimensions > Callers -
DistributionAlgorithm Static Dimensions > Distribution Algorithm Task Queue and Distribution 
DistributionPriorityType  Slowly Changing Dimensions > DistributionPriority Task Priority
DistributionType  Static Dimensions >  Distribution Type Distribution Types 
ModalityTypes  Static Dimensions > Modality Supported Modalities
NotAvailableReasons Slowly Changing Dimensions > NotAvailableReasons Not Available Reasons 
OpeningHoursTypes Slowly Changing Dimensions > Opening Hours Opening Hours 
OrganizationUnits  Slowly Changing Dimensions > Organization Units Organization Units 
PrimaryCodes  Slowly Changing Dimensions > Codes Codes
ResponsibilityProfiles Slowly Changing Dimensions > ResponsibliltyProfiles Responsibility Profiles 
SecondaryCodes  Slowly Changing Dimensions > Codes Codes
ServiceDataPermissions - Reporting Roles
ServiceSessionOutcomeGroups  Static Dimensions > Service Session Outcomes Historical Sessions 
ServiceSessionOutcomes Static Dimensions > Service Session Outcomes Historical Sessions 
ServiceSessions Facts > Service Sessions Facts - Columns and Data Types
Services Slowly Changing Dimensions > Services Service Administration 
ServiceSessionTags Facts > Service Session Tags Facts - Columns and Data Types
ServiceSessionTagStrings Facts > Service Session Tag Strings
Tags Slowly Changing Dimensions > Tags Tags 
TaskDirections Slowly Changing Dimensions > Tasks Task Queue and Distribution / Outbound Call 
TaskType 

Slowly Changing Dimensions > Tasks

Static Dimensions > Task Type

Task Queue and Distribution 
TaskTypeGroups  Static Dimensions > Transfer Sessions
TransferSessionDestinationTypes  Static Dimensions > Transfer Sessions
TransferSessionOutcomes  Static Dimensions > Transfer Sessions
TransferSessionTypes  Static Dimensions > Transfer Sessions
TransferSessions Static Dimensions > Transfer Sessions
UnifiedSessions  Facts > Unified Sessions Nimbus Reporting > Unified Sessions
UserDataPermissions - Reporting Roles
UserSessionActionGroups Static Dimensions > User Session Outcomes
UserSessionOutcomeHandledTexts Static Dimensions > User Session Outcomes
UserSessionOutcomes Static Dimensions > User Session Outcomes
UserSessions Facts > User Sessions Nimbus Reporting > User Sessions
UserStateTypes Static Dimensions > User State Type User States 
UserStates Facts > User States
UserTransferActionTypes Static Dimensions > Transfer Sessions
Users Slowly Changing Dimensions > Users User Administration 
UserSessionTags Facts > User Session Tags Facts - Columns and Data Types 
UserSessionTagStrings Facts > Service Session Tags

Table of Contents