zsousa
8 years agoContributor
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>