Skip to main content

Notifications

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.

Setup fx-exchange.com as a exchange service in BC

Posted on by 15,428

Hi

I know many USA BC users use floatrates.com (we do the same). But I wonder if we can use website such as https://www.fx-exchange.com/usd/rss.xml 

The rss link output is like below and I have following challenges here 

1) Getting currency code. What is transformation rule look like to get the currency from " <title>US Dollar(USD)/United Arab Emirates Dirham(AED)</title>" I mean each line length change and I cannot code it to get to AED in this example. I do not know the code that tell the system to start from 2 characters from end of the line and go back 3. 

2) Seems like publish date is text. Which transform rule can change this from text to date "<pubDate>Wed Mar 9 2022 15:21:54 UTC </pubDate>"

3) How to tell system to get the currency rate from this line? What is the rule? "<description>1 US Dollar = 3.673 United Arab Emirates Dirham</description>"

Thanks 

<?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>

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,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans