Best free currency converter api code#

You also need to have a table of all the currencies that you want to change (FROM and TO), like below:Īnd then call the function above with the code below Table.AddColumn(Source, 'Rate', each GetExchangeRate(,)) Go to an organizational workspace, and create a dataflow Īdd New Entities, under Define Entities, and then choose Blank QueryĬopy and paste the script from above in there Īnd remember to set the paste your API Key in the script. Here is how you can do it: Create The Function in Dataflow Using that approach, you just have one API call per combination of rates from and rates to parameters. Then use the exchange table in merge with other tables. The method that I suggest, and it works for billions of records, is to use dataflows to create an exchange table. If you call this function in a table with 10,000 rows, it means it will be 10,000 API calls, which you need to get a paid version of the API for that. Why? This is a free API, and has the limitation of 100 calls. You can create the function above in Power Query in Power BI Desktop, and then use it in other tables, However, I strongly recommend to refrain from doing so. Remember that you have to paste your APIKey instead of the paste-your-api-key-here in the script above. #'Converted to Table' = Record.ToTable(Source), Source = Json.Document(Web.Contents('',)), Source = (#'From Currency' as text,#'To Currency' as text) as number=> The function mainly just expand to the result value. So I ended up using this URL and building a Power Query function that does the conversion using the the API. Then it works with a URL such as below to give you the Exchange rate: You need to get a free API Key first Īfter entering your email address, the API key will be emailed to you. Yes, absolutely free, and the good news is that it works perfectly fine. Currenc圜 is one of the websites that offers you a FREE currency converter API. There are many websites and services for currency exchange rate tables. This post is about a function that gives you the latest currency rate using Power BI and Power Query. You either need to keep an up-to-date table of all new currency rates and use that in your Power BI solution, or use a function that gets the rate from one of the live services. So, read through this blog and research the best currency exchange API that will work for your business.If you ever need to convert amounts from one currency to another, you face the challenge that currency rates are not constant.

Best free currency converter api update#

When choosing your currency converter API, you might also want to consider your budget, company requirements, update frequency, and data sources.īesides, try to find APIs that support at least 150 plus currencies and offer you accurate information and customer support. Moreover, it is the best free currency converter API that offers hourly updates and historical data. The dedicated support and bank-level security it offers make it safe and trusted. It uses a simple and lightweight API, JSON API, to enable you to convert currency in real-time.

While these are the top 5 currency converter API, we recommend Fixer. You get access to more than 154 currencies, and it provides you with conversions that are up to date and reflect the fluctuations in the market.įurthermore, the API is secured with HHTPS, which ensures your privacy, and protects your data. Moreover, the currency rate updates every 10 minutes to provide you with real-time forex data. It provides data from trusted data sources like central banks and authority sources. IBAN’s Forex Reference Suite is a SAAS solution and is the best-automated currency conversion API.