How to Get Data from an API into Excel

 

1) Click Data, Get Data, From Other Sources, Blank Query

- You might be able to use "From Web", however Blank Query gives you more options 

2) 

Enter The Advanced Editor and Strucutre it as follows...

let

     Source = Json.Document(Web.Contents("https://localhost:7056/ap/endpoint" , [Headers = [Accept="application/json"]])), 

    TableFromRecords = Table.FromRecords(Source)

in

    TableFromRecords