Automation Query

[Seenivasan K]

I'm working on the project, which is company managed and i have a backend (ticket) issue key called "CC-4" which I want to store Weekly conversion Rates for various currencies like

Euro Conversion Rate

USD Conversion Rate

AED Conversion Rate

GBP Conversion Rate

OMR Conversion Rate .

This process should be done using Exchange rate API key. How it can be done using automation.

[Kai Becker · Accepted solution]

Hi @Seenivasan K 

welcome to the community and thanks for your question.
You will need to create an Automation rule with the following parts:

1. Trigger: Scheduled (fixed rate for week or cron)
   1. 1. JQL to filter key=CC-4 that only matches your issue
2. Action: Web Request: 
   • URL:  

     https://api.exchangeratesapi.io/v1/latest?access_key=API_KEY

3. Action: Edit Issue
   • Parse the webResponse and store the Values to separate fields or the description
   • To access a value (replace <CURRENCY> with your desired one)

     {{webhookResponse.body.rates.<CURRENCY>}}

   • Documentation: https://exchangeratesapi.io/documentation/