Hello!
My flow uses a custom connector to get the exchange rate between US$ and other currencies, and update that information later.
The custom connector give me the exchange rate and a bunch of other stuff in XML.
For the example in the picture below, I'm converting from US to CAD and the number I need here is "1.2689".
I tried this formula but I get nothing.
Any help is appreciated!
XML CONTENT
<?xml version="1.0" encoding="UTF-8"?>
<rdf:RDF
<title>Daily exchange rates</title>
<description>Daily average exchange rates - published once each business day by 16:30 ET. All Bank of Canada exchange rates are indicative rates only.</description>
<items>
<rdf:Seq>
</rdf:Seq>
</items>
<dc:language>en</dc:language>
</channel>
<title>CA: 1.2689 CAD = 1 USD 2021-02-10</title>
<description>1 USD = 1.2689 CAD (US dollar to Canadian dollar daily exchange rate)</description>
<dc:date>2021-02-10T21:30:00Z</dc:date>
<dc:language>en</dc:language>
<cb:statistics>
<cb:country>CA</cb:country>
<cb:exchangeRate>
<cb:value decimals="4">1.2689</cb:value>
<cb:baseCurrency>CAD</cb:baseCurrency>
<cb:targetCurrency>USD</cb:targetCurrency>
<cb:rateType>Bank of Canada exchange rate</cb:rateType>
<cb:observationPeriod frequency="daily">2021-02-10T21:30:00Z</cb:observationPeriod>
</cb:exchangeRate>
</cb:statistics>
</item>
</rdf:RDF>
Share
Report
All responses (
Answers (
8,422
