Currency Converter Scripting Now Requires Account with exchangeratesapi.io

Hi,

Anybody else noticed that the Currency converter scripting block provided as a template when you add a new Scripting App no longer works. The fetch(‘https://api.exchangeratesapi.io/latest?base=USD’) endpoint has changed and also requires an access key.

Their api documentation (Exchange Rates API) now shows that the following endpoint needs to be used:

https://api.exchangeratesapi.io/v1/latest?access_key = API_KEY

This works once you have a valid access key, however, it appears that you can only pull the EUR default base currency on the free plan. When I tried to use ‘&base=USD’ I git the following response:

{“error”:{“code”:“base_currency_access_restricted”,“message”:“An unexpected error ocurred. [Technical Support: support@apilayer.com]”}}

I am not sure who maintains these example scripts, but this one needs looking at.

Anybody know of an alternative api for currently conversion that would be completely free and allow base currencies to be changed? Only very low call rates needed.

Regards,
Dominic

I have found the following exchange rate service that could be helpful and seems to allow one to change the base currency without an account.

https://api.ratesapi.io/api/latest?base=USD

Hi Dominic,

I’ve been having the same issues, replacing the API URL with your suggestion fixes the error!

Many thanks

Ed

1 Like

I would email support@airtable.com about updating their script.

In the meantime, Integromat is a low-code/no-code automation tool that offers free currency conversion, and they have full Airtable support:

p.s. I am a professional Airtable consultant and an Integromat Partner, and the Integromat links contain my partner referral code.

Thanks Scott, I did raise this with support as well and they said the appropriate team would be alerted.

1 Like