User Profile

vissie1983

New Contributor

Joined 7 years ago

4 Posts1 LikeLikes received

View All Badges

User Widgets

Contributions

Re: Excel formulas vs data source
unfortunatly you can't save the formulas in csv. But csv sorted out other issues I have.
6 years ago Place ReadyAPI Questions
1.8KViews
0likes
2Comments
Excel formulas vs data source
Hi guys/Girls I have this issue where I want to create different / random data in excel and then use it as a datasource. However I wrote formulas in excel to supply me with the random data. If I change anything in the spreadsheet then the data change which is wonderfull and the formulas works. However if I use the spreadsheet as a datasouce it does not refresh the spreadsheet and it stays with the same data which makes that I must mannually open the excel sheet to refresh it. My excel settings is set to automatic recalc/refresh if anything has change so I think excel is doing its job. Is there a setting in ReadyAPI that can refresh excel spreadsheet so that I can get random data once I kick off my test suite? I am not a developer and groovy scripting is a bit french to me and everything looks so cool in die videos useing excel but when it comes to random data it looks like it is not possible to handle it from excel point of view. Please see spread sheet with formulas and the random data it gets from spreadsheet two.
Solved
6 years ago Place ReadyAPI Questions
1.8KViews
0likes
4Comments
Re: Validate assertion with XPath field null
Thank you I eventually wrote a script assertion and looks like this: def response = context.expand( '${SOAP Request Get Lead#Response#declare namespace typ=\'http://wowweb.miway.co.za/types/\'; //typ:getLeadsResponseElement[1]/typ:result[1]/typ:leads[1]/typ:array[1]/typ:leadSource[1]/typ:leadSourceId[1]}' ) log.info response def DatasourceValue = context.expand( '${DataSource#SOURCE_ID}' ) log.info "DatasourceValue= $DatasourceValue" if (DatasourceValue=='null') { assert response=='' } else { assert response==DatasourceValue }
7 years ago Place ReadyAPI Questions
4.7KViews
1like
0Comments
Validate assertion with XPath field null
Hi all. I am new with soap so please bear with me. in the pro-version I created and assetion to match "content" from a Datasource. It match 100% if there are any details in the field. but when the api returns nothing "No phone number exist" then my test fails. When I compare my results the datasource contains "Null" and the API returns Blank. which fails my assertion when it reads that line. What regex can I write to ignore it when it is "blank"/"Empty" ? Please see my screenshot : The expath expression is as follow: declare namespace typ='http://wowweb.miway.co.za/types/'; //typ:getLeadsResponseElement[1]/typ:result[1]/typ:leads[1]/typ:array[1]/typ:contactNumber[1]/text() Expected results: ${DataSource#PHONE_NO}
Solved
7 years ago Place ReadyAPI Questions
5.2KViews
0likes
4Comments