Forum Discussion

mparravani's avatar
mparravani
Regular Visitor
8 years ago

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

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 ...
WolfBiber's avatar
WolfBiber
Microsoft Employee
8 years ago

Hey,

API KEY  is not the right way here. 

Use Basic Authentication instead. 

Or if it a header parameter

let
Source= Json.Document(Web.Contents("https://api.bamboohr.com/api/gateway.php/{company subdomain name}/" , [Headers=[Authorization=YOURAPIKEY"]])),

 

Greetings

  • mparravani's avatar
    mparravani
    Regular Visitor
    8 years ago

    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's avatar
      WolfBiber
      Microsoft Employee
      8 years ago

      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

Related content