Forum Discussion

jkrier's avatar
jkrier
Regular Contributor
9 years ago

Parsing XML file with Groovy script

I am trying to read in a naked xml file and parse it but for some reason XMLSlurper doesn't seem to be able to see child nodes. To make things easy I have created a groovy script with the xml inside ...
  • nmrao's avatar
    nmrao
    9 years ago

    jkrier

    Sorry about it, that was actually done quickly (could not test) for the change that you requested ( to loop thru all environments, and connection names)

    That was happening because, you provided all connection names, but some of them are not present in all environments.

    Handled now, please take the updated script from github.

nmrao's avatar
nmrao
Champion Level 3

Here is the script:

 

def testxml = '''<connStrings>
<env>
  <envName>test</envName>
  <conn>
   <connName>wba</connName>
   <host>host01</host>
   <port>1500</port>
   <user>user01</user>
   <password>P@ssw0rd</password>
   <sid>sid01</sid>
  </conn>
</env>
</connStrings>'''

def connStrings = new XmlSlurper().parseText(testxml)
println "Environment name : ${connStrings.env.envName}"
println "Connection name : ${connStrings.env.conn.connName}"
​

jkrier's avatar
jkrier
Regular Contributor
9 years ago

Thank you for that. I also need to be able to count the <connName> node, in my actual file I have several of these. Do you know how that can be done?

  • nmrao's avatar
    nmrao
    Champion Level 3
    9 years ago
    In that case please provide actual file, even above script may not work.
    • jkrier's avatar
      jkrier
      Regular Contributor
      9 years ago

      I sort of can. Here is a mock up of the entire file. It has db connections for my job so I can't post the actual connection string info but the file is in this exact structure I just changed the values to generic values.

       

      I thought this would be easier so I apologize for not saying exactly what I am trying to do. In order to be less confusing let me explain what I ultimately want to accomplish.

       

      I have a soapui project that reads in the file and I want to add a groovy script that determines the current active environment (I have 2 test and sandbox) and then runs some logic that says if the active environment = "test" then grab all connection values under the <envname> of "test" and then set them to a property using the <connname> + <host> or <port> etc.

       

      Then I have jdbc test steps that I configure to connect using the values I want out of the properties test step. I am already kind of doing this but my groovy script keeps getting larger every time I have to add a new connection so what I want to be able to do is to just grab all connections out of the external file that fall under a specific <envname> but I keep having trouble counting the child nodes.

       

      I hope this makes sense if needed I could mock up a soapui project of what I am currently doing.

       

      Thanks Rao

      • jkrier's avatar
        jkrier
        Regular Contributor
        9 years ago

        I was looking at my xml file and thought that maybe it wasn't really structured in the best way. Here is another verion, this might make things easier.