Forum Discussion

jcskillings's avatar
jcskillings
New Contributor
8 years ago

Unable to filter for null values with JSONpath

I am attempting to apply some assertions against a JSON response where some of the field values are null (6/10 results in my example). In the example I can successfully filter using, to return the co...
  • PaulMS's avatar
    PaulMS
    8 years ago

    $.result.[?(@.colorCategoryId==null)].colorCategoryId works with JSONPath Online Evaluator - jsonpath.com but not JSONpath match assertion for some reason.

     

    A script assertion as a workaround could find all results with null

     

    import groovy.json.JsonSlurper
    json = new JsonSlurper().parseText(messageExchange.response.contentAsString)

    nullcategory = json.result.findAll {it.colorCategoryId == null}
    assert nullcategory.size() == 6
    log.info nullcategory.id

     

PaulMS's avatar
PaulMS
Super Contributor
8 years ago

$.result.[?(@.colorCategoryId==null)].colorCategoryId works with JSONPath Online Evaluator - jsonpath.com but not JSONpath match assertion for some reason.

 

A script assertion as a workaround could find all results with null

 

import groovy.json.JsonSlurper
json = new JsonSlurper().parseText(messageExchange.response.contentAsString)

nullcategory = json.result.findAll {it.colorCategoryId == null}
assert nullcategory.size() == 6
log.info nullcategory.id

 

  • jcskillings's avatar
    jcskillings
    New Contributor
    8 years ago

    Yes, I have also noticed some discrepancies with various JSONpath evaluators online and how SoapUI handles JSONpath. It seems there are some differences in implementation. 

     

    Thank you for the script example it worked well. I should also mention that in this case I found I was able to use an XPath Match assertion to filter for the null values as another workaround:

     

    declare namespace ns1='https://excelsiorqa-api.eyekor.com/api/v1/Series';
//ns1:Response[1]/ns1:result[1]/ns1:e[ns1:colorCategoryId[@null='true']]/ns1:id