Forum Discussion
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...
What you need to do is go into the Source Step in Power Query Editor or the Advaned Editor and find "Web.Contents" It should look like this:
Web.Contents("https://app.klipfolio.com/api/1.0/datasource-instances/{id}/data")
What you need to do is specify the API Key name AFTER the URL but before the close param. This is documented under the optional options of M Query here: https://docs.microsoft.com/en-us/powerquery-m/web-contents
Your final product should look like this:
Web.Contents("https://app.klipfolio.com/api/1.0/datasource-instances/{id}/data",[ApiKeyName="kf-api-key"])
Finally Return to "Credentials" Choose API Web and enter the API key in the box provided (if the wasn't already done).