JSON Data Feed link

What is the JSON Data Feed link?

The JSON Data Feed link allows you to integrate Time in Status add-on data into third-party analytics systems or other external systems.

How to get the JSON Data Feed link?

1. Go to the Time in the Status report, select the desired configuration settings you need, and click the “Save as” button.

2. Select the “JSON Data Feed” tab.

3. Select the Preset you want to receive as the JSON Data Feed link.

If you do not have any presets, go to the Save&Load tab and create your first preset. How to create a preset?

4. Copy the generated link and insert it into the necessary external analytics system.


The Data Feed uses JSON Web Tokens (JWT) to authenticate access. 

During authentication using JWT on the server side, the program will check the validity of the token. If the submitted token is not valid, the request will reject as one that has not passed the authentication.

The data from JWT cannot be processed. It contains only identifiers and do not contain any personal info. 

Each token is created when the JSON Data Feed link has been generated. It is unique and gives access to one preset from the user's name only. Tokens do not have a validity period.

Example of a unique secure token:


Note. Do not give the link or token to third parties. The JSON Data Feed link can be deleted if needed.

There are two versions of the JSON Data Feed link. By default the JSON Data Feed link is created and works in the second version mode, and outputs the result in the following format:

The first version of the JSON Data Feed link outputs data in the following format:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 Object<      /* Calculation result */ result: Object<          issue_key: Object<              status_id: number,          >      >      /* Additional data */        statuses: Array<Object<          label: string,           value: string,      >>      /* Task list */        issues: Array<Issue> >

Note. All JSON Data Feed links that have been created before the implementation of the Version 2, display information as it’s in the Data Feed Version 1. Version 1 is outdated, but you can update it to Version 2 whenever you need it. To switch between the JSON Data Feed link formats, you should replace v1 with v2 (and vice versa) in the link.


Note. When you change the settings of the preset from which the JSON Data Feed link is created - the settings of the JSON Data Feed link will change according to the preset.

Note. Now there are limitations on the number of tasks you can get with the JSON Data Feed report. With the Average Time та Time in Status per Date, you can generate a report up to 400 tasks in it, when other (Time in Status, Assignee time, Status Entrance Date, Status Count, Transition Count) generate a report up to 3000 tasks in it. Please, edit the parameters of issue list if you haven’t get the result of the tasks you expected to see.

Find the detailed info on how to integrate the JSON Data Feed link into the Google Spreadsheets.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now! >>>