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.

Also you check this example which is done some recently and same as yours ie., xml contains cdata and it contains json.http://stackoverflow.com/questions/35623183/soapui-how-to-find-node-count-in-json-response/35626696#35626696 Other examples to get the json data http://stackoverflow.com/questions/35752235/soap-ui-assertion-help-to-validate-total-attribute-and-total-value/35753483#35753483 https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/AssertJsonArrayElement.groovy

Hi, Where you say names that are more than 500, what exactly do you mean? And how do you want the output of the extraction to be? For eaxample, if you mean extract JSON documents (maybe log or store in a variable) which have a 'number' property >500 then that should be fairly OK to do in a Groovy script. Let me know, Rup

Hi Rup, When I say names more than 500 it means the count of names,I have more than 500 blocks or chunks of names to be extracted.Still I have not got there yet I am first trying to extract the data from the CData But encountering the following message. groovy.lang.MissingPropertyException: No Such Property: messageExchange for class: Script8 error at line 3import com.eviware.soapui.support.XmlHolder respXmlHolder = new xmlHolder(messageExchange.getResponseContentAsXml()) respXmlHolder.declareNamespace("ns1","http://tempuri.org/") CDATAXml = respXmlHolder.getNodeValue("//ns1:Result") log.info(CDATAXml)Please let me know where I am going wrong. Are there any links for the same where I can get some assistance in debugging such errors. Thanks,SD

first of all it should be 'XmlHolder', and is case sensitive.

Hi SD, Ok, so basically if the count of those Report JSON documents goes above 500, then we capture 501+ etc. OK, maybe we should work on it a step at a time. 1) First we can try to extract the report JSON documents from the response CDATA. 2) Then, we can use JSON Slurper to parse the JSON data into report objects. 3) Then we can try to extract just the report objects where the count is >500 In terms of the error you're getting, at first glance it looks like you're not running the script from a Script Assertion? The messsageExchange variable is only available to script run there:

Extracting data from CData in SOAP Response

23 Replies

rupert_anderson
Valued Contributor
10 years ago
Hi,

Where you say names that are more than 500, what exactly do you mean? And how do you want the output of the extraction to be?

For eaxample, if you mean extract JSON documents (maybe log or store in a variable) which have a 'number' property >500 then that should be fairly OK to do in a Groovy script.

Let me know,

Rup
- Sphujidhwaj
  Contributor
  10 years ago
  Hi Rup,
  
  When I say names more than 500 it means the count of names,I have more than 500 blocks or chunks of names to be extracted.
  Still I have not got there yet I am first trying to extract the data from the CData
  But encountering the following message.
  
  groovy.lang.MissingPropertyException: No Such Property: messageExchange for class: Script8 error at line 3
  import com.eviware.soapui.support.XmlHolder respXmlHolder = new xmlHolder(messageExchange.getResponseContentAsXml()) respXmlHolder.declareNamespace("ns1","http://tempuri.org/") CDATAXml = respXmlHolder.getNodeValue("//ns1:Result") log.info(CDATAXml)
  Please let me know where I am going wrong. Are there any links for the same where I can get some assistance in debugging such errors.
  
  Thanks,
  SD
  - nmrao
    Community Hero
    10 years ago
    Also you check this example which is done some recently and same as yours ie., xml contains cdata and it contains json.
    
    http://stackoverflow.com/questions/35623183/soapui-how-to-find-node-count-in-json-response/35626696#35626696
    
    Other examples to get the json data
    
    http://stackoverflow.com/questions/35752235/soap-ui-assertion-help-to-validate-total-attribute-and-total-value/35753483#35753483
    
    https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/AssertJsonArrayElement.groovy