Question

Timesheets via API


Userlevel 2

Anyone using the Karbon API to pull timesheets into another platform for billing? The limitations around expanding only 2 records seems very troublesome to pull all time in a month/quarter. 


4 replies

Userlevel 7
Badge +18

Hi Trey,

I made some recent updates to my PowerQuery function so that it works pretty smoothly. You can check the write-up here:

Connect Karbon API to Excel | Karbon Community (karbonhq.com)

You can use the two functions together to pull in all timecard data pretty quickly.

Userlevel 7
Badge +18

I use power query, a tool in excel, to pull in all data from relevant tables. 
 

I’ll share my code when I get to the office. 

Userlevel 2

Can you share how you are doing that? It seems like you basically have to pull every time sheet, work item, user key, etc for every period you are pulling time data for? 

 

Userlevel 7
Badge +18

I’m pulling time into a spreadsheet, marking up/down and then exporting QBO invoice sheet.

Reply