Automation after Ticket creation: send SMS to User stated in Confluence table

[Rafael Freymueller]

Hi everyone,

for our IT Duty team I need to create an automation that automatically sends an SMS to the people that are currently on IT Duty (when Ticket is created). 

They have a schedule in a Confluence Table that states who is on IT Duty on which day.

Would such an automation even be possible in Jira?

We also have Scriptrunner and Jira Misc Workflow Extension.

What could be a workaround to send the SMS (potentially also E-Mail if SMS is not possible) only to the members that are on IT Duty for a given day after a new Jira ticket has been created?

Any tips / insights are highly appreciated!

Thanks in advance!

[Kai Becker]

Hi @Rafael Freymueller 

I don't think Confluence is a suitable format for storing such information, if you want to extract it for further usage. That's basically because of the HTML structure you will get via Confluence REST API.

So I would recommend storing it in another location. In terms of automation, what you could do: Create a lookup table with the relevant people and their number: https://community.atlassian.com/t5/Automation-articles/New-Automation-action-Create-lookup-table/ba-p/2311333

For sending sms you would probably need another service like twilio. Sending emails is built in as an action.

Hope this helps