Currency code not found

[oanam]

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 !

[lbendlin · Accepted solution]

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

[lbendlin]

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

[oanam]

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?