Power Query and API

Excellent post+sample file by Erik Svensen how to import data via Power Query and a JSON query.

...

....

Link: Excel-File

Unpublished: Import Excel file to SQL Server, Microsoft Product Roadmap, Office365 Roadmap, Excel Data Mining Add-Ins