Forum Discussion

SuperSingh's avatar
SuperSingh
Contributor
8 years ago

How to extract & validate nodes from JSON which is part of XML response

I have response in XML format that contains metadata (which is in JSON).I need to extract the values from JSON and validate them. Can someone please help me with script to extract the JSON nodes . ...
  • PaulMS's avatar
    PaulMS
    8 years ago

    Script assertion would be

     

     

     

    import com.eviware.soapui.support.XmlHolder
def holder = new XmlHolder(context.Response)
def Metadata = holder["//*:Metadata"]
log.info Metadata

import groovy.json.JsonSlurper 
def slurper = new JsonSlurper()
def json = slurper.parseText Metadata
log.info(json.ID[0])

     

    However your sample XML response seems to include invalid JSON so I changed the last line to

     

    log.info(json.ID)

     

SuperSingh's avatar
SuperSingh
Contributor

I have one more question here, associated with the same post ? Sorry to not add it earlier.

 

 How can I do a search for the value if the response  data is not in sequence.

 For. Eg.  if this is my Metadata,

 

 <Metadata>

{

"Type": "Type3",

"ID": "Name3",

"Label": "Text3",

},

{

"Type": "Type2",

"ID": "Name2",

"Label": "Text2",

}

{

"Type": "Type2",

"ID": "Name2",

"Label": "Text2",

}

 

And I have to extract value of "Label" for "Type3" , how do I do that. (I cannot set it based on json.ID[0] coz the order might vary)

nmrao's avatar
nmrao
Champion Level 3
8 years ago
Json wrapped inside of xml and is invalid as PaulMS already mentioned. Could be potential application defect.

You may need to contact your service provider / your team if it is internally developed.