Timesheets by Tempo - Jira Time Tracking

Tempo Timesheets Overview

 

To be able to analyse Timesheets by Tempo - Jira Time Tracking app data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo apps with business intelligence tools such as SQL databases, and SQL Connector for Jira is the proper solution for such integration.

Learn more about Tempo apps data analytics on Tempo blog.

Tempo Timesheets fields can be found in the Tempo tab.

tempo-tables-capacity-planner-and-timesheets .gif

 

How to Add Tempo Client ID

 

Tempo Client ID is required to view and export the Tempo Timesheets data.

 

  1. Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.

apps-sql-connector.gif

 

  1. On the left-side menu, select API Integrations, select Tempo, and then copy the redirect URL.

 

  1. Select Apps, and then select Tempo.

  1. Select .

 

  1. Scroll down, select OAuth 2.0 Applications, and then select + New Application.

 

  1. In the Name field, enter any name you’d like.

  1. In the Redirect URLs, field, paste the redirect URL.

  1. In the Client type field, select Public.

  2. In the Authorization grant type, select Authorization code.

  3. Select Create Application.

 

  1. Copy the client ID and client secret, and then close the window.

  1. Return to API Integrations, and then select Tempo.

  2. Paste your client ID and client secret to the corresponding fields, and then select Validate & Save.

 

  1. Select Authorize Access.

 

 

 

Tempo Tables Overview

 

Table Name

Table Fields References

Table Name

Table Fields References

Tempo Teams

 

 

Tempo Team Members

 

 

Tempo Team Projects

 

 

Tempo Accounts

 

Tempo Account Projects

 

Tempo Work Attributes

 

Tempo Worklogs

 

Tempo Work Log Work Attributes

 

Tempo Plans

 

Tempo Programs

 

Tempo Holiday Schemes

 

Tempo Holidays

 

Tempo Workloads

 

Tempo Timesheet Reviewers

 

Tempo Timesheet Approvals