#set($baseCurrency = $parameters.baseCurrency) ## Define the API URLs #set($exchangeRateApiUrl = "https://open.er-api.com/v6/latest/$baseCurrency") #set($flagApiBaseUrl = "https://flagsapi.com/") ## Fetch exchange rate data #set($exchangeResponse = $RequestManager.get($exchangeRateApiUrl)) ## Check if data fetch was successful #if($exchangeResponse) #set($exchangeData = $exchangeResponse.rates) ## Major currencies list (customizable) #set($majorCurrencies = ["USD", "EUR", "GBP", "JPY", "CHF", "CAD", "AUD"]) ## Updated header ## Loop over the available currencies in the response and display only major currencies, excluding the base currency #foreach($currency in $exchangeData.keySet()) #if($currency != $baseCurrency) ## Skip the base currency ## Check if the currency is in the majorCurrencies list by manual iteration #set($isMajorCurrency = false) #foreach($majorCurrency in $majorCurrencies) #if($currency == $majorCurrency) #set($isMajorCurrency = true) #end #end ## Display only if it's a major currency #if($isMajorCurrency) ## Rounding rate to 2 decimal places #end #end #end

Currency	Rate ($baseCurrency)
#if($currency == "EUR") $currency #else $currency #end	$MathTool.roundTo(3, $exchangeData.get($currency))

#else

Failed to retrieve exchange rates.

#end

Currency Exchange Rates — Confluence Cloud Macro

You May Also Like