cancel
Showing results for 
Search instead for 
Did you mean: 

Extract data from JDSB response

Highlighted
Contributor

Extract data from JDSB response

I need help extracting data from a JDBC response using Groovy.

 

I have a generic JDBC Request that I use for all my SQL. The issue is I want to extract the results.

for example. In the example below, I want to extract the values for "person" and "legacy_userid".  The way I need to do it is by providing the name of the column "legacy_userid" and i would get 340579. Is there a way of doing this ?

 

 

<Results>
<ResultSet fetchSize="0">
<Row rowNumber="1">
<person.person>246544</person.person>
<person.legacy_userid>340579</person.legacy_userid>
</Row>
</ResultSet>
</Results>

 

1 REPLY 1
Highlighted
Community Manager

Re: Extract data from JDSB response

Hi,

 

Have you tried adding assertions to your test, like an XPath assertion?

http://readyapi.smartbear.com/soapui/getting_started/addassertions

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Filtering data retrieved from a DataSource

See replies!

Get data from Petstore and add it to Excel sheets

Participate!
Top Kudoed Authors