How to capture values from json response with multiple conditions

Gatling (Open-Source)
1

HI,

I have a Json response as below…

“slots”: [
{
“slotId”: “123”,
“start”: “2020-02-11T08:00:00.000Z”,
“end”: “2020-02-11T09:00:00.000Z”,
“expiry”: “2020-02-11T00:01:00Z”,
“charge”: 6,
“status”: “Available”,
“group”: 1,
“locationId”: “XXXX”
},
{
“slotId”: “456”,
“start”: “2020-02-11T09:00:00.000Z”,
“end”: “2020-02-11T10:00:00.000Z”,
“expiry”: “2020-02-11T00:01:00Z”,
“charge”: 6,
“status”: “Available”,
“group”: 1,
“locationId”: “XXXX”
}]

From the above Json response i wanted to capture slotid, start, end, charge, licationid values if status available and start any date but time should be 08:00 or 09:00.

Conditions are “status”: “Available”, and “start”: “*T08:00:00.000Z”, OR “start”: “*T09:00:00.000Z”, OR “start”: “*T10:00:00.000Z” etc.

I Could capture all values by using one condition as below…

jsonPath("$.slots[?(@.status==‘Available’)].slotId").findAll.optional.saveAs(“c_SlotId”),
jsonPath("$.slots[?(@.status==‘Available’)].start").findAll.optional.saveAs(“c_SlotStartTime”),
jsonPath("$.slots[?(@.status==‘Available’)].end").findAll.optional.saveAs(“c_SlotEndTime”),
jsonPath("$.slots[?(@.status==‘Available’)].locationId").findAll.optional.saveAs(“c_DelLocId”),
jsonPath("$.slots[?(@.status==‘Available’)].charge").findAll.optional.saveAs(“c_DelCharge”),
jsonPath("$.slots[?(@.status==‘Available’)].status").findAll.optional.saveAs(“c_Slotstatus”)

with the status available condition i dont have idea how to add another condition with start time. Can someone help me how to add multiple start times also in the above?

Thanks in advance,
Swetha. G

2

Try this $.slots[?(@.status==‘Available’ && @.start==‘2020-02-11T08:00:00.000Z’)].slotId