How can I get an embedded xml string into structured elements?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • michaelloveusa
    New Member
    • Apr 2012
    • 1

    How can I get an embedded xml string into structured elements?

    I am getting a response back from a webservice that has xml data embedded in a string. I need to get that data out and into xml elements so I can use parts of the data. Is there a way to do this? XML response is shown below.

    Code:
          <GetAmountDueResponse xmlns="http://www.manatron.com">
             <GetAmountDueResult><![CDATA[<amountsdue resultstatus="0" resultdescr="Successful" xmlns="http://www.changemeback.com/schemas/AmountsDue">
      <revobjs>
        <revobj id="271968" pin="033719689" lendershortdescr="" lenderdescr="" serviceshortdescr="" servicedescr="" dirtyreadchecksum="1628" situsfreeformaddr="18151 E 6TH AVE" situscitystatezip="AURORA, CA 82311-9402" situsstreetnumber="18151" situsstreetnumbersfx="" situspredirectional="East" situsstreetname="6TH" situsstreettype="Avenue" situspostdirectional="" situsunittype="" situsunitnumber="" situscity="AURORA" situstateabbrev="CA" situspostalcd="82311-9402" />
      </revobjs>
      <parties>
        <party id="271968006" revobjid="271968" name="MODULAR SPACES" nameprefix="" firstname="" middlename="" lastname="MODULAR SPACES" namesuffix="" attention="MODULAR SPACES" legalpartytype="102055" legalpartytypedesc="Proprietorship" addresstype="101600" deliveryaddr1="1200 SWEDESFORD RD" deliveryaddr2="BERWYN PA  19312-1078" address="1200 SWEDESFORD" citystatezip="BERWYN, CA 23312-1078" streetnumber="1200" predirectional="" streetname="SWEDESFORD" streettype="RD" postdirectional="" unittype="" unitnumber="" city="BERWYN" state="California" stateabbrev="CA" zipcode="23312-1078" country="" />
      </parties>
      <taxbills>
        <taxbill id="6714081" revobjid="271968" taxyear="2009" billnumber="200903371968901" tscertificatenumber="" dirtyreadchecksum="1628">
          <duedates>
            <duedate inst="1" datedue="3/2/2009" fulldatedue="4/30/2009" />
            <duedate inst="2" datedue="6/15/2009" fulldatedue="4/30/2009" />
          </duedates>
          <flags>
            <flag flagobjecttype="100252" id="15008893" />
          </flags>
        </taxbill>
      </taxbills>
      <allocs>
        <alloc revobjid="271968" taxbillid="6714081" rolltype="1000002" revenuesource="290019" type="290085" cd="290090" inst="1" amount="2897.88" fullamount="2897.88" />
        <alloc revobjid="271968" taxbillid="6714081" rolltype="1000002" revenuesource="290019" type="290085" cd="290090" inst="2" amount="2897.85" fullamount="2897.85" />
        <alloc revobjid="271968" taxbillid="6714081" rolltype="1000002" revenuesource="290019" type="290087" cd="1000501" inst="1" amount="5.00" fullamount="5.00" />
        <alloc revobjid="271968" taxbillid="6714081" rolltype="1000002" revenuesource="290019" type="290087" cd="1000501" inst="2" amount="5.00" fullamount="5.00" />
      </allocs>
    </amountsdue>]]></GetAmountDueResult>
          </GetAmountDueResponse>
    Last edited by michaelloveusa; Apr 30 '12, 10:02 PM. Reason: That didn't work!
Working...