Cannot Send API Call Using Advance Dialogue Box in Power Query

[rkaczano]

I am trying to run an Advance API Call From Web in Power Query. I know this works in PostMan but I cannot seem to get it to work in Power Query.

I press Advance and then fill out the form as follows below with the URL and the parameters

URL = https://api.aeso.ca/report/v1.1/price/poolprice/?startDate=2000-01-01&endDate=2000-01-02

I then press OK and go to Web API

I then put my "MyAPIKeyValues" in the "key" input box.

Then their is a "Select which level to apply these settings to " box which defaults to:
"https://api.someorganization.ca/"

When I hit Connect it says : "A web key can only be specified when a web API key name is provided"

I know that when I am in Postman I define the API Key Name as "X-API-Key" but it was not obvious to me where to do this here.

So started again and added "X-API-Key" and "MyAPIKeyValues" to the the HTTP request header parameters (optional) input boxes in the advanced tab.

When I chose Web API it prompts me again for a key which is confusing do I paste "MyAPIKeyValues" into the Key input box.

I get the following error "A web API key can only be specified when a web API key name is provided."

What am I doing wrong?

Thanks

 

[rkaczano]

Sorry the line above that says:

“Then their is a "Select which level to apply these settings to " box which defaults to:
"https://api.someorganization.ca/"

Should have sad:

“
Then their is a "Select which level to apply these settings to " box which defaults to:
"https://api.aeso.ca/"

Thanks

 

[jdellasala]

I have RARELY used an API in Power Query, but those few times the URL had a "field" for a key that needed to be part of the URL. There should be documentation that can help with that.