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="" xmlns="">

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


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



  <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