Forum Discussion
Paginated results from an API in Power Query
As you can probably appreciate it is nearly impossible to help with API queries without access to said API (which you may not be willing to provide for understandable reasons)
What is particuallry annoying is that there is an option to get data > odata feed. You just pop in the url, and it should be that easy. Then you have to authenticate, and there is a section for Web Api. All very easy, no code required. But then you get an error message saying you can't do that without a Web API key name provided.
I've googled this error, and the only way to fix it is with code. Making that whole interface unusable. That's how I've ended up with this custom code, so now I can't use any of the interface based fixes that are abundant on the web, and the only option I've got is to find the right code.
If I could fix the initial API key name issue, and do everything through the inteface, then mabybe I wouldn't be having this issue at all.