Skip to main content
Business Central forum
Unanswered

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

editSubscribe (0) ShareShare
ReportReport
Posted on by 15,395

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

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans