Here’s how you can use the Time Tracker API to retrieve and export worklog data.
Generate your API Key
You’ll first need to create an API key directly from the Time Tracker configuration:
-
Go to Settings > Apps.
-
Navigate to Time Tracker Configuration > General Tab.
-
Click Get Key.
Retrieve Worklogs in JSON Format
Once you have your API key, you can pull worklogs (including issue data) via the REST endpoint:
https://timesheet-reports-gadgets.tempo.io/api/1/worklog?
Supported Parameters:
-
start (or startDate) – required, YYYY-MM-DD format.
-
end (or endDate) – required, YYYY-MM-DD format.
-
user – optional, user account ID.
-
allUsers=True – to get worklogs of all users.
-
groups – optional, group names.
-
filterOrProjectId – optional, e.g.,
filterOrProjectId=project_TIMESorfilterOrProjectId=filter_10010. -
moreFields – optional, list of extra fields to include in issue details.
💡 You can also take the URL from a report page after the #! delimiter and use it with the REST endpoint
Export Worklogs
You can export data directly to CSV or XLS format.
-
XLS:
https://timesheet-reports-gadgets.tempo.io/api/1/exportView.xls?
-
CSV:
https://timesheet-reports-gadgets.tempo.io/api/1/exportData.csv?