Forum Discussion

Mis3's avatar
Mis3
Frequent Contributor
4 years ago

Output some selected parameters of XML response to a log file

I tried to output certain parameters of a XML response (below) to a log file. The parameters I like to output:  CoSID, PIN, iPhoneDevice, etc.   Not sure how to do this.   def xmlResponse = tStep....
  • nmrao's avatar
    nmrao
    4 years ago

    Looks the data fields are unique in this case; so easy to extract with a simple closure.

     

     

    def getData = { item -> xml.'**'.find{it.name() == item }?.text() }
//You may use log.info or assign value instead of print if you want to process that info further.
println getData('ResultCode')
println getData('ExtendedResultCode')
println getData('CoSID')
println getData('PIN')
println getData('iPhoneDevice')

     

     

     

richie's avatar
richie
Community Hero
Hey @@Mis3,

Im on my phone so cant see to check properly but i notice you are using the @ symbol in your xpath on element names. The @ symbol is oy used to specify attributes of an element. That is, id youre apecifying an element dont use the @ symbol.

Also, xpath is case sensitive so make sure you follow the upper/lower case exactly how it appears in your xml.

I'll have a look tomorrow when im on my laptop,

Cheers

Rich
Mis3's avatar
Mis3
Frequent Contributor
4 years ago

Thanks , Richie. Please take a look when you have the chance 
As shown in my 1st post, the XML response is a bit complicated.  I thought I could use the @ symbol because all the parameter names are unique.    
Anyway, in my 2nd post, I listed everything I tried.  I did try with the @ symbol and without. 

  • richie's avatar
    richie
    Community Hero
    4 years ago

    Hey Mis3 

     

    Double check your xpath - that's where the problems are

     

    for example - you've specified the path to the SequenceNumber element as --> xml.Body.ShPullResponse.UserData.SequenceNumber

     

    However, the xpath to SequenceNumber is as follows:

     

    xml.Body.ShPullResponse.UserData.Sh-Data.RepositoryData.SequenceNumber

     

    Your code is gonna be fine if you've managed to get it working for the 2 MESSAGES - so I reckon you just need to fix your xpath properly.

     

    If you haven't got anything like XMLSpy or equivalent, you can try --> https://www.easycodeforall.com/generate-xpath.html to generate your xpaths and this --> https://www.freeformatter.com/xml-formatter.html to pretty print your payload out which makes visualising how your xpath is setup easier.

     

    hit me back if you have any further problems, but I suspect you won't!

     

    Cheers

     

    rich

    • Mis3's avatar
      Mis3
      Frequent Contributor
      4 years ago

      I tried using this:  

      def MESSAGE3 = xml.Body.ShPullResponse.UserData.Sh-Data.RepositoryData.SequenceNumber

      It failed with error "groovy.lang.MissingPropertyException:No such property:Data for class:Script8 error at line:59"

       

      I actually tried this line before I posted this in the forum.    I think somehow the Groovy does not like the "-" in Sh-Data.  

       

      For example, the following 2 lines works. 

      def MESSAGE1 = xml.Body.ShPullResponse.ResultCode.text()
      def MESSAGE2 = xml.Body.ShPullResponse.ExtendedResult.ExtendedResultCode.text()

      Somehow I cannot access any parameters below Sh-Data.