Compile different JSON files with a ApiKey header using Power Query

Occasional Visitor

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
Source = Json.Document(Web.Contents("https://customer.company.com/api/v1/hsqe/Vendors/FindVendors?page=1", [Headers=[#"Api-Key"="ELqmyFNOP9GCVcRTiiJCfGhzYXhXSNDVBHDI3aTA5TnBiU3VQ"]]))
in
Source

 

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

 

Please help.

 

Thanks,

CM

0 Replies