How to get sprint list in Confluence?

[Deleted user]

My team have 2 projects and we have a sprint for each project everyweek

we have to make a weekly report every Monday,

But It's a bit tedious to get a sprint number.

So I want to get a list of Sprint number for using it to Jira/Filter

For example

{date} : {sprint number}

3/4 : 10

3/11 : 11

3/18 : 13

Can I get a sprint list in Confluence?

[Angélica Luz · Accepted solution]

Hello @[deleted],

Thank you for reaching out to Atlassian Community!

Just to make sure that we are on the same page, I would like to confirm if when you say sprint number it means the sprint id. 

Checking for similar cases, I didn’t find anything that would show their ID in Confluence, there are only fields to show their names.

Maybe using an API can help you to get their ID more easily. I found one from this thread and tested it on my site and it works. The endpoint is not specific for Cloud, but it returns the list of sprints:

 http://xxxxxx.atlassian.net/rest/greenhopper/1.0/sprint/picker

This is the result:

You can just change the xxxxx and add your site name and paste it on the browser (I’m using Firefox on the example above).

Hope this helps!

Kind regards,
Angélica

[Deleted user]

I really appreciate it!