Cannot retrieve currency rates for TWD

[HirokazuNishi]

Preconditions

1. Magento2.2 and later
2. PHP, MySQL and other environment are not matter
3. Allow some currencies.

Steps to reproduce

1. Allow TWD from currency setup
2. Access to "Stores > Currency Rates"
3. Retrieve currency rates against all services
4. Rate cannot retrieve

Expected result

All services can retrieve TWD currency rate.

Actual result

1. Webservicex

2. YahooFinance

3. Fixer.io

[Kershrew]

I can receive rates from Fixer.io but not from Yahoo or Webservicex.
Magento 2.2.3

[bigbywolf-uk]

http://api.fixer.io/latest
"This API endpoint is deprecated and has now been shut down. To keep using the Fixer API, please update your integration to use the new Fixer API endpoint, designed as a simple drop-in replacement."

The API endpoint needs to be updated.

[mattf10]

In summary, there are no longer any working currency providers in M2. Fixer.io has a new version that requires a free API key. So the admin interface needs to be changed to accept the API key, and the url updated for fixer.io to work again. The other two (Yahoo, Webservicex) no longer work at all and should be dropped.

This issue should be marked with high priority since it means having to update currency rates manually every day until it's fixed.

[bigbywolf-uk]

After looking into it a bit more Fixer.io wouldn't work at all as the free plan only lets you use € as the base currency.

[mattf10]

It's EUR by default, but you can provide any base currency you want:

Rates are quoted against the Euro by default. Quote against a different currency by setting the base parameter in your request.
GET /latest?base=USD

See here: https://github.com/fixerAPI/fixer#readme

[bigbywolf-uk]

I believe that's only available on the paid plan.

"...Minor limitations include our new 1000 requests/month limit and EUR being the only available base currency for customers using a free account."

[mattf10]

You're right, I missed that. I just did a quick search and there are other free api services, but most appear to have the same limitation (can't change base currency).

Here are a few that don't appear to have this limitation:
https://www.amdoren.com/currency-api/
https://currex.info/

Can we look at using one of these?

[mattf10]

Ignore the above. Having a fixed base currency isn't a deal-breaker, it just means an extra step to to convert the API base into the store base.

For example, fixer.io forces base currency to be EUR. In my store, the base currency is GBP, but we also display prices in USD and AUD.

1. Convert API base to store base (EUR/GBP). Using today's rates, this is 0.876.
2. Get other rates from API using its base currency:
   USD/EUR = 0.849
   AUD/EUR = 0.6505
3. Now multiply the conversion factor to get rates in desired base currency:
   0.849 USD/EUR x 0.876 EUR/GBP = 0.745 USD/GBP
   0.6505 AUD/EUR x 0.876 EUR/GBP = 0.571 AUD/GBP

So I suggest we stick with fixer.io, but add in the above logic to first convert API base currency to shop base currency.

[oviliz]

This guy created a fixer.io alternative, fixerAPI/fixer#107 (comment)
It should be as easy as replacing api.fixer.io with exchangeratesapi.io/api in

magento2/app/code/Magento/Directory/Model/Currency/Import/FixerIo.php

Line 16 in 10f84fd

const CURRENCY_CONVERTER_URL = 'http://api.fixer.io/latest?base={{CURRENCY_FROM}}&symbols={{CURRENCY_TO}}';

Result: https://exchangeratesapi.io/api/latest?base=USD&symbols=EUR

[MaikelZwey]

I've noticed on exchangeratesapi.io/api that when EUR is the base currency and you have multiple currencies it won't work.
Since the base currency also gets included in the desired currency list.

Solution:
But if you replace http://api.fixer.io with https://frankfurter.app it works flawlessly, also with multiple currencies.

For example: https://frankfurter.app/latest?base=EUR&symbols=CHF,CNY,EUR,GBP,USD

[nsiebler-dm]

@MaikelZwey I get a forbidden when I open your link, I have to remove a symbol so seems there is a limit of 4. I'll try to use that though, thanks!

Also, here someone copy/pasted a module in a stackexchange thread: https://magento.stackexchange.com/questions/228588/free-currency-converter-fixer-io-stopped-working
I'm just not sure how reliable that service is or if this works with multiple currencies.