How to trigger the automation rule when Database Table is Refreshed

[Sam]

I am maintaining Assignee, Reporter and some other fields data in a Table .so, whenever this table is refreshed i need to update the data of old issues also. Is there any possibility to execute my automation rule when database table is refreshed

[Humashankar VJ]

Hi @Sam 

While Jira Automation rules can't be directly triggered by an external database refresh, you can give a try by involving an external script or integration.

• Try set up a process that detects when the database table is refreshed, such as a database trigger, scheduled job, or script. To learn more - Jira automation triggers | Cloud automation Cloud | Atlassian Support
• This process can then use the Jira REST API to update issues by making a PUT request to update issue fields based on the latest database values.

Create a PUT request to update issue fields, below given is an example.

json

{

  "fields": {

    "assignee": {"name": "new_assignee"},

    "reporter": {"name": "new_reporter"}

  }

}

To learn more about the above action - Updating an Issue via the JIRA REST APIs 6848604 

Finally, you can use Jira's Incoming Webhook trigger to start an automation rule when the external script notifies Jira, allowing you to extract data from the webhook payload and update fields using the Edit Issue action.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards