Unanswered

HTTP Request to XML

(0) Share

Report

Posted on by Community Power Pla...

hi,

I try to get data from XML File, with Microsoft Flow. I searched but ı didn't learn enough knowledge. "http://www.tcmb.gov.tr/kurlar/today.xml " website is contain exchange rate, and ı must get it data to my sharepoint list. How to create Flow?

Thank you...

Categories:

Connecting to Data

General Questions

All responses (4)

Answers (0)

sourche 2 on at

Like (0)

Report

Re: HTTP Request to XML

Hi,

Method: GET
URL: https://www.tcmb.gov.tr/kurlar/today.xml
Sample Xml Body
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="isokur.xsl"?>
<Tarih_Date Tarih="21.10.2022" Date="10/21/2022" Bulten_No="2022/201" >
<Currency CrossOrder="0" Kod="USD" CurrencyCode="USD">
<Unit>1</Unit>
<Isim>ABD DOLARI</Isim>
<CurrencyName>US DOLLAR</CurrencyName>
<ForexBuying>18.5741</ForexBuying>
<ForexSelling>18.6076</ForexSelling>
<BanknoteBuying>18.5611</BanknoteBuying>
<BanknoteSelling>18.6355</BanknoteSelling>
<CrossRateUSD/>
<CrossRateOther/>
</Currency>
<Currency CrossOrder="9" Kod="EUR" CurrencyCode="EUR">
<Unit>1</Unit>
<Isim>EURO</Isim>
<CurrencyName>EURO</CurrencyName>
<ForexBuying>18.1246</ForexBuying>
<ForexSelling>18.1573</ForexSelling>
<BanknoteBuying>18.1119</BanknoteBuying>
<BanknoteSelling>18.1845</BanknoteSelling>
<CrossRateUSD/>
<CrossRateOther>0.9758</CrossRateOther>
</Currency>
</Tarih_Date>

Euro Value : float(first(xpath(xml(body('TodayExchangeRates')),'Tarih_Date/Currency[@Kod="EUR"]/ForexSelling/text()')))
Usd Value :
div(variables('EuroValue'),float(first(xpath(xml(body('TodayExchangeRates')),'Tarih_Date/Currency[@Kod="USD"]/ForexSelling/text()'))))

Regards,
Mehmet Şirin ÇELİK
SameerCh on at

Like (0)

Report

Re: HTTP Request to XML

The issue is that, from the Flow designer (UI), you still will not be able to construct the underlying expression - like the one suggested below.
Community Power Pla... on at

Like (0)

Report

Re: HTTP Request to XML

Hi SameerCh,

thank you for your answer,

Someone has suggested a method , to split the body into sharepoint columns. he said, For example to ForexSelling Item:

"@ {body ('ForexSelling'). Json.path.to.value} "

But didn't work it.

Do you have any idea?

Thank you 🙂
SameerCh on at

Like (0)

Report

Re: HTTP Request to XML

You can use the forum ideas to vote for this feature.

While the underlying platform do support this (Look at Logic Apps @json, @xpath function), it looks like we cannot do this from the Flow designer today.