11 Replies Latest reply on May 29, 2019 9:39 PM by Sourabh Bindal

    How to convert the XML data ?

    Amit Jain Active Member

      Hello Team,

       

      I am getting the below XML data from the web service. I need to convert this XML data and populate in to the table. I am using XML Parser Tarsformation to convert this XML data but getting the NULL output in the table.

       

      <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetListItemsResponse xmlns="http://schemas.microsoft.com/sharepoint/soap/"><GetListItemsResult><listitems xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'

           xmlns:dt='uuid:C2GHJ1010-65BBB3-11ddd1-A29F-200AAC882'

           xmlns:rs='urn:schemas-microsoft-com:rowset'

           xmlns:z='#RowsetSchema'>

      <rs:data ItemCount="2">

         <z:row Attachments='0' ProNumber='S-0001' ProTitle='S-0001' InvProduct='P01' TArea='test test 123' India_A='cne' TType='Interventional' Created='2015-03-05 13:35:55' />

         <z:row Attachments='0' ProNumber='S-0002' ProTitle='S-0002' InvProduct='P01' TArea='test test 123' India_A='cne' TType='Interventional' Created='2015-03-05 15:41:11' />

         </rs:data>

      </listitems></GetListItemsResult></GetListItemsResponse></soap:Body></soap:Envelope>

       

      Note: The above Data is present in .xml file. I don't have .xsd and .dtd file as web service team does not have these files.

       

      Can you please tell me the solution to achieve this scenario ?

       

      Thanks & Regards:

      Amit Jain