Because of how the API is structure I am not able to pull in the data I need in one call.
I need to get all the students' attendance, classes and grades.
So, first: "http://url/api/students" - I get a list of all students
Then "http://url/api/[StudentID]/classes " - I get a list of classes for a specific student
Then http://url/api/[StudentID]/[ClassID]/attendance - attendance for a specific student for a specific class
And finally, http://url/api/[StudentID]/[ClassID]/grades
I managed to do this in Power BI with Power Query functions and it's working fine, but I need to save my data to a database, so Power BI doesn't fit.
I am new to Power Automate, but played around a bit and did quite a bit of searching.
In Power Automate you need to use the HTTP action step for executing the API.
Once the data is returned you could store all in an array. Finally once you had all the data you could loop the array and collect all the results in one array. Finally iterate the array to push the data to your database.
If you need any further help in this please let me know.
Thank you, that's exactly what I am looking for.
I need more details, please.
How do I loop through array, firing more API calls and gathering and adding their results?
Let's say I first call http://url/api/students API, that returns list of students
Then I need for loop and for each student call http://url/api/[StudentID]/classes API - and gather and append the results...
Then - insert to SQL.
I totally understand that this should be the logic, but how to actually implement it?
I've searched a lot, but couldn't find anything similar...
If you have links to examples or YouTube - it'll be awesome!
Thanks a lot in advance!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!