del_exaclee
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: ReadyAPI 2.5.0 - Parse jdbc response in Groovy script (until max row number value)
Unfortunately Groovy didnt work for us, so we had to code the XML using SQL within in the JDBC request. Once we had the XML we wanted, we then injected that as a child node within the main SOAP request.2.7KViews0likes0CommentsRe: ReadyAPI 2.5.0 - Parse jdbc response in Groovy script (until max row number value)
Thanks for this Radford. A couple of things: 1) I need the code to dynamically take its input from a JDBC response as this code will need to run 100 times for our test requirements so I need to parse the JDBC response as XML dynamically. 2) Once I have extracted that data from the JDBC response, can I populate this data into a single test case property so that I can inject it into a SOAP request? Regards, Ajay2.9KViews0likes3CommentsReadyAPI 2.5.0 - Parse jdbc response in Groovy script (until max row number value)
I am using a JDBC request in ReadyAPI 2.5.0 to retrieve data from our database. What I need to do is loop through all of the rows that are returned and pick out specific values for use in my SOAP request later on. How do I use a Groovy script to take a JDBC response and loop through until all rows have been read? Please note the JDBC response will return a dynamic set of results each time so its important to loop until all rows have been processed. I have included a sample JDBC response below for which we would need to extract values i.e. UNIQUEID and ROUTEID using a Groovy script and pass that into my SOAP request as a test case property. <Results> <ResultSet fetchSize="128"> <Row rowNumber="1"> <UNIQUEID>80382049</UNIQUEID> <SOURCESYSTEM>HitsSC</SOURCESYSTEM> <ROUTEID>39812</ROUTEID> <SHIFTDATE>2018-12-07 00:00:00.0</SHIFTDATE> </Row> <Row rowNumber="2"> <UNIQUEID>80382096</UNIQUEID> <SOURCESYSTEM>NTExchange</SOURCESYSTEM> <ROUTEID>39812</ROUTEID> <SHIFTDATE>2018-12-07 00:00:00.0</SHIFTDATE> </Row> <Row rowNumber="3"> <UNIQUEID>80382097</UNIQUEID> <SOURCESYSTEM>NTExchange</SOURCESYSTEM> <ROUTEID>39812</ROUTEID> <SHIFTDATE>2018-12-07 00:00:00.0</SHIFTDATE> </Row> <Row rowNumber="4"> <UNIQUEID>80382098</UNIQUEID> <SOURCESYSTEM>NTExchange</SOURCESYSTEM> <ROUTEID>39812</ROUTEID> <SHIFTDATE>2018-12-07 00:00:00.0</SHIFTDATE> </Row> </ResultSet> </Results> Regards, Ajay3.1KViews0likes5Comments