Contributions
Null Values in SOAPUI Pro Excel Data Sink
I've recently created a TestCase with a SOAP Request, Excel Data Source, Excel DataSink and Data Loop. I followed the instructions on how to create DataSink and on execution via the test case editor the excel data sink is null. Wehn the logs are checked, each request message returns a valid response / result but none of the results are writtten to the Excel file. The structure of the test is: -->Datasource --->SoapRequest ------>DataSink --------->Dataloop Can you help ?15 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.4KViews0likes3CommentsRe: Excel DataSource fails when empty cells are transformed as Blank Values
Hi, My Excel dataSource contains empty cells for the listed optional columns below: DatePurchased NewBuild AddressChanged ResidencyType ConstructionStartDate ConstructionEndDate The SOAP request message fails schema validation during execution as the request message reads each empty cell as Nill. I've followed the advice provided on: http://www.eviware.com/blogs/oleblog/?p=768 and created an Event handler for : RequestFilter.filterRequest with the script set to: context.requestContent = context.requestContent.replaceAll( " ","" ) context.requestContent = context.requestContent.replaceAll( " ","" ) context.requestContent = context.requestContent.replaceAll( " ","" ) context.requestContent = context.requestContent.replaceAll( " ","") context.requestContent = context.requestContent.replaceAll( " ","") context.requestContent = context.requestContent.replaceAll(" ","") This failed to replace the elements specified. I've executed the same test manually and this passed schema validation with the request message formatted as the optional elements are stripped off during formatting Can you help ?15 years agoPlace ReadyAPI QuestionsReadyAPI Questions923Views0likes0CommentsExcel DataSource fails when empty cells are transformed as Blank Values
When tests are executed using an Excel Datasource, SOAPUI treats each cell with no enumeration value supplied as having Null values thus resulting in the SOAP request message failing validation. By Default SOAPUI treats all empty cells in excel with no values supplied in the excel datasource as below: Can SOAPUI transform empty Excel cells as with Null values: Note: when the failed soap request is re-run in manual mode and validated, the outbound soap message sent after post manual validation is the above.15 years agoPlace ReadyAPI QuestionsReadyAPI Questions2KViews0likes3CommentsRe: [RESOLVED] SOAP Request Failing when sent via Excel DataSource
Hi Robert, I've managed to get to the root of the problem, a space in one of the values was causing the tests to fail. This has now been corrected and tests can now be executed successfully. Many thanks15 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.6KViews0likes0CommentsRe: [RESOLVED] SOAP Request Failing when sent via Excel DataSource
Hi I've checked the request sent to the WS server and compared it with the manual request, both are an exact mirror. It's the same problem with all other service tests submitted using the excel data pool. I've also resubmitted the tests using the Grid and experienced the same behaviour. many thanks15 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.6KViews0likes0Comments[RESOLVED] SOAP Request Failing when sent via Excel DataSource
I'm currently executing tests using an Excel data source and all tests fail when executed via TestRunner. When the SOAP request messages are submitted manually, they pass validation and respond correctly. Please see below, the error message returned when using the Excel Datapool and Test Runner: Response Headers: {X-Backside-Transport=OK OK, #status#=HTTP/1.0 500 Internal Server Error, Connection=close, Content-Type=text/xml} env:Server Internal Error (from server)15 years agoPlace ReadyAPI QuestionsReadyAPI Questions4.9KViews0likes4Comments