json - How can I get a time series of current exchange data and display in Grafana

Question

I am trying to make a panel in grafana by querying an API provided by https://api.exchangeratesapi.io/.

The API URL: https://api.exchangeratesapi.io/history?start_at=2018-01-01&end_at=2021-01-26&base=USD&symbols=HKD

By accessing the API, I can get data like this:

{
   "rates":{
      "2020-11-02":{
         "HKD":7.7520597322
      },
      "2018-10-09":{
         "HKD":7.8347179711
      },
      "2020-11-09":{
         "HKD":7.7529243457
      },
      "2018-11-30":{
         "HKD":7.8220794084
      },
      "2019-02-11":{
         "HKD":7.847731895
      },

question from:https://stackoverflow.com/questions/65952800/how-can-i-get-a-time-series-of-current-exchange-data-and-display-in-grafana

Answer 1

Waitting for answers