Introduction to V4 Tickets Reporting Domain

What is a Reporting Domain?

TIXNGO is continuously computing several statistical data for reporting purposes based on operational events occurring in the system like ticket injection, download or transfer. These statistical data are stored in a dedicated database separated from the main operational database, and are regularly consolidated to optimize both performance and storage space. All this allows TIXNGO to be able to efficiently provide these statistical data, in almost-real-time or at any point in time in the past, without any impact on the core-business operations.

Sounds cool, how to access it?

In addition to some future basic screens in backoffice to access these statistical data, we decided to expose dedicated endpoints in the Organizer API to empower organizers to leverage these data in any way they see fit.

Great, I’m eager to query that API to feed my BI, Datalake or similar!

Go for it! Please find attached (and below for quick reference) the YAML definition of those endpoints:

YAML inline rendering for reference.

Mmmh, API what? Can I use Excel or PowerBI?

Yes, of course! Here is a sample Excel file to help you get started:

Please click Enable Content to allow this file to connect to our Reporting Domain.

Open

For the above tool, you need to:

1. Input the required parameters from Setup sheet, then go to the Ribbon bar > Data > Refresh All

   Open

   

2. Plea

Open

The first time you will connect to an environment, Excel will ask you to define the privacy level of this data source in a popup. Selecting Organizational should work in most contexts, but please refer to the corresponding Microsoft documentation for more details: Set privacy levels (Power Query) - Microsoft Support.

Open

Privacy level popup

3. Data will be displayed in Event Statistics, Full Ticket List, and Monthly Injection Report sheets

Open

Open

Open

Reporting endpoints documentation