Badge: Dataminer

In the world of low-code development, efficiency and data integration are key to creating powerful and engaging applications. Here’s a glimpse into how we used a couple of APIs to fetch data efficiently and populate Dataverse with valuable information.

Utilizing the Harry Potter API

The Harry Potter API, available at hp-api.onrender.com, provides a wealth of data about the characters from the Harry Potter universe. For our project, we focused on retrieving information about the school’s staff and students.

Efficient Data Integration

By using the Harry Potter API, we were able to quickly and efficiently gather the necessary data. This approach saved us significant time compared to manually entering or sourcing the data from multiple locations. The API provided structured and reliable information that we could seamlessly integrate into Dataverse, ensuring our data was both accurate and up-to-date.

Populating Dataverse

With the data retrieved from the API, we populated Dataverse, Microsoft’s cloud-based data storage solution. This step was essential for creating a centralized repository of information that could be easily accessed and utilized across our Power Apps and Power BI dashboards. By having all the data in one place, we streamlined the development process and ensured consistency across our applications.

The data is populated!

We got 103 students into our table and managed to set the student value and their House (Which was a lookup so more advanced flow was needed):