![]() #"Converted to Table" = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Error) ![]() Make sure you have a Harvest Private API key first though (insert your own data where the asterisks are below also note that I’ve assumed the date columns are called “Start Date” and “End Date” but you can adjust as necessary). #HARVEST TIMETRACKER CODE#For this, add a new column on the calendar table we imported and use the following code in the Power Query Editor. Now the fun part – for each date range in the calendar table above, we want to invoke Harvest’s API. Make sure the Google Sheet has public access first though: Then, for the URL, use the following template but replace the ID with your own Google Sheet’s ID. Simply go to “Get data” and select “web”: You can import a Google Sheet quite easily. This isn’t exactly what I was after I wanted project metrics broken down per month.įor this, I simply created a quick Google Sheet with two columns: the start date and the end date with the aim of joining this sheet to Harvest’s API. The Reporting API requires both a start and end date and reports project metrics based on that duration. I wanted to call Harvest’s Reporting API for each month in the given year, and then report on that data visually. With a few lines of code inside PowerBI, we can connect it up. Now, Harvest at the time of writing does not have a native connector to PowerBI, but that’s no worries. Recently though, we wanted to get more out of our data, so we decided to connect Harvest’s API into PowerBI. It’s a great time tracking tool as it’s both readily adopted by team members and has fantastic out-of-the-box reporting. ![]() ![]() We use many tools internally here at Vokke, one of which is Harvest. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |