Salesforce Multi-currency: Automated Conversion Rate Update

In our previous blog, we talked about Advance Currency Management. If you think it is troublesome to update this daily/weekly/monthly, you can automate it by using the following approach:

1) Select a web service that can offer you a daily conversion rate. For example: https://rate-exchange.appspot.com/currency?from=AUD&to=MYR

This web service will return you the current conversion rate in JSON format. For example:

{"to": "MYR", "rate": 3.0456099999999999, "from": "AUD"}

2) Create an automated job that query the rate daily/weekly/monthly and update it into the DatedConversionRate object. The automated job can be done using Apex Scheduler or Integration frameworks such as Talend or Boomi.