Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Using fx-exchange for exchange rate service in BC

Posted on by 15,433

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans