Hello,
I get the JSON, listed below back from my community when I do a post to their API:
How can I filter out the next collection date from this JSOn and display it in my dashboard? It must be done with value templating and json but I can’t figure it out exactly.
With kind regards,
Remco
The Netherlands
[[
{
"pickupDates": [
"2019-01-16T00:00:00",
"2019-02-13T00:00:00",
"2019-03-13T00:00:00",
"2019-04-10T00:00:00",
"2019-05-08T00:00:00",
"2019-06-05T00:00:00",
"2019-07-03T00:00:00",
"2019-07-31T00:00:00",
"2019-08-28T00:00:00",
"2019-09-25T00:00:00",
"2019-10-23T00:00:00",
"2019-11-20T00:00:00",
"2019-12-18T00:00:00"
],
"pickupType": 0,
"_pickupType": 0,
"_pickupTypeText": "GREY",
"description": "GREY"
},
{
"pickupDates": [
"2019-01-02T00:00:00",
"2019-01-30T00:00:00",
"2019-02-27T00:00:00",
"2019-03-27T00:00:00",
"2019-04-24T00:00:00",
"2019-05-22T00:00:00",
"2019-06-19T00:00:00",
"2019-07-17T00:00:00",
"2019-08-14T00:00:00",
"2019-09-11T00:00:00",
"2019-10-09T00:00:00",
"2019-11-06T00:00:00",
"2019-12-04T00:00:00",
],
"pickupType": 10,
"_pickupType": 10,
"_pickupTypeText": "PACKAGES",
"description": "PACKAGES"
},
{
"pickupDates": [
"2019-01-09T00:00:00",
"2019-01-23T00:00:00",
"2019-02-06T00:00:00",
"2019-02-20T00:00:00",
"2019-03-06T00:00:00",
"2019-03-20T00:00:00",
"2019-04-03T00:00:00",
"2019-04-17T00:00:00",
"2019-05-01T00:00:00",
"2019-05-15T00:00:00",
"2019-05-29T00:00:00",
"2019-06-12T00:00:00",
"2019-06-26T00:00:00",
"2019-07-10T00:00:00",
"2019-07-24T00:00:00",
"2019-08-07T00:00:00",
"2019-08-21T00:00:00",
"2019-09-04T00:00:00",
"2019-09-18T00:00:00",
"2019-10-02T00:00:00",
"2019-10-16T00:00:00",
"2019-10-30T00:00:00",
"2019-11-13T00:00:00",
"2019-11-27T00:00:00",
"2019-12-11T00:00:00"
],
"pickupType": 1,
"_pickupType": 1,
"_pickupTypeText": "GREEN",
"description": "GREEN"
},
{
"pickupDates": [
"2019-01-21T00:00:00",
"2019-03-04T00:00:00",
"2019-04-15T00:00:00",
"2019-05-27T00:00:00",
"2019-07-08T00:00:00",
"2019-08-19T00:00:00",
"2019-09-30T00:00:00",
"2019-11-11T00:00:00",
"2019-12-23T00:00:00",
"2019-01-21T00:00:00",
"2019-03-04T00:00:00",
"2019-04-15T00:00:00",
"2019-05-27T00:00:00",
"2019-07-08T00:00:00",
"2019-08-19T00:00:00",
"2019-09-30T00:00:00",
"2019-11-11T00:00:00",
"2019-12-23T00:00:00"
],
"pickupType": 2,
"_pickupType": 2,
"_pickupTypeText": "PAPER",
"description": "PAPER"
}
]