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 ...
rush's avatar
rush
Helper V
4 years ago

Anonymous Thank you very much.


I managed to view the data but cannot refresh the data in the power bi service with basic authentification.

Tried "" and x as the password and it fails each time.

Please help.

Thanks.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Are you using a data gateway to connect to BambooHR's API? Are you able to refresh the data in PowerBI Desktop? Have you made any changes to the report you are using to fetch the data?

  • rush's avatar
    rush
    Helper V
    4 years ago

    Anonymous Hi 

    I managed to get it to work by using the password "x" which is weird as I was using that the whole time.

    I am able to refresh the data in power bi desktop and through the gateway now.

    The struggle I have now is with getting photos which it is giving me back error 404.

    I am trying to get back all employees photos with the URL below but fails:

    https://api.bamboohr.com/api/gateway.php/Companydomain/v1/employees/id/photo/original

    https://documentation.bamboohr.com/reference#photos-1

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I don't have access to most things in Bamboo, so I can't be of much help. But I don't think you are able to use this call to receive *all* employees photos in one request. You have to identify in the string which employee ID you want to return. 

      • rush's avatar
        rush
        Helper V
        4 years ago

        I see. Thanks for letting me know. I will reach out to them directly then to asssit

        Thanks once again.

Related content