5 Replies Latest reply on Aug 31, 2016 5:55 AM by beverly

    xml parsing

    kamal1234

      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.