1 Reply Latest reply: Nov 8, 2013 12:11 AM by odie_63 RSS

    XML Parsing with Tags increasing in no's

    588cd349-75cf-4a63-9da4-48fe8d56b09e

      I have an XML that I am recieving it from other system like below :

       

       

       

      <ResultSet>

       

       

        <ERROR_CODE_ID>0</ERROR_CODE_ID>

       

       

        <ERROR_DESCRIPTION>Success</ERROR_DESCRIPTION>

       

       

      <Rows>

       

       

      <Row1>

       

       

        <RATE_EFFECTIVE_DT>2013-08-24
      00:00:00.0</RATE_EFFECTIVE_DT>

       

       


      <INDEX_NAME>LN-EBOR-7D-AED              
      </INDEX_NAME>

       

       

        <TYPE>LN</TYPE>

       

       

        <RATE_TYPE>EBOR</RATE_TYPE>

       

       

        <TERM>7D</TERM>

       

       

        <TERM_NO>7</TERM_NO>

       

       

        <TERM_PERIOD>D</TERM_PERIOD>

       

       

        <CCY>AED</CCY>

       

       

        <RATE>0.15430000</RATE>

       

       

      </Row1>

       

       

      <Row2>

       

       

        <RATE_EFFECTIVE_DT>2013-08-26
      00:00:00.0</RATE_EFFECTIVE_DT>

       

       

        <INDEX_NAME>LN-EBOR- 1M-AED  
                 </INDEX_NAME>

       

       

        <TYPE>LN</TYPE>

       

       

        <RATE_TYPE>EBOR</RATE_TYPE>

       

       

        <TERM>1M</TERM>

       

       

        <TERM_NO>1</TERM_NO>

       

       

        <TERM_PERIOD>M</TERM_PERIOD>

       

       

        <CCY>AED</CCY>

       

       

        <RATE>0.52430000</RATE>

       

       

      </Row2>

       

       

      <Row3>

       

       

        <RATE_EFFECTIVE_DT>2013-08-25
      00:00:00.0</RATE_EFFECTIVE_DT>

       

       


      <INDEX_NAME>LN-EBOR-2M-AED              
      </INDEX_NAME>

       

       

        <TYPE>LN</TYPE>

       

       

        <RATE_TYPE>EBOR</RATE_TYPE>

       

       

        <TERM>2M</TERM>

       

       

        <TERM_NO>2</TERM_NO>

       

       

        <TERM_PERIOD>M</TERM_PERIOD>

       

       

        <CCY>AED</CCY>

       

       

        <RATE>0.66710000</RATE>

       

       

      </Row3>

       

       

      <Row4>

       

       

        <RATE_EFFECTIVE_DT>2013-08-24
      00:00:00.0</RATE_EFFECTIVE_DT>

       

       

        <INDEX_NAME>LN-EBOR-
      3M-AED             
      </INDEX_NAME>

       

       

        <TYPE>LN</TYPE>

       

       

        <RATE_TYPE>EBOR</RATE_TYPE>

       

       

        <TERM>3M</TERM>

       

       

        <TERM_NO>3</TERM_NO>

       

       

        <TERM_PERIOD>M</TERM_PERIOD>

       

       

        <CCY>AED</CCY>

       

       

        <RATE>0.86140000</RATE>

       

       

      </Row4>

       

       

      <Row5>

       

       

        <RATE_EFFECTIVE_DT>2011-05-23
      00:00:00.0</RATE_EFFECTIVE_DT>

       

       

        <INDEX_NAME>LN-EBOR-
      4M-AED             
      </INDEX_NAME>

       

       

        <TYPE>LN</TYPE>

       

       

        <RATE_TYPE>EBOR</RATE_TYPE>

       

       

        <TERM>4M</TERM>

       

       

        <TERM_NO>4</TERM_NO>

       

       

        <TERM_PERIOD>M</TERM_PERIOD>

       

       

        <CCY>AED</CCY>

       

       

        <RATE>0.0</RATE>

       

       

      </Row5>

       

       

      </Rows>

       

       

      </ResultSet>

       

      The data is comming in multiple row tag with Row1,Row2,Row3...so on.

      I am not able to parse the XML with Row1,Row2..etc. I need some help.