Forum Discussion

ibutur's avatar
ibutur
Frequent Visitor
9 years ago

A web API key can only be specified when a web API key name is provided.

Hi guys,   I'm trying to connect to a database on Klipfolio. I'm using my ID as explained here: https://klipfolio-api-reference-guide.readme.io/docs/data-source-instances-data so, it's https://ap...
ericOnline's avatar
ericOnline
Post Patron
7 years ago

I know its a LONG time later, but here is how I solved this error: 

 

API Method: 

  • GET

Steps:

  • Click Get Data
  • Click Web
  • Click Advanced
  • Enter entire query string with parameters
  • Enter API Key and Value as a header
  • Click Connect
  • HERES THE SECRET: Select "Anonymous"
    • It was intuitive for me to want to click "API Key". But this is what resulted in the error.

I was then able to retrieve the API results and expand columns. AWESOME! 

 

Hope this helps!

ericOnline's avatar
ericOnline
Post Patron
7 years ago

For what its worth, I just found a good explanation of what this error message is referring to. It appears that when you specify "ApiKeyName = "youapikeygoeshere" " in a PowerQuery, this message will show up. 

 

See this video at the 17:54 mark.

 

Cheers!