Excel Power Query

[cxuser182]

Hello,

Does anyone know how one would connect Excel Power Query to the API? (Excel: Data > Get Data > From Web)
I have tried adding my session key and API key as headers but get an error saying either not found or bad request. TIA.

[bfexplorer]

I do it this way:

https://www.youtube.com/watch?v=R21r-z3UfRU