Forum Discussion

richie's avatar
richie
Community Hero
8 years ago

Extract SOAP XML attribute value from datafile to provide JDBC request with query filter value

Hi,   Its been years since I used SoapUI Pro (I was never that good with it to begin with) and I'm now using ReadyAPI! v1.9.0 and I'm struggling.   I have 80 test data files (XML) which will be u...
  • nmrao's avatar
    nmrao
    8 years ago
    richie,
    Ok. Thank you for the clarification. Once you lost the touch with programming, difficult to remember suddenly unless one keeps practise it daily life. Of course, you should restart again, will be able to grasp it quickly.

    Anyways, looks already Radford replied to your point to get the requested info in his solution. Please try that one.
Radford's avatar
Radford
Super Contributor
8 years ago

I assume that you are using a Directory Data Source to read each files contents in turn. and that data source has a single property called "contents", you can use a Groovy test step within your data source loop and the XmlSlurper to interogate your XML.

 

import groovy.util.XmlSlurper

// Get XML from data source property
//def xmlText = context.expand( '${DataSource#contents}' )

//Example XML just to demo XmlSlurper
def xmlText = '''<element1>
	<element2>
		<element3 RecordID='123'>fred</element3>
	</element2>
</element1>
'''

def xml = new XmlSlurper().parseText(xmlText)

log.info(xml.element2.element3.@RecordID)

 

 

My script above just logs the record ID, you could easily set a property of a JDBC test step.

 

More info on the XmlSlurper can be found here:

 

http://groovy-lang.org/processing-xml.html

  • richie's avatar
    richie
    Community Hero
    8 years ago

    Hey 

     

    Thanks for reply - I do appreciate it!

     

    I edited the file as implied (see below) but I'm getting an org.xml.sax.SAXParseException; Premature end of file. error at line :14 response.

     

    I'm not a coder - I spent a couple of hours trying to work out the problem but the google help is talking about instreams/outstreams and I just haven't got a clue!  The data files in the directory are all wellformed.

     

    import groovy.util.XmlSlurper

// Get XML from data source property
def xmlText = context.expand( '${DataSource#contents}' )

//Example XML just to demo XmlSlurper
//def xmlText = '''<element1>
//	<element2>
//		<element3 RecordID='123'>fred</element3>
//	</element2>
//</element1>
//'''

def xml = new XmlSlurper().parseText(xmlText)

log.info(xml.element2.element3.@RecordID)

     

    I'm totally lost!

     

    Thanks again!