Ashik
13 years agoOccasional Contributor
Jdbc response
hi,
how can i fetch the data's from jdbc response which is in xml format and set to properties step.
say the xml as follows
<ResultSet fetchSize="10">
<Row rowNumber="1">
<SHIPNODE_KEY>9417 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3201</SHIP_ADVICE_NO>
</Row>
<Row rowNumber="2">
<SHIPNODE_KEY>9478 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3202</SHIP_ADVICE_NO>
</Row>
<Row rowNumber="3">
<SHIPNODE_KEY>9478 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3203</SHIP_ADVICE_NO>
</Row>
I need to fetch the shipnode_key and ship_advice_no value of the first rowno to a property in the property step for later use.Am using soapui 4.5.1.Please help me out how it can be done.
Thanks in advance
Ashik
how can i fetch the data's from jdbc response which is in xml format and set to properties step.
say the xml as follows
<ResultSet fetchSize="10">
<Row rowNumber="1">
<SHIPNODE_KEY>9417 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3201</SHIP_ADVICE_NO>
</Row>
<Row rowNumber="2">
<SHIPNODE_KEY>9478 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3202</SHIP_ADVICE_NO>
</Row>
<Row rowNumber="3">
<SHIPNODE_KEY>9478 </SHIPNODE_KEY>
<SHIP_ADVICE_NO>3203</SHIP_ADVICE_NO>
</Row>
I need to fetch the shipnode_key and ship_advice_no value of the first rowno to a property in the property step for later use.Am using soapui 4.5.1.Please help me out how it can be done.
Thanks in advance
Ashik