Introduction to V4 Tickets R

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:

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

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

Directly connect and retrieve data from our system via API, follow the steps below using Microsoft Excel’s Power Query feature.

Prerequisites

Microsoft Excel 2016 or later (Power Query is built-in)
API endpoint URL provided by our support team
API access credentials

Step-by-Step Instructions

Open Excel and Navigate to the Data Tab
- Launch Excel.
- Go to the Data tab on the ribbon at the top.
Start a Blank Query

2.1 Click on Get Data

2.2 Hover over From Other Sources.

2.3 Select Blank Query at the bottom of the list.

Open the Advanced Editor
- After the blank query opens, click on Advanced Editor in the Power Query Editor window.
- Replace the default code with the API request code (provided in the next section).
Example Code for API Request

let
    url = "https://val5-api.tixngo.io/prod/v4.0/organizer/report/", 
    headers = [
        #"x-api-key" = "your x-api-key "
    ],
    response = Web.Contents(url, [
        Headers = headers
    ]),
    json = Json.Document(response),
    reports = json[reports],
    reportsTable = Table.FromRecords(reports)
in
    reportsTable

Replace x-api-key with your actual key.

Load Data
- Click Close & Load to load the data into your Excel worksheet.

Refreshing Data

You can click Refresh All in the Data tab to fetch the latest data from the API anytime.

How to Use the Excel Template

This template provides access to 3 live reports connected to our API:

Event Statistics
Full Ticket List
Monthly Injection Report

Each worksheet is automatically updated when you enter your parameters and refresh the data.

Step 1: Enter Required Parameters

Refer to the corresponding endpoint detailed documentation.

Before refreshing the reports, ensure all required fields are completed.

For each report worksheet:

Go to Data > Queries & Connections.
Right-click the relevant query and choose Edit.

In the Power Query Editor, open Advanced Editor

Replace values for the parameters

Step 2: Refresh the Reports

Once parameters are

Go to the Data tab in the Excel ribbon.
Click Refresh All.

This will pull the latest data into:

Event Statistics
Full Ticket List
Monthly Injection Report

Security Note

API keys are stored locally in the workbook and are not shared automatically.
Do not share the file with the API key filled in unless you trust the recipient.