Hey everyone!
Sorry for the radio silence on this thread. It’s now possible to access the individual time tracking sessions in a cell via the API. In each cell, you can retrieve the additional_values
field. This contains a JSON of all the sessions in that cell.
Each session contains the following data:
account_id: 12345,
column_id: "time_tracking",
created_at: "2020-10-29 16:29:27 UTC", // when the session was added to the cell
started_at: "2020-10-29 16:29:26 UTC", // only applicable if the session was added by pressing the play button or via automation
ended_at: "2020-10-29 16:29:28 UTC", // only applicable if the session
started_user_id: 4012689,
ended_user_id: 4012689,
id: 40949481, // unique session ID
manually_entered_start_date: false, // true if the session was manually entered
manually_entered_start_time: false, // true if manually entered
manually_entered_end_date: false,
manually_entered_end_time: false,
project_id: 162169281, // item ID,
status: "active",
updated_at: "2020-10-29 16:29:28 UTC"
EDIT: for a full example of a query and the returned data, check out the last post in this thread (link).