Time Tracking Data Audit Log in API v2023-10

Forum|Forum|2 years ago
September 21, 2023
3 replies
476 views

Vania_Omnidea
New Participant

Hi everyone!

I have a question about the Time Tracking column.

I am interested in getting the single sessions’ data from the audit log of the time tracking column in my subitems (e.g., the two sessions in the screenshot):

In 2023-07, I could use the field ‘additional_info’ to gather the info on the sessions:

However, I cannot find a way to do the same in 2023-10. Any ideas to get to the same output? For my use case, downloading the Excel file manually or clicking on the audit log from the UI is a bit inconvenient.

basdebruin
Community Expert
Forum|Forum|2 years ago
September 21, 2023

hi @Vania_Omnidea

See: Time tracking and the history field. That field provides the same info in a much more structured way. Try below query in 2023-10. The time_tracking column supports history which gives you an array of objects with all kind of useful information.

{
  items(ids: 123456789) {
    column_values {
      id
      value
      ... on TimeTrackingValue {
        history {
          status
          ended_at
          started_at
          started_user_id
          manually_entered_end_date
        }
      }
    }
    id
  }
}