Forum Discussion

oanam's avatar
oanam
Helper I
5 years ago
Solved

Currency code not found

Hi,

 

I have an xe.com connection ( https://www.xe.com/currencytables/?from=GBP ) established a few months ago and I already built some measures on it using the rate of the currency exchange. All of a sudden, this error comes up and the 'Currency Code' column seems nowhere to be found from the source:

When I try to reestablish the web connection using the link above (https://www.xe.com/currencytables/?from=GBP which worked in the past), this shows up :

My question is:

1. How can I fix it? Does this happen because xe.com might have changed the names of the table columns or simply restricted its access to users?

2. How can I find all calculations I created using 'Currency code' (which doen't load anymore) in my fields so that I delete them because now my whole report doesn't refresh anymore and I am stuck.

 

Thank you very much !

  • yes, the API has a cost. Maybe you can find other FX sites that offer a free API.

3 Replies

  • You don't seem to be using their API connection. Have you been web scraping this until now?

    • oanam's avatar
      oanam
      Helper I

      Hi, I was using the web connector all this time which seemed to work fine until now. I will investigate more on the API - is this a service you need to pay for?

  • yes, the API has a cost. Maybe you can find other FX sites that offer a free API.