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')

     

     

     

nmrao's avatar
nmrao
Champion Level 3
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')

 

 

 

  • Mis3's avatar
    Mis3
    Frequent Contributor
    4 years ago

    I tried and it is working great. 

    Since the responses of most of the APIs (with a few exceptions)  have unique attribute names, this getData function will work great for me.

     

    For my education:

    1.  I tried this statement:  

    def MESSAGE3 = xml.Body.ShPullResponse.UserData.Sh-Data.RepositoryData.SequenceNumber and it failed with error "groovy.lang.MissingPropertyException:No such property:Data for class:Script8 error at line:59"

    Looks to me that the Groovy does not like the hyphen in Sh-Data.    Since this Sh-Data is present in the XML response, why does this fail?

    2.  I thought if the XML response have unique attribute names, I can use the "@" sign to retrieve the attribute value.

    In this case:

    // def MESSAGE3 = xml.Body.ShPullResponse.UserData.@SequenceNumber.text()

    No error from Groovy but it does not provide me with the SequenceNumber.

     

     

     

     

    • nmrao's avatar
      nmrao
      Champion Level 3
      4 years ago
      1. Element name 'Sh-Data' is not a standard practice, I guess. You can wrap it between quotes.
      2. In your data, there is no attribute. So simply ignored.
      • Mis3's avatar
        Mis3
        Frequent Contributor
        4 years ago

        1.  I did wrap Sh-Data in quotes and it works.

        def MESSAGE1 = xml.Body.ShPullResponse.UserData.'Sh-Data'.RepositoryData.SequenceNumber
        def MESSAGE2 = xml.Body.ShPullResponse.UserData.'Sh-Data'.RepositoryData.ServiceData.MetaSphereData.Msph_Subscriber_BaseInformation.CoSID
        def MESSAGE3 = xml.Body.ShPullResponse.UserData.'Sh-Data'.RepositoryData.ServiceData.MetaSphereData.Msph_Subscriber_BaseInformation.PIN
        def MESSAGE4 = xml.Body.ShPullResponse.UserData.'Sh-Data'.RepositoryData.ServiceData.MetaSphereData.Msph_Subscriber_BaseInformation.Device.iPhoneDevice

        These lines gives me the proper result of each parameter.

        Of course, I prefer the getData; it is simpler since I do not have to specify the full path.

         

        2.  I think I have fundamental misunderstanding of XML nomenclature.  

        For me,  in <s:CoSID>English_COS2</s:CoSID>  -->  CoSID is an attribute and English-COS2 is the value.

        I did google.  The whole line is called an element; including open and close tags.

        So, what do you call CoSID and English-COS2?