Finance - Exchange rate

Use case

This is particularly useful for teams managing quotes, proposals or costs in Jira and dealing with multiple currencies.

See this field in action from our demo portal

Configuration

Datasource

This demo uses 2 datasources:

• the REST API of https://www.alphavantage.co as data source.

• a list of currencies, in a CSV file, also served by alpha vantage.

Datasources configuration:

• REST API

  • Type: URL

  • URL: https://www.alphavantage.co

  • Authentication: None

  • Content-Type: JSON

• CSV File

  • Type: URL

  • URL: https://www.alphavantage.co/physical_currency_list

  • Authentication: None

  • Content-Type: CSV

  • First line is title: Yes

  • Cell separator: ,

  • Quote char: "

  • Content-Charset: UTF-8

Fields

"Exchange rate" is a Snapshot Text field: we want to get the exchange rate when the issue is created, but we don't want it to be updated after.

The other fields are of type Live Text.

Download the fields configuration: