Timepiece  - Time in Status for Jira provides both file export functions and a REST API to get data out. But if you want to automate getting data from Timepiece you probably need to do some custom development.

To overcome this obstacle for many users, we prepared the sample files below.

These files include some basic functionality to set parameters and get Timepiece report data from REST API directly into the spreadsheet file. You can use these files as a starting point, build your reporting with pivot tables and charts on them and use the ready-built integration functions to easily refresh your data.


The page includes the templates and instructions for getting data from Timepiece on Jira Server or on Jira Data Center. 

If you are working with Jira Cloud, see TiS Cloud - Sample Spreadsheet Integration Files


Google Sheets

You can use this Sample Google Sheets Document to get data from Timepiece using REST API.


This Google Sheets document already has some basic structure and built-in scripts that will allow you to get data via REST API.

  1. Click on the above link of the document to open it.
    1. You will need a Google account. 
  2. Once the document is opened, it will be in read-only mode. In order to use the document, you need to make a copy of it for yourself.
    1. To create a copy, use the Make a Copy option in the File menu.
  3. Once you create a copy of the document for yourself, the new copy will be opened automatically.
    1. The colored cells in column B are the report parameters. You will be filling these cells to get the report you want.
    2. For the report to run, you will need to at least enter a Jira URL, username, password, and a project key.
      1. Details about REST parameter values can be found here: TiS v5.3 - REST Reporting
  4. When the parameter values are set, click on the RUN button to trigger the script that will use the given parameters and get you the report.
    1. The status of the operation can be tracked in the Status cell right below the RUN button.
  5. When you click on the RUN button for the first time, Google will ask for some permissions from you. You need to allow the execution of the script for this file to work.
  6. Once you confirm these dialogs, click the RUN button again the built-in script will get your data.


Microsoft Excel

You can use TimepieceDC_Integration_Sample.xlsm to get data from Timepiece using REST API.


This Excel file already has some basic structure and built-in scripts that will allow you to get data via REST API.

  1. Click on the above link of the document and download it.
    1. You will need Microsoft Excel on your computer. The file won't work on Excel cloud.
  2. Open the file.
  3. Since the file is downloaded from the Internet, Excel will warn you a few times.
    1. Click "Enable Editing" and "Enable Content" buttons to activate the file. 
  4. Then the document will be ready to use.
    1. The colored cells in column B are the report parameters. You will be filling these cells to get the report you want.
    2. For the report to run, you will need to at least enter a Jira URL, username, password, and a project key.
      1. Details about REST parameter values can be found here: TiS - REST Reporting
  5. When the parameter values are set, click on the RUN button to trigger the script that will use the given parameters and get you the report.
    1. The status of the operation can be tracked in the Status cell right below the RUN button.




  • No labels

© 2012-2015 Copyright OBSS