Lookup sprint ID by sprint name

[Remco Asberg]

In an automation in which I create stories for multiple sprints I want to also directly assign the created stories to those sprints. However I am limited to just assign to active and next sprint by default.

I have found that you can assign the sprint by sprint ID as well, but for that I first need to find the sprint ID. For the automation I would like to be able to find the sprint ID of a sprint by looking it up with the sprint name. The sprint name has a standard format, so the sprint name I can predict also for future sprints that are not created yet. Is there an option to something like this? Important note is that I should be able to find these sprints, even if there are no stories in the sprint yet.

Alternatively, is there a way to assign a story to a sprint by providing the sprint name instead of the sprint ID?

[Bill Sheboy]

Hi @Remco Asberg -- Welcome to the Atlassian Community!

Other than for the listed sprint options, an automation rule needs the sprint ID to select it.  There is no way to set the value by the sprint name as that could collide in multiple projects.

To find the sprint ID for the name, the rule would call the REST API endpoint to get all the sprints for a specific board, and then select the one with the matching name.  To help you get use this approach, here are some references:

Calling the REST API from a rule with the Send Web Request action

Get All Sprints endpoint for a specific board ID

List functions and Text functions to identify the matching sprint from the webresponse

And when you call the endpoint, consider adding the parameter to only select the ones for the relevant state: active, future, etc.

Kind regards,
Bill