Currency Converter Scripting Now Requires Account with exchangeratesapi.io

[Dominic_Rannie]

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

[Dominic_Rannie]

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

[Edward_Riley]

Hi Dominic,

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

Many thanks

Ed

[ScottWorld]

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:

Integromat

Currency Integrations

Use Integromat to automate currency conversion for your favorite apps - including Shopify, QuickBooks, Xero, WooCommerce, and more.

Integromat

Airtable Integrations

Part spreadsheet, part database, and entirely flexible.

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

[Dominic_Rannie]

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

[GavinA]

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