AnsweredAssumed Answered

xml parsing

Question asked by kamal1234 on Aug 30, 2016
Latest reply on Aug 31, 2016 by beverly

Dear community members,

 

I want to fetch the currency and rate from the following xml.

Is there any method or custom function to achieve it.

 

<?xml version="1.0" encoding="UTF-8"?>

<gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns="http://www.ecb.int/vocabulary/2002-08-01/eurofxref">

  <gesmes:subject>Reference rates</gesmes:subject>

  <gesmes:Sender>

  <gesmes:name>European Central Bank</gesmes:name>

  </gesmes:Sender>

  <Cube>

  <Cube time='2016-08-30'>

  <Cube currency='USD' rate='1.1168'/>

  <Cube currency='JPY' rate='114.27'/>

  <Cube currency='BGN' rate='1.9558'/>

  <Cube currency='CZK' rate='27.025'/>

  <Cube currency='DKK' rate='7.4448'/>

  <Cube currency='GBP' rate='0.85170'/>

  <Cube currency='HUF' rate='308.97'/>......

 

 

 

Thank you

Kamal.

Outcomes