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:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Community member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No
Community member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
sourche 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No