1 Reply Latest reply on Nov 10, 2016 10:15 AM by Steven Hawkins

    VDB to process WebService data source which responds with XML inside a String field as CDATA

    Sony Joseph Novice



      I am trying to get hands on JBoss VDB for first time.


      I have a use case where need to consider a webservice as a data source. This webservice returns the data inside a String field as a CDATA.


      <soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">


            <MySoapResponse xmlns="http://tempuri.org/">

               <MySoapResult><![CDATA[<?xml version="1.0"?>




        <TAG4  units="Hz">31.5Hz</TAG4>

        <TAG5  units="BPD">3084.31BPD</TAG5>








      I am not sure how to capture this to process the items as Column names with say, TAG4, TAG5 ..


      Any help would be highly appreciated.