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?

Recent Discussions

SoapUI 5.9.0 released

OS SoapUI: Can it connect and use Cosmos DB

"Clone interface" between projects not working

Related Content

Property Expansions in JSONPath expression in Property Transfer step

Regular expressions in name mapping property values

Property Transfer Conditional