ContributionsMost RecentMost LikesSolutionsRe: How do i get JSON values from a response in GroovyThis set up worked for me ****json { "odata.metadata": odataCallLocation/@Element", "EmployeeNumber": "000000101", "nameFirst": "Soap", "nameLast": "UI", } ****groovy script import com.eviware.soapui.support.XmlHolder import groovy.json.JsonSlurper def response = context.expand( '${TestStepName#Response}' ).toString() log.info(response) def slurper = new JsonSlurper() def json = slurper.parseText response log.info(json.EmployeeNumber) assert json.nameFirst == "Soap" assert json.nameLast == "UI"Re: Assertions with contains have stopped workingThis solved my problem. ThanksHelp: Unable to retrieve Date columns from databaseUsing a DataSource to attempt to retrieve a couple of fields from the sql database using the com.microsoft.sqlserver.jdbc.SQLServerDriver. I have to properties create EmployeeName, BeginDate & EndDate Sample SQL Query Select NameEmployee as EmployeeName, DateBegin as BeginDate, DateEnd as EndDate From Job Where EmployeeNumber = 'xyz' The name comes back just fine, but the dates properties are empty. The dates in the Sql Server DB are populated (2011-02-10 00:00:00.000). Any Help is greatly appreciated.Re: getting data from DataSourceJust figured out a way around this issue. In the assertion, use the xpath concatenation function which returns the concatenation of the strings. for example: declare namespace ns1='blah'; concat(//ns1:thelocation, "")Re: getting data from DataSourceWas this issue resolved or is there a workaround? We have a get method where we need to assert that the data that is being fetched matches the data in our db but are running into the columns that are null.Re: SoapUI duplicates TestSuites whose name contain a dash "-"Hello, Is related to composite projects. Sorry I cannot share a project, information is just too sensitive, but I'll try my best to give you all the details. In the attached screen shots you can see how the TestSuites with a dash in the name are duplicated in the file system. This happens shortly after i open the project in SoapUI Pro 4.5, i think is right after i click save. What's interesting to note is that SoapUI saves a copy of my TestSuite without the dash, which seems to be the way SoapUI has been saving structures in the file system. My version control software tells me the TestSuite with the dash is the newly created item. When I open the project for the first time, all this happens in the background but i don't get to notice it until i reload the project, at which time i get a warning message, please see screenshot. Is also interesting to notice that once i click past the warning SoapUI shows me the duplicated rows in the project, please see screenshot. If you guys need more info, please let me know. EnzoSoapUI duplicates TestSuites whose name contain a dash "-"I gave SoapUI 4.5 Beta a try and it wreaked havoc on all test projects i had. For every project, if there was a TestSuite with a dash in its name, SoapUI created a duplicate of such suite. Once i closed the project and opened it up again then SoapUI would complain about the duplicated TestSuites.Re: [Resolved] WSDL interface "Assign" functionality in groovy?Hi Dain, I actually wrote almost the exact same code you just gave me as the solution but i was hoping the assign functionality would be a method call. I guess is not. Thank you[Resolved] WSDL interface "Assign" functionality in groovy?Hello, I currently have a groovy script that deletes and populates the endpoint list for a given interface of a project based on an external file. The problem I'm having is that when i delete all endpoints and i add a fresh list then all tests steps in that project get a "- no endpoint set -" as the current endpoint for that testStep. I see that the answer to this problem is to go to the interface then select an endpoint then click "Assign" and choose "- All Test Requests -". I was wondering as to how i can accomplish this programmatically in groovy so that this process is not a manual one. Thank you, EnzoWhen Opening a new Project, the WSDL Folder gets recreated?When I open a project in SoapUI Pro(currently using 4.0, but happened in 3.6), I am seeing that when I save it, it creates the WSDL Folder again, so I will have duplicate folders containing the same WSDL information. This causes for TWO of the same WSDL definitions to show in the project next time I open it. My current solution is to delete the folder of the copy, then refresh the composite project, but it will keep happening again and again. Is there a setting somewhere that is causing this to happen?