To populate our database, we have used the Fantasy Premier League API: https://fantasy.premierleague.com/api/bootstrap-static/. The use of real players, teams and game week stats, gives our magic quidditch application the essence of a real league, muggles like that. We adjust and transfer the data to Dataverse by using Dataflows inside Power Apps.

Additionally, and by using the same procedure, in good theaving bastard style, we use https://hp-api.onrender.com/api/spells to get some spells professor Snape had hidden in the restricted section of the library! By this we add business value to our existing data by enriching the FPL dataset with Publicly available sources that consist of spells in the Harry Potter universe.

By using the public chatGPT API inside a Power Automate Flow, we transform the FPL to make it Harry Pottery!

In order for the quidditch player to sign in, we use the hot technology of our dear sponsor LINK Mobility. We use their MyLINK SMS API to generate unique OTP codes. The uniqueness of the codes get validated by using a Power Automate flow while also managing the values in our Dataverse database.

As part of the implementation of the MyLINK SMS API, we helped not only other teams that struggled with the implementation of the API, but clarified some doubts from the one and only Thomas Sandsør.

We have further enhanced our solution by integrating Azure Cognitive Services’ Speech-to-Text API and the CloudConvert API, enabling seamless conversion of audio into text and back into sound… More about this functionality is coming soon in another post called: “The data is not yours, the data is MINE(er)”