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