Is there a way to get an automation email if a sprint hasn't been closed or started?

[Hari Shankar Gadamsetty]

Is there a way to get an automation email if a sprint hasn't been closed or started?

[Trudy Claspill · Accepted solution]

Hello @Hari Shankar Gadamsetty 

Welcome to the Atlassian community.

What criteria would you use to identify that the sprint should've been started? Would you want to compare the Start date of the sprint to the current date?

Similarly what criteria would you use to identify that the sprint should've been closed? Would you want to compare the End date of the sprint to the current date?

There are not pre-built functions that you could use to search for sprints based on criteria.

There is an API endpoint for getting all the sprints associated with a specific board. You have to provide the board ID as input to the API endpoint.

https://developer.atlassian.com/cloud/jira/software/rest/api-group-board/#api-rest-agile-1-0-board-boardid-sprint-get

With that endpoint you can also provide the sprint states (i.e. future, active, closed) to limit the sprints retrieved. In your case you would want future and active sprints.

The results include the start and end dates of the sprints. You would have to parse the data to extract that and compare if (if the criteria I suggested above is what you want to use).

In an Automation Rule you can use the Send Web Request action to call the Jira REST API endpoint to get the data. This article provides an overview of using that action.

https://community.atlassian.com/forums/Jira-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828

There is also an API endpoint for getting information about a single sprint, but you must provide the sprint ID.

https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-rest-agile-1-0-sprint-sprintid-get

You could incorporate the use of either of those into an Automation rule that evaluates the data provided and then generates and sends the email you want. You might want to set that up with a Scheduled trigger so that it runs periodically (daily, or on a scheduled that suits you).

[Hari Shankar Gadamsetty]

Hi @Trudy Claspill ,

Thank you for addressing this! Could you please provide a screenshot of the automation rule for this setup? I attempted it from my side without any endpoint actions, and I'm new to this endpoint configuration. Could I get a screenshot for this request?

Also, as you mentioned,

how can we determine if the sprint should have started? Would you like to compare the sprint's start date with the current date? - yes

Likewise, what criteria would you apply to decide if the sprint should have been closed? Would you want to compare the sprint's end date with the current date? - yes