Hi
I am trying to set some sensors from the following JSON that details my bin collections. As these have duplicate fields, how would I select the field ‘nextDate’ for jobID 9573337 and the ‘nextDate’ for jobID 9584045? I am stumped…
{
"recordCount": 2,
"jobs_FeatureScheduleDates": [
{
"jobID": 9573337,
"jobName": "Empty Bin 240L Black",
"jobDescription": "Empty Bin 240L Black",
"jobStatus": "Not Started",
"previousDate": "2020-01-28T09:52:17.837",
"nextDate": "2020-02-11T07:00:00",
"rescheduledDate": "0001-01-01T00:00:00",
"rescheduledDateSpecified": false,
"rescheduledReason": "",
"uprn": 100090181402,
"usrn": 30101686,
"address1": "",
"address2": 12,
"street": "xx",
"locality": "xx",
"town": "xx",
"postCode": "xx",
"easting": xx,
"northing": xx,
"longitude": xx,
"latitude": xx
},
{
"jobID": 9584045,
"jobName": "Empty Bin 240L Green",
"jobDescription": "Empty Bin 240L Green",
"jobStatus": "Not Started",
"previousDate": "2020-01-21T11:53:24.833",
"nextDate": "2020-02-04T07:00:00",
"rescheduledDate": "0001-01-01T00:00:00",
"rescheduledDateSpecified": false,
"rescheduledReason": "",
"uprn": 100090181402,
"usrn": 30101686,
"address1": "",
"address2": 12,
"street": "xx",
"locality": "xx",
"town": "xx",
"postCode": "xx",
"easting": xx,
"northing": xx,
"longitude": -xx,
"latitude": xx
}
]
}