Gatling - Looping through a JSON Array

Question

I have a block of code that needs to go through a JSON array that is obtained from a REST service response. ( A complete list is available here .)

.exec(http("Request_1") .post("/endPoint") .headers(headers_1) .body(StringBody("""REQUEST_BODY""")).asJSON .check(jsonPath("$.result").is("SUCCESS")) .check(jsonPath("$.data[*]").findAll.saveAs("pList"))) .exec(session => { println(session) session }) .foreach("${pList}", "player"){ exec(session => { val playerId = JsonPath.query("$.playerId", "${player}") session.set("playerId", playerId) }) .exec(http("Request_1") .post("/endPoint") .headers(headers_1) .body(StringBody("""{"playerId":"${playerId}"}""")).asJSON .check(jsonPath("$.result").is("SUCCESS"))) } 

The response format of the first request was

 { "result": "SUCCESS", "data": [ { "playerId": 2 }, { "playerId": 3 }, { "playerId": 4 } ] } 

And playerId appears in the session as

 pList -> Vector({playerId=2, score=200}, {playerId=3, score=200} 

I see in the second query the body

 {"playerId":"Right(empty iterator)} 

Expected: 3 queries with body as

  {"playerId":1} {"playerId":2} {"playerId":3} 

I can successfully process the resulting array if I save only the player files:

 .check(jsonPath("$.data[*].playerId").findAll.saveAs("pList"))) 

Answer 1

I managed to get the requests you are looking for sent (although it is still receiving 404, but it could be the server side or the request that your gist sends may not be available). The trick was to completely abandon JsonPath:

 .exec(http("Request_10") .get("gatling1") .headers(headers_10) .check(jsonPath("$.result").is("SUCCESS"), jsonPath("$.data[*]").ofType[Map[String,Any]].findAll.saveAs("pList"))) .foreach("${pList}", "player") { exec(session => { val playerMap = session("player").as[Map[String,Any]] val playerId = playerMap("playerId") session.set("playerId", playerId) }) 

Here, the jsonPath check can automatically save your JSON object as a map, and then you can access the player ID by key. The value type should not be Any ; you can use Int or Long if all your values ​​are numbers. If you need more information on what went wrong with jsonPath , read on.

---

Your first problem is that JsonPath.query() does not just return the value you are looking for. From the JsonPath readme :

JsonPath.query ("$. A", jsonSample) gives you the right one (non-empty iterator). This will allow you to iterate over all possible solutions for the query.

Now that he says Right(non-empty iterator) , I assumed that this means that the iterator is not empty. However, if you try this:

 val playerId = JsonPath.query("$.playerId", session("player").as[String]).right.get println(playerId) 

... prints an "empty iterator". I'm not sure if this is a problem with jsonPath , jsonPath tag or using somewhere in between, but I lack documentation so that I can insert it.