Forum Discussion
Can't connect to Web API . Error "A web api key can only be specified when api key name is provided
Hi,
Could somebody help?
I'm tryin to connect to 2 different Web API that brings a Json and you authenticate with a private key.
one service is ClickUp™ | API Docs and the other is List Documents (holded.com)
Both cases in postman web it works very well but When I use the Power BI desktop assistant I setup advanced I allways got the same error what I can't understand:
Please any help would be appreciated I have not found any similar problem in the forum.
thanks!
10 Replies
- lbendlin
Super User
Thanks for your info Ibendlin.
Where I can put my real key value?
Web.Contents("https://contoso.com/api/customers/get", [ApiKeyName="api_key"])
- lbendlin
Hi litus ,
Please refer to these related threads.
A web API key can only be specified when a web API key name is provided
OData error message a web api key can only be specified when a web api key name is provided
As mentioned by yingyinr , you can try to select Basic, enter your app's API key as the Username, and press Connect
The API key
DEMO_KEYcan be passed in three different ways, depending on whether you prefer to use the URL, a header, or basic authentication.- Custom header: provide the API key in the custom header
X-Api-Key - Query parameter: provide the API key in the URL parameter
api_key - Basic authentication: provide the API key as either username or password. If you provide both, the API key must be in the username.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi,
Thanks for your help, the same with "select Basic, enter your app's API key as the Username" it says "Can't connect with this credentials.
- Custom header: provide the API key in the custom header
Did you ever get this to work?
Hi, Yes is working for me. In my case with Holded ERP.
thanks!
