LOG PARSERLIZARD
Tutorials · Jira API

Analyze Jira REST API JSON locally

Save a Jira API response, open it as JSON and use SQL to reduce a large issue list to an actionable summary.

Save the API response

curl -o jira-issues.json "https://your-jira/rest/api/2/search?jql=project=OPS"

Inspect the exposed fields

Run a small query first and confirm how nested issue fields are represented by the selected JSON provider.

Summarize by status and assignee

SELECT Status, Assignee, COUNT(*) AS Issues
FROM 'C:\Data\jira-issues.json'
GROUP BY Status, Assignee
ORDER BY Issues DESC;