Hi @mkurup12
If your APIs' urls have an identical format, you can replace the identical part (usually the variables) with a parameter, then create a custom function to invoke it. You just need to change the parameter value. Or you can use a table to contain all parameter values and add a new column by invoking this function to bring all data into the table.
There are some great blogs about this.
Getting Started with API's in Power Query • My Online Training Hub
Power Query Custom Functions • My Online Training Hub
Video:
Accessing API and web service data using Power Query - by Chris Webb - YouTube
I learnt a lot from above resources. Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
