Extracting Sprints Data

[Michael Areola]

I have about 150 teams on multiple projects that I will need to analyze their sprint data multiple times within and outside the sprint.

1. Can anyone help with JQL that can extract all data for particular sprint and across multiple project?
2. Also, instructions about JIRA API for Power BI too is welcome

Thank you

[Nic Brough -Adaptavist-]

JQL finds issues, not sprint data.  It doesn't even have anything to say about any results, the output of running a JQL query is a simple set of pointers to a set of issues.  JQL such as "sprint = <sprint name>" might be the sort of query you want to start with.

It's what you display it in that goes and fetches the values from the issues.

What you'll need to do is ask JQL for a list of issues in the sprint you are interested in, then ask something else for sprint data.  Although you'll find an actual sprint is not much more than id, name, board it belongs to, sprint goal, its current state, start date, end date and completion date.

Start with a look at https://developer.atlassian.com/cloud/jira/software/rest/intro/#introduction (also applies for Power BI, as that has to "get" data over REST as well)

[Jack Brickey]

I Michael,

If you are asking how to query the issues in a sprint then the following will work regardless of whether the sprint contains hey single project for multiple projects. However I expect my answer is not hitting the mark here?

sprint = "sprint 123"