Connect to Bamboo's REST API- Error"Web API key can only be specified when API key name is provided"

[mparravani]

Hello,

I'm relatively new to PowerBI, and am trying to connect to Bamboo's Open API (REST API). 

My workflow is going through PowerBI's "New Source" --> "web" --> in "basic" I enter Bamboo's API URL (https://api.bamboohr.com/api/gateway.php/{company subdomain name}/)

Then at the Authentication window, I select Web API and input the API key I generated in Bamboo. Then I get an error "a web API key can only be specified when a web API key name is provided"

I've read around, and have seen that the api key name is required in Web.Content. But where / how do i enter this and what is the "api keyname"? Under "New Source" --> "web" --> there is an "advanced" option that has HTTP Request headers, but none of them are "web.content" or API keyname.

Any help or nudge in the right direction would be awesome.

Thanks,

-Mike

[mparravani]

Hey,

Thanks for the quick response.

When I try this, and choose Anonymous credentials, I get the following error:

DataSource.Error: Web.Contents failed to get contents from 'https://api.bamboohr.com/api/gateway.php/COMPANYID/' (404): Not found
Details:
DataSourceKind=Web
DataSourcePath=https://api.bamboohr.com/api/gateway.php/COMPANYID
Url=https://api.bamboohr.com/api/gateway.php/COMPANYID/

All I have in the query line is:

= Json.Document(Web.Contents("https://api.bamboohr.com/api/gateway.php/COMPANYID/", [Headers=[Authorization="APIKEY"]]))

thanks

-Mike

[WolfBiber]

Hey,

the query lin should look like this:

let
    Source= Json.Document(Web.Contents("https://YourURI" & "Contact/" , [Headers=[Authorization="" & Token &""]])),
    objects = Source[objects]
in objects

But you have to investigate where the bamboo API wants the Credentials or Token. 

Error 404 says that the url you are using is not found on the server.

Maybe try a Client like Postman  to be sure everythings is working.

Greetings,

Wolf