nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I get start and end dates por all Sprints in a project in Jira Cloud?

Paula Remez

Hi! I Need to get start and end dates por all Sprints in a project in Jira Cloud. I know I can get them in the bakclog, for each sprint, but I need to be able to get them all at once for an extrernal report... I don't need to be able to export to excel. It is ok to get them all at once to be able to copy and paste...

Any help will be apreciated!

Thanks a lot!

Paula

Accepted answers

Warren_mz9b4z

Hi @Paula Remez

Paste the following into the browser that you use for Jira and ensure that you're logged in to Jira

https://CompanyName.atlassian.net/rest/agile/1.0/board/xx/sprint

Replace CompanyName with your company name and xx with the board number of your project. This will return a JSON structure listing all sprints with their start and end dates, plus their state (open, closed).

All comments

Warren_mz9b4z

Hi @Paula Remez

Paste the following into the browser that you use for Jira and ensure that you're logged in to Jira

https://CompanyName.atlassian.net/rest/agile/1.0/board/xx/sprint

Paula Remez

Great! Thanks a lot!!!

Roxanne Mae Sumaya

Hi @Warren - Thank you. It works. Is there also a way to get all Sprints? Upon checking it only shows the first 50 Sprints. Thanks in advance!

Derek Lee_p6uiwy

@Roxanne Mae Sumaya You will need to write some code to account for the pagination in the API:

Below is an example, I'm not sure if it will work for exactly your case since I have not tested if the boards API accepts a startAt and maxResults parameter

start_at = 0 
sub_url = "https://CompanyName.atlassian.net/rest/agile/1.0/board/xx/sprint"

# the following url works for the example: 
# sub_url = "https://CompanyName.atlassian.net/rest/api/2/search"

# Create a request object with above parameters. response = requests.request( "GET", url, headers=headers, auth=auth, params=query )

auth = HTTPBasicAuth{<username>, <password>}

headers = { "Accept": "application/json" }

query = {<any JQL parameters needed>}

all_issues = []

while(start_at < response.json()["total"]):
    print("starting at: ", start_at)
    result = requests.request(
    "GET",
    f"{sub_url}?startAt={start_at}&maxResults=1000",
    headers=headers,
    auth=auth,
    params=query
    )
    issues_received = result.json()["maxResults"]
    start_at += issues_received
    print("new start_at: ", start_at)

    tmp = result.json()["issues"]

    all_issues += tmp

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud