NK12
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
SOAPUI-->How to Pass Get Request with API Key
Hello All, i'm not able to pass the get request successfully with API Key Have sent this API Key through Authorization tab?. Is this right way to send the request I'm able to do sucessfully using Swagger through API Key as Authrorization. Can any one shred some light on this. Thanks!11KViews0likes2CommentsRe: Unable to establish-Oracle Database Connection through ready api tool
I'm able to succesfully establish the connection through my DBA team. DBA team grant the access for me to get in through Read Steps Hello All, 1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear 2.I'm using the connection string as jdbc: oracle:thin:UserName/Password@ServerName:1521:<SID Name>1.1KViews0likes1CommentRe: Unable to establish-Oracle Database Connection through ready api tool
Hello All, 1. Have copied ojdbc6 and 7 Jar files(Have taken these Jar files from my Oracle home-->Jdbc directory) in Ext and lib folder of Smart Bear 2.I'm using the connection string as jdbc:oracle:thin:UserName/Password@ServerName:1521:Sid 3.When i click on Test Connection Button it is not showing any pop up message as Connection successfully tested 4.However it shows in logs as The JDBC driver [oracle.jdbc.driver.OracleDriver] is already registered. richie 1.I'm able to connect my oracle db using my credentials through Toad Tool 2.My Java version is 1.8.0_172( I did research for this java version JDBC jar files-ojdbc6 and 7 are compatible2.8KViews0likes7CommentsUnable to establish-Oracle Database Connection through ready api tool
Hello all, I'm not able to establish the Oracle Data Base connection Have copied proper(ojdbc14.jar file) in bin\ext folder used the driver name as oracle.jdbc.driver.OracleDriver connection string as jdbc:oracle:thin:username/password//<serverName> can you please tell us how to send the connection string3.4KViews0likes13CommentsRe: How to get JDBC Response into an Array
Thanks it worked out and able to get the result set in Array Here is the script import groovy.xml.* import groovy.json.* //DB Response def dbresponse = context.expand( '${JDBC Request#ResponseAsXml}' ) log.info dbresponse def dbsluper=new XmlSlurper().parseText(dbresponse) log.info dbsluper //Json Response def jsonresponse = context.expand( '${REST Request#Response}' ) log.info jsonresponse def jsluper=new JsonSlurper().parseText(jsonresponse) log.info jsluper //Writing the json specfic data into an array def jsonvalues=[] jsluper.DelinquencyRecord.each{ jsonvalues.add(it.key) //jsonvalues.add(it.value) } jsonvalues.sort() log.info jsonvalues //Writing the DBData into array def dbvalues= [] dbsluper.ResultSet.each{ dbvalues.add(it.text()) } log.info dbvalues 1.How can I get Json data as (Key:Value) in my array(Here Json Array name is jsonvalues) so that I can compare the result set of DB and Json data nmrao Here I'm trying to compare the JSON response to DB Response2.5KViews0likes0CommentsHow to get JDBC Response into an Array
Hello All, I'm trying to compare JSON Response and DB Response Below is the sample Code Snippet import groovy.xml.* import groovy.json.* //DB Response def dbresponse = context.expand( '${JDBC Request#ResponseAsXml}' ) log.info dbresponse def dbsluper=new XmlSlurper().parseText(dbresponse) log.info dbsluper //Json Response def jsonresponse = context.expand( '${REST Request#Response}' ) //log.info jsonresponse def jsluper=new JsonSlurper().parseText(jsonresponse) //log.info jsluper //Writing the json specfic data into an array def jsonvalues=[] jsluper.STMT_BK_ADDR_LINE.each{ jsonvalues.add(it.value) } jsonvalues.sort() log.info jsonvalues def dbvalues=[] dbsluper.Results.each{ dbvalues.add(it.value) } log.info dbvalues Here I'm getting empty result set for dbvalues Attached is the sample screen snippet2.6KViews0likes3CommentsRe: Validating Json Response with DB Response
DB Column names are same as JSON Response elements I need to compare the DB response column values with Json Response Column values dynamically based on Statement ID Here is the sample JSON Structure(Like this have different array objects and array elements). Below is the sample array object "STMT_BK_ADDR_LINE": { "STMTID": 10, "BK_ADDR1": "VALUE" "BK_ADDR2": "VALUE", "BK_ADDR3": "VALUE", "CRET_TMSP": "VALUE", "CRET_PGM_ID": "VALUE", "CRET_USER_ID": "VALUE" } What is the best method for validating the response with DB result dynamically Currently I have created one property element for each JSON element and DB element (I.,e STMT_ID(for JSON) and STMT_ID for DB-as per my earlier post) How can I refresh the property value if I use the for loop for validating all data elements Thanks!!4.8KViews0likes1CommentRe: Validating Json Response with DB Response
Can you guys please help me on this. How to compare multiple JSON Elements with DB elements in one script and capture the result in Excel sheet as JSON ELEMENTELEMENT DATA BASE ELEMENT VALUE RESULT 123 123 PASS 1234 456 FAIL I'm able to compare (Json Response Element vs DB Response) only one element at a time with the below script and capturing the results in excel sheet as above for one element. Attached is the sample screen snippet of my test steps and end result excel sheet I'm creating a property as Result with Blank context.testCase.setPropertyValue("Result","") Groovy Script import groovy.xml.* import groovy.json.* def response = context.expand( '${REST Request#Response#$[\'STMT_BK_ADDR_LINE\'][\'STMT_ADDR_MONETARY_ID\']}' ) log.info response def responseAsXml = context.expand( '${JDBC Request#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/STMT_ADDR_MONETARY_ID[1]}' ) log.info responseAsXml context.testCase.setPropertyValue("DBResponse",responseAsXml) context.testCase.setPropertyValue("JsonResponse",response) if(response.equals(responseAsXml)) { context.testCase.setPropertyValue("Result","pass") } else { context.testCase.setPropertyValue("Result","fail") }4.8KViews0likes1Comment