Apr 13, 2021 04:08 AM
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
Apr 13, 2021 04:31 AM
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.
Apr 13, 2021 05:29 AM
Hi Dominic,
I’ve been having the same issues, replacing the API URL with your suggestion fixes the error!
Many thanks
Ed
Apr 13, 2021 06:11 AM
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.
Apr 13, 2021 06:23 AM
Thanks Scott, I did raise this with support as well and they said the appropriate team would be alerted.
Sep 24, 2021 07:44 AM
We’ve tried to package any exchange needs into a marketplace app Currency Converter - Apps - Airtable Marketplace. Is there anything that it may be missing which only scripting can solve? We’d love to be able to make it a feature