Forum Discussion
Calling multiple API Endpoints in single Query
Hi Anonymous
As your URLs have a predictable structure that only the student identifier is different, you can refer to the solution from the following blog written by Mynda Treacy.
Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub
The main steps include:
- Convert the current query for pulling a single url to a function that can be executed for each API url
- Generate a list of student identifier numbers and convert it into a table
- Execute the function for each student identifier number
For detailed steps, please refer to the above blog. Let me know if you have any question.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Anonymous
As your URLs have a predictable structure that only the student identifier is different, you can refer to the solution from the following blog written by Mynda Treacy.
Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub
The main steps include:
- Convert the current query for pulling a single url to a function that can be executed for each API url
- Generate a list of student identifier numbers and convert it into a table
- Execute the function for each student identifier number
For detailed steps, please refer to the above blog. Let me know if you have any question.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!