Unanswered

HTTP Request to XML

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Sort by

JS-27041152-0 on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
JS-27041152-0 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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