Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

Using fx-exchange for exchange rate service in BC

Posted on by 15,419

Hi 

I know many US companies uses floatrates as exchange rate service. But I wonder if you can help me to setup fx-exchange.com for this purpose. This way since they support many currencies it can be used in many countries. Basically all user need to do is get the RSS for their currency and that is it. 

the USD link is like this www.fx-exchange.com/.../rss.xml

The output is like below. My questions are

1) How I design transfer rule to get the currency code from this text? I mean the length of text can change based on the name. Is it any method that transfer rule start from character 2 at the end of the text and go back 3?  "<title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>"

2) How to setup transfer rule to convert this text date to actual date? "  <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>"

3) How to setup transfer rule to get the currency rate from this info? " <description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>"

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="">http://www.w3.org/2005/Atom">
    <channel>
        <title>US Dollar(USD) Currency Exchange Rates</title>
        <link>www.fx-exchange.com/.../</link>
        <description>The latest currency exchange rates for US Dollar(USD)</description>
        <lastBuildDate>Wed Mar 9 2022 15:21:54 UTC </lastBuildDate>
        <language>en</language>
        <copyright>Copyright© 2022 Currency Exchange Rates, www.fx-exchange.com/ </copyright>
        <ttl>15</ttl>
        <item>
            <title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>
            <link>www.fx-exchange.com/.../aed.html</link>
            <guid>www.fx-exchange.com/.../aed.html</guid>
            <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
            <description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>
            <category>US Dollar</category>
        </item>
        <item>
            <title>US Dollar(USD)/Netherlands Antillean Guilder(ANG)</title>
            <link>www.fx-exchange.com/.../ang.html</link>
            <guid>www.fx-exchange.com/.../ang.html</guid>
            <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
            <description>1 US Dollar = 1.8026 Netherlands Antillean Guilder</description>
            <category>US Dollar</category>
        </item>
        <item>
            <title>US Dollar(USD)/Argentine Peso(ARS)</title>
            <link>www.fx-exchange.com/.../ars.html</link>
            <guid>www.fx-exchange.com/.../ars.html</guid>
            <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
            <description>1 US Dollar = 108.678 Argentine Peso</description>
            <category>US Dollar</category>
        </item>
        <item>
            <title>US Dollar(USD)/Australian Dollar(AUD)</title>
            <link>www.fx-exchange.com/.../aud.html</link>
            <guid>www.fx-exchange.com/.../aud.html</guid>
            <pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>
            <description>1 US Dollar = 1.3645 Australian Dollar</description>
            <category>US Dollar</category>
        </item>

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans