Reckon One API - Filtering Timesheets

serginho

Hi, is there a way to filter timesheets via the

https://api.reckon.com/R1/{BOOKID}/timesheets

I have experimented with EmployeeId and CustomerId but cannot get to filter dates. It would be good to filter dates by range.

Thanks

Sergio

serginho

Correction, I have just experimenting with the APIs.

I was able to use EmployeeId={{employee_id}} to filter in the /timesheets/summary api

but i could not get that working in the /timesheets/entry api.

I could not get the CustomerId to filter or the dates in either of the apis.

Is there some documentation on how to filter timesheet entries? thanks in adavance.

Sergio.

PhuongDo

Hi Serginho,

Did you try this: https://api.reckon.com/R1/{cashbookId}/timesheets/week/{employeeId}/{startDate} ?

serginho

Hi @phuong

Good tip! OK, I see we can only get timesheet in week ranges for a single employee.

/timesheets/week/{employeeid}/YYYY-MM-DD (and this must be Monday otherwise you get an API error).

Not ideal but this gets me over the hump. Thank you.

PhuongDo

Cool, I think as long as you can get incremental update from Reckon and save it somewhere and make sure it's synced, then you can filter by any field you want from that local data.