Oct 26 2022 11:17 AM
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