Property Transfer - Is it possible to use test case custom property in jsonpath expression textbox?

Question

I get data from an API in json format.&nbsp;&nbsp;I am wondering if I can do something like this to filter the data that I get in response. Currently its not working.&nbsp;&nbsp;For ex;$.Refinements[?(@.RefinementText=='${#TestCase#VehicleType}')] .RefinementValue&nbsp;If I use $.Refinements[?(@.RefinementText== ‘Auto/Light Trucks’)] .RefinementValue it works however, I need to compare RefinementText with the custom property that I have defined in the test case.&nbsp;Please advise where can I find more information on how to handle this.&nbsp;Thanks!

nmrao · Answer

I am not sure how to do it in property transfer using condition.
&nbsp;
However, you can use groovy step[property tranfer becomes obselete if you use groovy step] to do the same (if you are ok?):
&nbsp;
/* this script reads a json and gets the lastUpdateDate where label is
* matching with test suite property called 'Property_Name'
*/
import net.sf.json.groovy.JsonSlurper
//Using static json, you can use dynamic response as well
def jsonText = '''{
    "response" : {
        "endRow" : 300,
        "totalRows" : 21938,
        "status" : 0,
        "startRow" : 0,
        "data" : [
        	  {
                "label" : "Property_Value",
                "lastUpdateDate" : "2014-08-13T15:48:56"
            }, 
            {
                "label" : "Property_Value2",
                "lastUpdateDate" : "2014-08-13T15:48:58"
            }, 
            {
                "label" : "Property_Value3",
                "lastUpdateDate" : "2014-08-13T15:49:01"
            }
        ]
    }
}'''
def response = new JsonSlurper().parseText(jsonText).response
def dateNeeded = response.data.find{it.label==context.testCase.testSuite.properties['Property_Name'].value}.lastUpdateDate
//setting the required date in 'DATE_FROM_PREVIOUS_RESPONSE' test case property and use it later steps like ${#TestCase#DATE_FROM_PREVIOUS_RESPONSE}
context.testCase.setPropertyValue('DATE_FROM_PREVIOUS_RESPONSE', dateNeeded)
If you want to use dynamic response from previous request step, replace following in the above snippet
&nbsp;
from:
def jsonText = '''{
    "response" : {
        "endRow" : 300,
        "totalRows" : 21938,
        "status" : 0,
        "startRow" : 0,
        "data" : [
        	  {
                "label" : "Property_Value",
                "lastUpdateDate" : "2014-08-13T15:48:56"
            }, 
            {
                "label" : "Property_Value2",
                "lastUpdateDate" : "2014-08-13T15:48:58"
            }, 
            {
                "label" : "Property_Value3",
                "lastUpdateDate" : "2014-08-13T15:49:01"
            }
        ]
    }
}'''
to
//Replace the step name below.
def jsonText = context.testCase.testSteps['step1'].testRequest.response.responseContent

Hope this helps.

nmrao · Answer

What kind of assertion are you using?

corebit · Answer

Hi,&nbsp;I have got the same issue with property expansion inside JSONPath:&nbsp;I have a custom property "Property_Name" with value "Property_Value" in the TestSuite.&nbsp;Inside a transfer step I want to use it like this:$.response.data[?(@.label=='${#TestSuite#Property_Name}')]It does not work, result is [[]].But when I specify the value like in the following expression, then I get my desired result:$.response.data[?(@.label=='Property_Value')]Is property expansion inside JSONPath not possible at all or am I doing it wrong?&nbsp;Regards,Adam

nmrao · Answer

Is it possible for you to post the raw response?

corebit · Answer

Hi Rao,&nbsp;the response looks like this (shortened):{
    "response" : {
        "endRow" : 300,
        "totalRows" : 21938,
        "status" : 0,
        "startRow" : 0,
        "data" : [{
                "label" : "Property_Value",
                "lastUpdateDate" : "2014-08-13T15:48:56"
            }, {
                "label" : "Property_Value2",
                "lastUpdateDate" : "2014-08-13T15:48:58"
            }, {
                "label" : "Property_Value3",
                "lastUpdateDate" : "2014-08-13T15:49:01"
            }
        ]
    }
}Regards,&nbsp;Adam

Forum Discussion

Property Transfer - Is it possible to use test case custom property in jsonpath expression textbox?

8 Replies

Related Content

SoapUi Groovy conditional property transfer

Property Expansions in JSONPath expression in Property Transfer step

Property Transfer Conditional

SOAPUI Property Transfer XPATH

No Property-Transfer Wizard Icon

Recent Discussions

Encrypt passwords and master password?

SOAP Request works in SoapUI, but not in C# code

clone TestSuite fails when there are more project with the same name

Will SOAP UI 5.6.1 work with JDK 8

How to configure Swagger in Paas to use it in Oracle APEX instance.