JSON Feed for Export to Power BI and other Tools
- RVS
You can easily export your time in status reports to Power BI and other BI tools using the JSON Feed feature.
On the app screen, click on “More” → “JSON Feed” and copy the feed url.
In Power BI, use the "Web" connector to connect to the JSON feed.
Enter the URL copied above, and once connected, you can use Power BI's capabilities to create reports and dashboards based on your Jira data.
Sample report below
Security
The Data Feed feature uses JSON Web Tokens (JWT) for authentication. A JSON Web Token (JWT) in Jira is a secure way to authenticate and authorize access to APIs.
During server-side authentication with JWT, the system verifies the token's validity. If the provided token is invalid, the request will be denied as unauthorized.
JWT data is limited to identifiers and does not include any personal information.
Each token is generated when the JSON Data Feed link is created. It is unique, does not expire and is valid for 12 hours.
Sample JSON for “Time in Status” report
[
{
"Issue": "Test Burndown up",
"Status": "To Do",
"Assignee": "Unassigned",
"Created": "2025-01-05 10:50:54",
"Key": "AG-255",
"audit": {
"To Do": {
"time": 380940,
"count": 2
},
"Done": {
"time": 125,
"count": 1
},
"In Progress": {
"time": 0,
"count": 0
},
"Open": {
"time": 0,
"count": 0
},
"In progress": {
"time": 0,
"count": 0
}
}
},
{
"Issue": "check is association",
"Status": "To Do",
"Assignee": "Unassigned",
"Created": "2024-12-25 11:22:52",
"Key": "AG-254",
"audit": {
"To Do": {
"time": 631693,
"count": 1
},
"Done": {
"time": 0,
"count": 0
},
"In Progress": {
"time": 0,
"count": 0
},
"Open": {
"time": 0,
"count": 0
},
"In progress": {
"time": 0,
"count": 0
}
}
}
]