Forum Discussion

Dizzo's avatar
Dizzo
Occasional Contributor
8 years ago

Need help with XmlSlurper

Hello guys,   I hope you can help me with parsing xml report by Groovy XmlSlurper. I need to get maximum date of issuance of ID card. Can anybody help, im noob in this, it's so hard to me.     ...
  • PaulMS's avatar
    PaulMS
    8 years ago

    XmlHolder was easier because I wasn't sure about sorting nodes in XmlSlurper.

     

    To filter the nodes and sort the dates in an array

     

    def xml = new XmlSlurper().parseText(response)
docs = xml.Result.Root.IdentificationDocuments.Document.findAll { it.Name.@value == 'ID card' && it.DateOfIssuance.@value != '-' }
dates = []
docs.each {dates.add it.DateOfIssuance.@value.text()}
log.info dates.sort { Date.parse('dd.MM.yyyy', it ) }.reverse()[0]
Dizzo's avatar
Dizzo
Occasional Contributor

Thank you, for helping, but how can i do this with out 

 

import com.eviware.soapui.support.XmlHolder

 

PaulMS's avatar
PaulMS
Super Contributor
8 years ago

XmlHolder was easier because I wasn't sure about sorting nodes in XmlSlurper.

 

To filter the nodes and sort the dates in an array

 

def xml = new XmlSlurper().parseText(response)
docs = xml.Result.Root.IdentificationDocuments.Document.findAll { it.Name.@value == 'ID card' && it.DateOfIssuance.@value != '-' }
dates = []
docs.each {dates.add it.DateOfIssuance.@value.text()}
log.info dates.sort { Date.parse('dd.MM.yyyy', it ) }.reverse()[0]
  • Dizzo's avatar
    Dizzo
    Occasional Contributor
    8 years ago

    Hello

     

    This part doesn't work :smileysad:

    log.info dates.sort { Date.parse('dd.MM.yyyy', it ) }.reverse()[0]

     Caught: groovy.lang.MissingPropertyException: No such property: log for class: xmlParse1
    groovy.lang.MissingPropertyException: No such property: log for class: xmlParse1
    at xmlParse1.run(xmlParse1.groovy:91)

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Dizzo, have you check my reply?
      • Dizzo's avatar
        Dizzo
        Occasional Contributor
        8 years ago

        Yes, i checked, it looks almost as needed.

        Can you make it just for key 7. I need just one value, not array.

        Thank you a lot.