Export Ranking as Excel

Export Ranking as Excel

Managers of a tenant can export the results of events as a Excel file. The export includes the name, firstname, email, username, challenges and points of the users. This can be helpful if you would like to create custom reports with Excel.

Pre-Condition

The user must have the appropriate privilege applied in the IdP (Keycloak) |
Ranking report read role to composite manager in CCS

Properties

Parameter Name

Description

Requirement

Parameter Name

Description

Requirement

eventIds

A comma seperated list of eventIds to get the report for.

REQUIRED

mode

Aggregation mode for Units.

ASSET: if the same asset appears in multiple events then all points are accumulated and shown only once. This is helpful if you have multiple events with the same assets in it.

UNIT: each unit (same asset or not) is shown individually.

REQUIRED

  • ASSET

  • UNIT

Example Requests

If a user has the necessary privileges, he can export solutions. See the examples below.

* https://academy.hacking-lab.com/api/ranking/report/?eventIds=13,14,15,16&mode=ASSET * https://academy.hacking-lab.com/api/ranking/report/?eventIds=126&mode=ASSET * https://ost.hacking-lab.com/api/ranking/report/?eventIds=534&mode=ASSET