Exchange rate Google App Sript example (EUR to UAH)

exchange_rate.js

function getEuroUahRate(date) {
  var str = Utilities.formatDate(date,'GMT+3', 'yyyyMMdd')
  var jsonArr = JSON.parse(UrlFetchApp.fetch('https://bank.gov.ua/NBUStatService/v1/statdirectory/exchange?date=' + str + '&json').getContentText())
  var json = null
  for (var i = 0; i < jsonArr.length; ++i) {
    if (jsonArr[i].cc == 'EUR') {
      json = jsonArr[i]
    }
  }
  if (json && json.rate) {
    return json.rate
  } else {
    return null
  }
}