Forum Discussion

Sphujidhwaj's avatar
Sphujidhwaj
Contributor
9 years ago

Extracting data from CData in SOAP Response

I have a Soap Request XML which takes JsonString as input and in the output I get the response XML in the below format.

 

<ReportResponse xmlns="http://tempuri.org/">
         <ReportResult><![CDATA[{
  "Report": [
    {
      "Name": "ABC",
      "Number": "123",
      "Type": "XYZ",
      "Desc": "EFGH",
      "Group Name": "Name123",
      "Group Number": "123",
      "End Date": "12/30/2014",
      "Due Date": "04/15/2015",
      "Completion Date": null,
      "Status": "Status1",
      "Received Date": "",
      "Delivery Date": "",
      "Location": "",
      "Role": "",
     },
	 {
      "Name": "EFG",
      "Number": "123",
      "Type": "XYZ",
      "Desc": "EFGH",
      "Group Name": "Name123",
      "Group Number": "123",
      "End Date": "12/30/2014",
      "Due Date": "04/15/2015",
      "Completion Date": null,
      "Status": "Status1",
      "Received Date": "",
      "Delivery Date": "",
      "Location": "",
      "Role": "Manager",
     },

I want to extract the names which are more than 500. What is the way to extract names?  

"Name": "ABC",

Please help me.