Spring testing and JsonPath probblem

Question

I am having an issue with testing and json path

I am just trying to perform a simple test and check the value of id:

mockMvc.perform(get("/applications/")).andExpect(status().isOk())
       .andDo(print())
       .andExpect(content().contentType(TestUtils.APPLICATION_JSON_UTF8))
       .andExpect(jsonPath("$", hasSize(4)))
       .andExpect(jsonPath("$.id",is(1)));

But I get an error like the following. Seems like my code should be checking the id value. Am I not being specific enough since there are multiple items in the returned JSON? Any help is appreciated. Thanks.

     Content type = application/json;charset=UTF-8
             Body = [{"id":1,"name":"test2"},{"id":2,"name":"test2"}]
   Forwarded URL = null
   Redirected URL = null
          Cookies = []

java.lang.AssertionError: No value at JSON path "$.id", exception: Expected to find an object with property ['id'] in path $ but found 'net.minidev.json.JSONArray'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.
    at org.springframework.test.util.JsonPathExpectationsHelper.evaluateJsonPath(JsonPathExpectationsHelper.java:258)
    at ...

Also you can always open any JSON path evaluator online tool, insert your JSON and test directly how the field is retrieved with your jsonPath query. — LexSav
– LexSav, Commented Jul 20, 2022 at 6:59

Mike Partridge · Accepted Answer · 2016-10-27 12:42:16Z

13

I figured out the answer5 minutes after posting. Needed to go deeper into the array. This works:

.andExpect(jsonPath("$.[0].id",is(1)));

edited Oct 27, 2016 at 12:42

Mike Partridge

5,2878 gold badges38 silver badges52 bronze badges

answered Oct 27, 2016 at 11:09

Mike

8532 gold badges13 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

paul Over a year ago

It didnt work for me stackoverflow.com/questions/47818094/json-keys-having-space

jchrbrt · Accepted Answer · 2017-07-11 10:33:37Z

8

Your JsonPath expression is wrong, because your response in the body is an array. According to the JsonPath Specification, this syntaxes are all correct:

"$[0][id]"
"$.[0].[id]"
"$[0].id"
"$.0.id"

This useful page can also help you to find out the jsonpath expression for your tests.

answered Jul 11, 2017 at 10:33

jchrbrt

1,0861 gold badge11 silver badges12 bronze badges

1 Comment

paul Over a year ago

It didnt work for me stackoverflow.com/questions/47818094/json-keys-having-space

Collectives™ on Stack Overflow

Spring testing and JsonPath probblem

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related