How do I write Code for an API key call using Blank Query on legacy Excel/Mac

[Tante]

​

I have been searching for weeks now. I am not a programmer/dev. I am simply trying to get data from a website using Power Query on a Mac. The first obvious problem: Macs dont have "Get Data From Web"​

BUT, I found 2 walk arounds via youtube:

Problem 2) Neither of these walk-arounds take into consideration that some websites REQUIRE an API Access Key to get in. So, all the examples are simple requesting data from the home page.

Problem 3) Even if they did the code writing is very advanced for a laymen.

Next, someone suggested that a 3rd party API connector may help, but thus far have not been able to find one that work with Excel on a Mac and that is free.

SO, Ive gotten as far as figuring out basic code to use as a query, but no clue, how to use the information the website gave me writing on Blank Query from scratch.



The website wants such information as the following:

1. API domain
2. My API Key
3. A specific target domain
4. Endpoint and endpoint path
5. Suggest API Key in REST API calls in one of two ways: Preferred method or requesting via specific custom header

For me, this seems way past what I am able to do as of now…any suggestions?

 

[Ron de Bruin]

Check out the add-in from Suat : Power Query | Mac Excel Automation