Can't connect to Web API . Error "A web api key can only be specified when api key name is provided

[litus]

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!

[stefan_iceland]

Did you ever get this to work?

[litus]

Hi, Yes is working for me. In my case with Holded ERP.

thanks!

[v-rongtiep-msft]

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_KEY can be passed in three different ways, depending on whether you prefer to use the URL, a header, or basic authentication.

1. Custom header: provide the API key in the custom header X-Api-Key
2. Query parameter: provide the API key in the URL parameter api_key
3. 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.

[litus]

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.

[lbendlin]

Read the section about ApiKeyName

Web.Contents - PowerQuery M | Microsoft Docs

[litus]

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]

See if this helps

Chris Webb's BI Blog: Working with Web Services in Power Query Chris Webb's BI Blog (crossjoin.co.uk...

[litus]

Hi,

Thanks so much for your help.

What do you think I'm doing wrong? I'm testing all the posible things

[lbendlin]

Missing the square brackets.

[Headers = ...]

[litus]

Hi, 

thanks for your help. No luck Now I'm trying in another way but no luck "what a nightmare" .

(The key is not complete in the screenshot for obious safe reasons)

Thanks for your help Ibendlin