In this article we will be using a free JSON API for foreign exchange rates and currency conversion from fixer. It provides many relevant JSON API and can be accessed via HTTP GET request. So in this use case we want to get the currency conversion rates for various currencies to a base currency, let's say USD.
This is how our sample source data looks like:
COUNTRY|SALES|CURRENCY SGP|10000|SGD IND|125000|INR AUS|9000|AUD USA|12000|USD
Please check the self explanatory implementation screenshots as below: