I am trying to connect Power BI to BambooHR. I have successfully followed the steps to generate a BambooHR API key, and connected to https://api.bamboohr.com/api/gateway.php/companydomain/v1/employees/directory. It seems that I need to update the web address to replace "employees/directory" with the table name for each table I want to utilize in Power BI. The issue is that I cannot find a reference of all the table names. Has anyone successfully connected to BambooHR data? Do you know where I can find the table names?
Thanks!
This site seems to list all the endpoints for this API.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Try to take Employees/Directory off the url and see if it shows you all the available tables.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat unfortunately I get an error when I try that:
Details: "Web.Contents failed to get contents from 'https://api.bamboohr.com/api/gateway.php/companydomain/v1/' (404): Not found"
I also tried it removing the "v1/", as well. Same error
Check out new user group experience and if you are a leader please create your group
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
User | Count |
---|---|
34 | |
33 | |
30 | |
11 | |
11 |
User | Count |
---|---|
60 | |
51 | |
42 | |
16 | |
14 |