Forum Discussion

Mis3's avatar
Mis3
Frequent Contributor
4 years ago

Groovy: Fails to Display Request Status

I am building a Groovy script to read an external file and execute a testStep one by one. Somehow log.info can successfully display the data (basicMSISDN, NAM, etc) of the XML response but not the r...
  • nmrao's avatar
    nmrao
    4 years ago

    Mis3 

    Oh, I got what you are point now.

     

    You are trying to access the attributes of a node. The xpath is incorrect, that is why data is not shown for you.

    Attributes are accessed using @Attribute

     

    Here is another simple way of accessing xml data using XmlSlurper. If you notice, the data is accessed dot(.) after node name, then dot (.) and node name like how we see.

    NOTE: you can replace printf with log.info

     

Mis3's avatar
Mis3
Frequent Contributor

Working now.  THANKS, Rao.

 

This is what I did:

def xmlResponse = tStep.getPropertyValue("Response")
def holder = groovyUtils.getXmlHolder(xmlResponse)
def xml = new XmlSlurper().parseText(xmlResponse)

def MESSAGE1 = xml.Body.getImsiDataResponse.@resultCode.text()
def MESSAGE2 = xml.Body.getImsiDataResponse.@message.text()
def MESSAGE3 = holder.getNodeValue("/soap:Envelope/soap:Body/ns2:getImsiDataResponse/imsiData/basicMsisdn")
def MESSAGE4 = holder.getNodeValue("/soap:Envelope/soap:Body/ns2:getImsiDataResponse/imsiData/serviceProfile/nam")
def MESSAGE5 = holder.getNodeValue("/soap:Envelope/soap:Body/ns2:getImsiDataResponse/imsiData/serviceProfile/roamingProfileId")
def MESSAGE6 = holder.getNodeValue("/soap:Envelope/soap:Body/ns2:getImsiDataResponse/imsiData/serviceProfile/odbProfileId")
//   def MESSAGE6 = xml.Body.getImsiDataResponse.imsiData.serviceProfile.odbProfileId.text()

 

log.info " Seq="+i+" "+data[0]+" Result: "+MESSAGE1+", "+MESSAGE2+", "+MESSAGE3+", "+MESSAGE4+" "+MESSAGE5+" "+MESSAGE6
report << "\n"+"Seq="+i+" "+sdf.format(log_date)+"|"+data[0]+"|Result: "+MESSAGE1+" "+MESSAGE2+" "+MESSAGE3+" "+MESSAGE4+ " "+MESSAGE5+" "+MESSAGE6

 

I noticed that if a parameter does not exist in the response:

if I use holder.getNodeValue, MESSAGE6 would display "null".  (I prefer this, more precise)

if I use xml.Body..., MESSAGE6 would display nothing.

Is this normal?

 

nmrao's avatar
nmrao
Champion Level 3
4 years ago
xml.Body contain another node, but not node value.
  • Mis3's avatar
    Mis3
    Frequent Contributor
    4 years ago

    Thanks again, Rao.

     

    My API script contains a few XML requests and below is the response:

     

    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Body>
    <ns2:changeSdmDataResponse resultCode="0" message="success" xmlns:ns2="http://www.abcnumber.com/titan/sdm/soap/types">
    <sdmDataResponse flowId="1">
    <ns2:changeImsiDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="2">
    <ns2:changeMsisdnDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="3">
    <ns2:changeImsSubscriberDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="4">
    <ns2:changeImsPrivateUserDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="5">
    <ns2:changeImsPublicUserDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="6">
    <ns2:changeImsPublicUserDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="7">
    <ns2:changeImsPublicUserDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    <sdmDataResponse flowId="8">
    <ns2:changeImsSubscriberDataResponse resultCode="0" message="success"/>
    </sdmDataResponse>
    </ns2:changeSdmDataResponse>
    </soap:Body>

     

    My Groovy:

    ...

    ...

    def xmlResponse = tStep.getPropertyValue("Response")
    def holder = groovyUtils.getXmlHolder(xmlResponse)
    def xml = new XmlSlurper().parseText(xmlResponse)

    def MESSAGE1 = xml.Body.changeSdmDataResponse.@resultCode.text()
    def MESSAGE2 = xml.Body.changeSdmDataResponse.sdmDataResponse.changeImsiDataResponse.@resultCode.text()
    def MESSAGE3 = xml.Body.changeSdmDataResponse.sdmDataResponse.changeMsisdnDataResponse.@resultCode.text()
    def MESSAGE4 = xml.Body.changeSdmDataResponse.sdmDataResponse.changeImsSubscriberDataResponse.@resultCode.text()
    def MESSAGE5 = xml.Body.changeSdmDataResponse.sdmDataResponse.changeImsPrivateUserDataResponse.@resultCode.text()
    def MESSAGE6 = xml.Body.changeSdmDataResponse.sdmDataResponse.changeImsPublicUserDataResponse.@resultCode.text()

    log.info " Seq="+i+" "+data[0]+", "+data[1]+" Result: ["+MESSAGE1+"] "+MESSAGE2+" "+MESSAGE3+" "+MESSAGE4+" "+MESSAGE5+" "+MESSAGE6

    ...

    ...

     

    In the request, I have to execute changeImsPublicUserData 3 times and changeImsSubscriberDataResponse 2 times (in a specific sequence but with different values).

    Log record:   Tue Jun 22 21:05:02 EDT 2021:INFO: Seq=0 302330000006120, 12313140097 Result: [0] 0 0 00 0 000

    In the response, since the 3 changeImsPublicUserData requests were all successfully, the log file show "000" (Zero means success).

     

    Since there is no distinction of the 3 responses of changeImsPublicUserData, I guess there is no way to display it in a better way, right?

    Ideally, I like to see Result: [0] 0 0 0 0 0 0 0 0  or Result: [0] 0 0 0-0 0 0-0-0

    Any suggestions?

     

     

    • nmrao's avatar
      nmrao
      Champion Level 3
      4 years ago

      Mis3 

       

      Here is little optimized, but it may need you to spend little time to understand. Groovy code is easily readable though.

       

       

      //Parse response
def xml = new XmlSlurper().parseText(xmlResponse)

//Closure to show the details of the item as input data
def showDetails = { item ->
    def sdms = xml.'**'.findAll {it.name() == item }*.parent()
    sdms.each { 
        log.info "${item} ==> FlowId: ${it.@flowId}, ResultCode: ${it."$item".@resultCode}, Message: ${it."$item".@message}"
    }    
}
//show all the changeImsPublicUserDataResponse
showDetails('changeImsPublicUserDataResponse')

//show all the changeImsSubscriberDataResponse
showDetails('changeImsSubscriberDataResponse')

       

      .

      • Mis3's avatar
        Mis3
        Frequent Contributor
        4 years ago

        This is cool.  Thanks, Rao.  I am not a developer so this code is hard for me to understand.  

         

        I added your code to my Groovy script (below) and yielded the following results:

        Is there any way to equate these results to a variable; like Message1 = FlowId:1, Status:0?  This way, I can control the log.info and report file better.   I will run this Groovy for thousands times so, ideally, it will be better if log.info is one line per MDSISDN.

         

        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsiDataResponse ==> FlowId: 1, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeMsisdnDataResponse ==> FlowId: 2, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsSubscriberDataResponse ==> FlowId: 3, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsSubscriberDataResponse ==> FlowId: 8, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsPrivateUserDataResponse ==> FlowId: 4, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsPublicUserDataResponse ==> FlowId: 5, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsPublicUserDataResponse ==> FlowId: 6, Status: 0
        Wed Jun 23 09:38:39 EDT 2021:INFO:changeImsPublicUserDataResponse ==> FlowId: 7, Status: 0

        -----------------------------------------------------------------------------------------------------------------------------------------------------------

        def xmlResponse = tStep.getPropertyValue("Response")
        def holder = groovyUtils.getXmlHolder(xmlResponse)
        def xml = new XmlSlurper().parseText(xmlResponse)

        //Closure to show the details of the item as input data
        def showDetails = { item ->
        def sdms = xml.'**'.findAll {it.name() == item }*.parent()
        sdms.each {
        // log.info "${item} ==> FlowId: ${it.@flowId}, ResultCode: ${it."$item".@resultCode}, Message: ${it."$item".@message}"
        log.info "${item} ==> FlowId: ${it.@flowId}, Status: ${it."$item".@resultCode}"
        }
        }
        showDetails('changeImsiDataResponse')
        showDetails('changeMsisdnDataResponse')
        showDetails('changeImsSubscriberDataResponse')
        showDetails('changeImsPrivateUserDataResponse')
        showDetails('changeImsPublicUserDataResponse')

        //Closure to show the details of the item as input data
        def showDetails = { item ->
        def sdms = xml.'**'.findAll {it.name() == item }*.parent()
        sdms.each {
        // log.info "${item} ==> FlowId: ${it.@flowId}, ResultCode: ${it."$item".@resultCode}, Message: ${it."$item".@message}"
        log.info "${item} ==> FlowId: ${it.@flowId}, Status: ${it."$item".@resultCode}"
        }
        }
        showDetails('changeImsiDataResponse')
        showDetails('changeMsisdnDataResponse')
        showDetails('changeImsSubscriberDataResponse')
        showDetails('changeImsPrivateUserDataResponse')
        showDetails('changeImsPublicUserDataResponse')