Time tracking

Export time reports

Applies the same filters and access controls as the JSON time report and returns an authoritative CSV file. The default entries view has one row per actual time entry and includes task and category labels, human-readable member, space, and board names alongside stable IDs, durations, billing snapshots, calculated billable amounts, currency, source, and review state. The timesheet view groups entries by card and local calendar day.

The entries view appends Roadmap Project ID and Roadmap Project columns, distinct from Space and Board. Project identity comes only from each entry’s logged membership snapshot, so moving a card does not change historical attribution. Missing historical membership has a blank project ID and the label No project; never reconstruct it from the current card hierarchy. Names are current authorized display names, not historical name snapshots. Deleted or unresolved projects use Unavailable project; restricted project identities and names must not be disclosed. Entries belonging to inaccessible projects are excluded according to the same authorization as the report.

The project_summary view groups that same complete filtered, deduplicated entry dataset by historical roadmap project ID. Each project appears once, with an additional No project row only when such entries exist. Direct parent and descendant entries each contribute once. Columns are Roadmap Project ID, Roadmap Project, Period from, Period to, Timezone, Tracked seconds, Tracked hours, Billable seconds, Billable hours. Period bounds are ISO 8601 instants (from inclusive, to exclusive); Timezone is the effective IANA report timezone. Seconds are integers and hours are decimal seconds / 3600 rounded to six decimal places. Totals cover the selected period only; no lifetime budget, planned duration, remaining or overrun columns are included. Project grouping is fixed; a non-empty group_by parameter is rejected rather than silently ignored.

All export views consume every matching page before returning success. Empty results return the view’s header row only. CSV uses UTF-8 and proper quoting for commas, newlines and quotes; text cells are protected against spreadsheet formula execution. Failures, deadlines and dataset limits return an error, never a successful partial file. Existing entries columns and timesheet layout retain their meanings.

GET

{team_id}

time

reports

export

Export a time report CSV

curl --request GET \
  --url https://api.superthread.com/v1/{team_id}/time/reports/export \
  --header 'Authorization: Bearer <token>'

import requests

url = "https://api.superthread.com/v1/{team_id}/time/reports/export"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.superthread.com/v1/{team_id}/time/reports/export', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.superthread.com/v1/{team_id}/time/reports/export",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.superthread.com/v1/{team_id}/time/reports/export"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.superthread.com/v1/{team_id}/time/reports/export")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

<string>

{
  "error": {
    "id": "err5f744ab",
    "code": 403,
    "sec": "SEC:000-00014",
    "message": "You do not have access to this resource",
    "date": 1608742037016
  }
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

team_id

string

required

Team ID is an alphanumerical string that identifies a Team. This is externally referred to as a "Workspace".

Query Parameters

from

integer<int64>

required

Lower bound (inclusive) for the report window, as a Unix timestamp in seconds.

integer<int64>

required

Upper bound (exclusive) for the report window, as a Unix timestamp in seconds.

timezone

string

IANA timezone used for day, week, and month boundaries.

logger_ids

string[]

Restrict to entries logged by these member IDs.

assignee_ids

string[]

Restrict to cards currently assigned to any of these member IDs.

space_ids

string[]

Restrict to entries whose card was in these spaces when the time was logged.

project_ids

string[]

Restrict to entries on cards currently in these projects, including time logged before the cards joined.

board_ids

string[]

Restrict to entries whose card was in these boards when the time was logged.

sprint_ids

string[]

Restrict to entries whose card was in these sprints when the time was logged.

card_ids

string[]

Restrict to these cards. Descendant roll-up uses the ancestor path captured when each entry was logged.

category_ids

string[]

Restrict to entries assigned to these time categories.

tag_ids

string[]

Restrict to cards currently carrying the selected tags.

tag_match

enum<string>

Match cards carrying any selected tag or every selected tag.

Available options:

any,

all

billable

boolean

Optional filter — restrict to billable (true) or non-billable (false) entries.

sources

enum<string>[]

Restrict to entries created manually, by a timer, or by idle-time handling.

Available options:

manual,

timer,

idle

rollup_mode

enum<string>

Direct includes only cards in the selected scope; descendants recursively includes every child card.

Available options:

direct,

descendants

csv_view

enum<string>

CSV layout. entries (default) returns one row per actual time entry. timesheet returns one row per card with a column for each local calendar day in the selected report window. project_summary returns one row per historical roadmap project with reporting-period tracked and billable totals, plus a No project group when present. It does not include lifetime estimates, budgets, remaining time or secondary grouping.

Available options:

entries,

timesheet,

project_summary

Response

Authoritative time report CSV.

The response is of type file.

⌘I

Export a time report CSV

curl --request GET \
  --url https://api.superthread.com/v1/{team_id}/time/reports/export \
  --header 'Authorization: Bearer <token>'

import requests

url = "https://api.superthread.com/v1/{team_id}/time/reports/export"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://api.superthread.com/v1/{team_id}/time/reports/export', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.superthread.com/v1/{team_id}/time/reports/export",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "https://api.superthread.com/v1/{team_id}/time/reports/export"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("https://api.superthread.com/v1/{team_id}/time/reports/export")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

<string>

{
  "error": {
    "id": "err5f744ab",
    "code": 403,
    "sec": "SEC:000-00014",
    "message": "You do not have access to this resource",
    "date": 1608742037016
  }
}

Get started

Users

Cards

Projects

Notes

Pages

Comments

Boards

Sprints

Spaces

Saved filters

Time tracking

Search

Export time reports

Authorizations

Path Parameters

Query Parameters

Response