dief123
Occasional Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
Data driven- can i feed multiple columns of the spreadsheet into a single field in service call?
I have an excel spreadsheet data driven loop in my testcase. I want to setup multiple columns in the spreadsheet with different data, but I want to be able to loop thru each cell on each row and feed the test that way. So I want to process Row 1 and put column A into a variable in the service call and have it execute, then loop thru and continue on Row 1, but feed Column B into the variable. Then, I want it to move to Row 2, and loop thru each cell? Is this possible and if so, how do i set it up?1.1KViews0likes2CommentsTeardown script to write to database?
Can anyone provide us with a sample Teardown script that writes results to a database? I know how to write to a file using this script. I'm looking for a sample script that writes results to a database. Here is my teardown file write script: fos = new FileOutputStream('C:/temp/test-log.txt', true ) pw = new PrintWriter( fos ) pw.write(testSuite.name + runner.status.toString()) pw.close() fos.close()649Views0likes0CommentsRe: Write SoapUI Pro testsuite output to a database?
Thank you for this help! Using this in the TestSuite TearDown script, the results is writes is "Finished". It does not give Pass/Fail status. I'm trying to write to a database we use for a system dashboard and would like to show the pass/fail results. Is there a way to do that?1.9KViews0likes0CommentsWrite SoapUI Pro testsuite output to a database?
I am constructing a dashboard for our systems and would like to know how to send testsuite output to a database (MSSQL). I configured the database connection in SoapUI Pro and can ping the database from the server that ReadyAPI runs on. Is there a way to send testsuite results directly to a database?2KViews0likes5CommentsHow can I change the settings so that my Projects and SoapUI windows stay saved
How can I change the settings so that my Projects and SoapUI windows stay saved each time i close and re-open ReadyAPI? I slide the project properties down to the bottom of the column and then open the column full of Projects in order to work on each one, expanded out. Every time i close and reopen ReadyAPI that part of the UI is set back to original settings. I want to have it save where I left off working the last time. How can I save the settings?3KViews0likes2Commentscustomize testsuite report
I would like help in modifying the TestSuite Report (or help in creating my own custom report). I want the TestSuite Report to show the entire JSON used in the Rest Service request and also show the entire Payload that is returned. How can I do this?778Views0likes1CommentI/O Docs Plugin in ReadyAPI
I added the Plugin for I/O Docs in ReadyAPI. I have several REST Projects in the Projects folder. When I do an 'Export to I/O Docs', it prompts me for a location and a filename. Then it appears to execute. It does create a .json file in the folder that I specify; however, it does not create or write ANYTHING to the file. It contains zero! Is this capability working? If so, what am I doing wrong? I have several REST service calls in the Project that I am doing the Export to I/O Docs on. It lists each service call with a checkbox when prompting me for location and contents.1.7KViews0likes1CommentRe: Pass null from excel spreadsheet Datasource into JSON??
I have this REST Service call ‘Spreadsheet into Composition’ that I feed with an Excel spreadsheet DataSource2. I added the Groovy Script ‘Convert NULLS’ inline. Below is the Groovy Script. “Convert NULLS – Groovy Script” def dataSource2GlobalPartnerSBCId = context.expand( '${#TestCase#DataSource2#GlobalPartnerSBCId}' ) def globalPartnerSBCId = context.expand( '${#TestCase#GlobalPartnerSBCId}' ) def nullValue if ("null" == dataSource2GlobalPartnerSBCId || !dataSource2GlobalPartnerSBCId) { context.testCase.setPropertyValue ('globalPartnerSBCId', nullValue) } log.info context.testCase.getPropertyValue('globalPartnerSBCId') Can you tell me why the field ‘'globalPartnerSBCId'’ in my JSON is not getting set properly to NULL? JSON: the excel spreadsheet has a value = NULL. {"SBCCommunicationDetails": [{ "CompassionSBCId": "C0028902042", "GlobalPartnerSBCId": "NULL", "SourceSystem": "SDL",3.5KViews0likes0Comments