0 Replies Latest reply on Jun 2, 2019 11:12 PM by Sourabh Bindal

    Loading Soap response XML data into table?

    Sourabh Bindal New Member

      Hello Team,

       

      I am getting the below XML data from the sharepoint list via http transformation. I need to convert this XML data and populate in to the table. I am using XML Parser Transformation to convert this XML data but getting the NULL as column output in the table.(parser reads that it has 4 rows but inserts NULL instead of data)

       

      <?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:C2F41010-65B3-11d1-A29F-00AA00C14882'     xmlns:rs='urn:schemas-microsoft-com:rowset'     xmlns:z='#RowsetSchema'>

      <rs:data ItemCount="4">  

      <z:row ows_Source_x0020_System='NAVEX' ows_aw2i='Addition of 25 Column' ows_mu9t='Shettigar, Yadava' ows_z7tm='Add' ows__x0072_nh6='Pending'/>  

      <z:row ows_Source_x0020_System='T360' ows_aw2i='T360 Database Restoration' ows_mu9t='Shettigar, Yadava' ows_z7tm='T360 Database Restoration -' ows__x0072_nh6='Pending'/>  

      <z:row ows_Source_x0020_System='HR' ows_aw2i='HR File' ows_mu9t='Shettigar, Yadava' ows_z7tm='HR File' ows__x0072_nh6='Pending' />  

      <z:row ows_Source_x0020_System='NA' ows_aw2i='DBA' ows_mu9t='Bindal, Sourabh - Dell Team' ows_z7tm='DBA' ows__x0072_nh6='Pending'/>  

      </rs:data>

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

       

       

      I also tried to preview the data in this xml as source also, its showing data in columns as null(but i can see data in xml file).

      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 or let me how to parse this soap xml output? Any help would be greatly appreciated.

       

      Thanks & Regards:

      Sourabh Bindal