Ask a Question

Extract data from JDBC step

SOLVED
linhptt
New Contributor

Extract data from JDBC step

I have some confuse with Ready API. Could anyone help?

 

Here is the response data from JDBC step:

<Results>
   <ResultSet fetchSize="0">
      <Row rowNumber="1">
         <DESCRIPTION>auto1</DESCRIPTION>
      </Row>
      <Row rowNumber="2">
         <DESCRIPTION>auto2</DESCRIPTION>
      </Row>
      <Row rowNumber="3">
         <DESCRIPTION>auto3</DESCRIPTION>
      </Row>
   </ResultSet>
</Results>

 

In the Xpath assertion, I use //DESCRIPTION  then I got the result is an array.

But in another step, I want to use above response by using context.expand function:

context.expand('${JDBC#ResponseAsXml#//DESCRIPTION}')

==> the result is a String only, with value is 'auto1'

 

==> is there any bug here ? if not. could anyone  help me to extract all data?

 

Many thanks and have a nice day!

2 ACCEPTED SOLUTIONS

Accepted Solutions
sprice090161
Contributor

Re: Extract data from JDBC step

I'm looking to do something similar. I'm not sure how to go about capturing the output but from what you are describing It sounds like you are capturing the data. I doubt if the data is in an array. It is most likely a list and the two are manipulated syntactically different.

 

Try adding subscripts to your xpath (0, 1, 2) and see if you can display each description in the response. If you can than I would think that a simple loop would allow yo to iterate through.

 

Maybe a piece to the puzzle!

View solution in original post

PaulMS
Super Contributor

Re: Extract data from JDBC step

2 REPLIES 2
sprice090161
Contributor

Re: Extract data from JDBC step

I'm looking to do something similar. I'm not sure how to go about capturing the output but from what you are describing It sounds like you are capturing the data. I doubt if the data is in an array. It is most likely a list and the two are manipulated syntactically different.

 

Try adding subscripts to your xpath (0, 1, 2) and see if you can display each description in the response. If you can than I would think that a simple loop would allow yo to iterate through.

 

Maybe a piece to the puzzle!

View solution in original post

PaulMS
Super Contributor

Re: Extract data from JDBC step

cancel
Showing results for 
Search instead for 
Did you mean: