How does one connect to BambooHR API to bring back all staff login details?

[rush]

Hi All

I am trying to connect to an API to bring back all login details from BambooHR but cannot seem to get it to work.

I tried connecting with the web connector but I get a 404 error.

https://api.bamboohr.com/api/gateway.php/CompanyDomain/v1/login

API Doc: https://documentation.bamboohr.com/reference/login-3

Thanks in advance.

[v-chenwuz-msft]

Hi @rush ,

Please make sure your username and password are correct. Have you tried this as the following screenshot:

If it works, please copy these string to these cells and try ti again.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rush]

Hi @v-chenwuz-msft 

Thank you for helping out. I have tried it and got a 403 error.


Error from power bi:
The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer"

[v-chenwuz-msft]

Hi @rush ,

Please set the data source setting and edit premissions. Use Basic authentication to connect.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rush]

@v-chenwuz-msft Thanks but I can not get to that step as it won't try to connect. Keeps failing.