Forum Discussion

Jasper175's avatar
Jasper175
Frequent Contributor
13 years ago

[Response] Find Value in XML Code Block

Hello Groovy Friends,

I need to figure out a better way to pull a value from within a code block. The script I use in Groovy is working...sort of. I won't paste that in, but here is an example of a return of Phone Numbers (did) a customer can have. The 'didType' which has many... the below has PHYS and TEMP.

I need to be able to extract a list of phoneNumbers (did) that has the didType == "PHYS"
Reason I need to do it through Groovy is because there are many DIDTYPES, there can be more than one etc...


   <SOAP-ENV:Body>
      <ns2:GetServiceDidMapResponse xmlns:ns2="http://cleveland.vonage.com/services/servicelayer" xmlns:ns3="http://cleveland.vonage.com/services/servicelayer/internal" xmlns:ns4="http://cleveland.vonage.com/services/servicelayer/legacy">
         <ns2:serviceEntities>
            <ns2:networkId>128982952</ns2:networkId>
            <ns2:didTargets>
               <ns2:did>17325659833</ns2:did>
               <ns2:didType>PHYS</ns2:didType>
               <ns2:startDate>2012-10-16</ns2:startDate>
            </ns2:didTargets>
            <ns2:didTargets>
               <ns2:did>17322025696</ns2:did>
               <ns2:didType>TEMP</ns2:didType>
               <ns2:startDate>2012-10-16</ns2:startDate>
            </ns2:didTargets>
            <ns2:startDate>2012-10-16</ns2:startDate>
         </ns2:serviceEntities>
      </ns2:GetServiceDidMapResponse>
   </SOAP-ENV:Body>


Thank you,
Rob Long (Jasper175)

12 Replies

  • RJanecek's avatar
    RJanecek
    Regular Contributor
    13 years ago
    too easy something like this:

    def response = context.expand( '${TestStepName#Response}' )
    def holderResponse = groovyUtils.getXmlHolder( response )

    for(int i = 1; i <= didTargetCount; i++){
     def did = null;
       didType = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                      "//*[local-name()='didType' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
         if (didType.equals("PHYS")){
            did = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                      "//*[local-name()='did' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
         }
         println did

    }


    this code println 2 lines:
    17325659833
    null

    next time please copy whole xml because now in your xml is missing element envelope !
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    Thank you
    I figured all you needed was the body, but I put the full code below.
    The code you sent didn't work - seems you're using the full bodied Groovy Language. SoapUI seems to have a watered down version, unless you import.

    println doesn't work in SoapUI - at least I never got it to do anything.

    I have an error in Line 2.. I put in the testStep name

        def response = context.expand( '${getServiceDidMap#Response}' )
        def holderResponse = groovyUtils.getXmlHolder( response )


    groovy.lang.MissingPropertyException: No such propery: groovyUtils for class: Script4 error at line: 2

    Here is the full response of the api "getServiceDidMap"
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
       <SOAP-ENV:Header/>
       <SOAP-ENV:Body>
          <ns2:GetServiceDidMapResponse xmlns:ns2="http://cleveland.vonage.com/services/servicelayer" xmlns:ns3="http://cleveland.vonage.com/services/servicelayer/internal" xmlns:ns4="http://cleveland.vonage.com/services/servicelayer/legacy">
             <ns2:serviceEntities>
                <ns2:networkId>128982952</ns2:networkId>
                <ns2:didTargets>
                   <ns2:did>17325659833</ns2:did>
                   <ns2:didType>PHYS</ns2:didType>
                   <ns2:startDate>2012-10-16</ns2:startDate>
                </ns2:didTargets>
                <ns2:didTargets>
                   <ns2:did>17322025696</ns2:did>
                   <ns2:didType>TEMP</ns2:didType>
                   <ns2:startDate>2012-10-16</ns2:startDate>
                </ns2:didTargets>
                <ns2:startDate>2012-10-16</ns2:startDate>
             </ns2:serviceEntities>
          </ns2:GetServiceDidMapResponse>
       </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>
  • RJanecek's avatar
    RJanecek
    Regular Contributor
    13 years ago
    sorry I forgot to add this line:

    def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )

    and you are sure println doesnt work. I am using this without problem. I always run soap ui from console and when I call println "aa" this is println inside of console
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    If I do
    println "aa" and click run nothing happens... anyway back to this code. Correct me if I'm wrong but I have in complete of what you sent me:

    def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) 
        def response = context.expand( '${getServiceDidMap#Response}' )
        def holderResponse = groovyUtils.getXmlHolder( response )

        for(int i = 1; i <= didTargetCount; i++){
           def did = null;
           didType = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                          "//*[local-name()='didType' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
             if (didType.equals("PHYS")){
                did = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                          "//*[local-name()='did' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
             }
             println did

        }


    Correct?
    The Error I get now is "org.apache.xmlbeans.XmlException: error: Unexpected element: CDATA error at line: 4
  • RJanecek's avatar
    RJanecek
    Regular Contributor
    13 years ago
    ok so groovy script:

    def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
    def response = context.expand( '${Zadost#Response}' )
    def holderResponse = groovyUtils.getXmlHolder( response )

    int didTargetCount = Integer.parseInt (holderResponse.getNodeValue( "count(//*[local-name()='didTargets'])") ) 
    for(int i = 1; i <= didTargetCount; i++){
     def did = null;
         didType = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                         "//*[local-name()='didType' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
         if (didType.equals("PHYS")){
          did = holderResponse.getNodeValue( "//*[local-name()='didTargets' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer'][" + i + "]"+
                                          "//*[local-name()='did' and namespace-uri()='http://cleveland.vonage.com/services/servicelayer']")
         }
         println did

    }




    you must edit this line:

    def response = context.expand( '${Zadost#Response}' )


    Zadost#Response -> Zadost is the name of Test request and response is response of this request

    you can also check this when you right click in groovy script -> Get Data.. rest step -> response (I cant test this because my soap pro version doesnt work) but the exception which you wrote indacate that groovy script cannot find your response
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    Which I did the first time - I messed up the second time when I closed everything into a sandbox testCase so I don't mess up the whole project.

    Anyway

    When I fixed the testCase name the error:
    "groovy.lang.MissingProperyException: No such property: didTargetCount for class: Script8 error at line 4"
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    Ugh - I scrolled too high and copied the wrong one.

    one word - GENIUS
    Thank you

    Last question if I may
    In the log.info (did) it shows as you mentioned a phoneNumber and a null
    Why does it show a null entry? Why not only the 'did' that is associated to PHYS?

    What I will need to do is ensure the value of the script is a PHYS 'did'.

    Thank you so much
    Rob
  • RJanecek's avatar
    RJanecek
    Regular Contributor
    13 years ago
    because there is defined:

    def did = null;

    you can add if

    if (did != null){
    println ...
    }

    or you can add println in if :

    if (didType.equals("PHYS")){
    ...
    }
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    ok Groovy Man...
    Now I have the log responding with only a single DID...

    I need now to use that result in another API

    Example if I do:
    if (did !=null){println(did)}
    or better yet if (did !=null){log.info (did)}

    The "log" is correct
    But when I use GET DATA in an API

    ${PHYS_DID#result}

    It's not pulling anything - the tag is blank