Forum Discussion
Integration with BambooHR
BambooHR has a REST API. Try reviewing it for what you need and using it in a web request from Power BI: http://www.bamboohr.com/api/documentation
Well I got so far but am now stuck again. I have managed to connect and authenicate using an API key and can extract the employee directory. What I want now is the time tracking data but can't see a way to get this.
The API described on the Bamboohr website requires you to enter the employee id but I want to extract all employees' tracking data so I can report on it in Power BI.
Any advice?
Thanks
Hiya, I've not tried using the time tracking in Bamboo, so don't have any direct experience unfortunately. It sounds like you might need to investigate creating a custom function, which is a little advanced - not impossible but it'll take a bit of understanding. Basically, it's like if you wanted to scrape data off a series of nearly identical webpages, or from an Excel workbook with a series of nearly identical tabs: you want to take data from a series of nearly identical API requests, with one parameter changing each time (the employee id). A custom function lets you do the same thing again and again with just the employee id changing, and outputs all the results into a single table.
It's not something I've done a lot so I can't help with the specifics, but this page might be a good starting point. Alternatively a similar issue is pagination with APIs - when an API gives the results in pages of 100 records or something like that, so you have to do a series of nearly identical queries to get all the pages of results. This page has quite a few useful links for tackling that, which might be a transferrable solution.
Good luck!