Forum Discussion

anita's avatar
anita
New Contributor
5 years ago

JsonPath RegEx Match Assertion is not working on SoapUI 5.5.0 open source

I am trying to add the assertion for the JsonPath RegEx Match and it always return false even if the response is present. I am expecting the program name should have "Auto" keyword in it. I tried se...
REST
SOAP
SoapUI
  • nmrao's avatar
    nmrao
    5 years ago

    Thank you anita 

     

    I don't know about what is there in ReadyAPI.

     

    Looks different tools uses different parsers for evaluating JSONPath.

     

    For example, below sites

    https://jsonpath.com/

    https://jsonpath.curiousconcept.com/

     

    And try below json paths, and both behave differently and I assume the same is happening with SoapUI as well. Tried the same JSONPath expression in JSON Path Match, JSON Path Count and seem to be not working which are supposed to be. May be an issue with few Conditional JsonPath.

     

    • #1. $.records[?(@.Program_Name =~ /Auto*/ )].Program_Name
    • #2. $.records[?(/Auto/.test(@.Program_Name))].Program_Name

    Results same (both names) by both the Json Paths

     

    [
  "Auto Program",
  "Automation Program"
]

     

    However, Json Path match works with below expression

     

    • $.records[?(@.Program_Name == 'Auto Program')].Program_Name[0]

     

    If you still want to have your assertion with regex, then below Script Assertion can be used

     

     

    //You may even use test case custom properties for below two so that you dont have to edit to assertion when data changes
def regEx = 'Auto*' 
def expectedRecords = 2

def matchedPrograms = new groovy.json.JsonSlurper().parseText(context.response).records.findAll {it.Program_Name =~ /$regEx/}.Program_Name
log.info matchedPrograms
assert matchedPrograms.size == expectedRecords

     

     

    Thanks for the nice question.

     

    Hope SmartBear team looks into the issue dealing with conditional json path expression which contains characters such as ~

  • anita's avatar
    anita
    New Contributor
    5 years ago

    There is no option to select "Allow Wildcards" in open source. I tried to change it in the project xml file but it is also giving the same result and it overwrite(Allow wildcard to false) when I am trying to save the project. 

     

    I am looking for the solution in open source.

    • nmrao's avatar
      nmrao
      Champion Level 3
      5 years ago

      Thank you anita 

       

      I don't know about what is there in ReadyAPI.

       

      Looks different tools uses different parsers for evaluating JSONPath.

       

      For example, below sites

      https://jsonpath.com/

      https://jsonpath.curiousconcept.com/

       

      And try below json paths, and both behave differently and I assume the same is happening with SoapUI as well. Tried the same JSONPath expression in JSON Path Match, JSON Path Count and seem to be not working which are supposed to be. May be an issue with few Conditional JsonPath.

       

      • #1. $.records[?(@.Program_Name =~ /Auto*/ )].Program_Name
      • #2. $.records[?(/Auto/.test(@.Program_Name))].Program_Name

      Results same (both names) by both the Json Paths

       

      [
  "Auto Program",
  "Automation Program"
]

       

      However, Json Path match works with below expression

       

      • $.records[?(@.Program_Name == 'Auto Program')].Program_Name[0]

       

      If you still want to have your assertion with regex, then below Script Assertion can be used

       

       

      //You may even use test case custom properties for below two so that you dont have to edit to assertion when data changes
def regEx = 'Auto*' 
def expectedRecords = 2

def matchedPrograms = new groovy.json.JsonSlurper().parseText(context.response).records.findAll {it.Program_Name =~ /$regEx/}.Program_Name
log.info matchedPrograms
assert matchedPrograms.size == expectedRecords

       

       

      Thanks for the nice question.

       

      Hope SmartBear team looks into the issue dealing with conditional json path expression which contains characters such as ~