[Released!] Accessing time-tracking log via the API

monday Apps & Developers Announcements
40

Here is an example query that will return this data:

query {
  boards (ids:11111111) {
    items(ids:22222222) {
      column_values(ids:"time_tracking") {
        value
      }
    }
  }
}

The value field will be a JSON string, and inside the JSON there will be an additional_values key. That’s where the time tracking data is!

Here is an example of the returned data (from the query above):

{
  "data": {
    "boards": [
      {
        "items": [
          {
            "column_values": [
              {
                "value": "{\"startDate\":1613080702,\"duration\":90000,\"running\":\"false\",\"additional_value\":[{\"id\":63372124,\"account_id\":1825528,\"project_id\":162169283,\"column_id\":\"time_tracking\",\"started_user_id\":4012689,\"ended_user_id\":4012689,\"started_at\":\"2021-02-10 20:58:00 UTC\",\"ended_at\":\"2021-02-11 21:58:00 UTC\",\"manually_entered_start_time\":true,\"manually_entered_end_time\":true,\"manually_entered_start_date\":true,\"manually_entered_end_date\":true,\"created_at\":\"2021-02-11 21:58:22 UTC\",\"updated_at\":\"2021-02-11 21:58:22 UTC\",\"status\":\"active\"}]}"
              }
            ]
          }
        ]
      }
    ]
  },
  "account_id": 12345
}

I’m going to close this thread to encourage folks to open new topics for their questions. Please open a new topic in the GraphQL API FAQ category if you have additional thoughts or queries.

1 Like