Summar.io offers the possibility to use data from the system for analysis purposes. This data is automatically generated every night and currently consists of 2 CSV files, units.csv for module oriented information and objectives.csv for learning object oriented information. The data is secured so that only people with a Token have access to it. This Token also determines which data the user has access to. Each user therefore has his own token.
The data is offered via the following URLs:
The structure of the units.csv file is as follows:
The structure of the objectives.csv file is as follows:
How to use this functionality
To use the data from Summar.io an analysis program is needed. In this manual we will use Microsoft PowerBI to show how the data can be used. This is PowerBI Desktop. The Microsoft website tells you how to install this, https://powerbi.microsoft.com/en-us/desktop/.
Step 1, generating the Token
Each user gets his own unique Token. This Token is only valid for the current school period and can be retrieved from the user settings which you can open on the user's name on the top-right-hand side of the screen.
Step 2, configuring the connection in Microsoft PowerBI
Start PowerBI and then click Get Data. In the dropdown select Web.
A dialogue opens in which you have to choose the advanced settings
In this dialog you indicate which file you want to access via the URL parts field. In the URL preview field you can see exactly which URL you have typed.
Then you add an HTTP request header parameter. From the drop-down list, select Authorization and paste the Token from step 1 into the field behind it.
With the OK button you establish this configuration and you enter the next configuration screen.
Here you can accept the default configuration and click the Connect button. The connection is made and the result is shown below.
If the information in this screen looks like this, you can load the data for use. You do this by clicking the Load button. The data is then available in the new report to be built.