Compile different JSON files with a ApiKey header using Power Query

Occasional Visitor

Compile different JSON files with a ApiKey header using Power Query

Hi everyone,

I have to connect different JSON files into one table. Each JSON is a list of parts. To connect the file I need an Api-Key.

Here's an example:

let
in
Source

Thing is, I have over 90 pages and I don't know how to create one table with all the information.