I have a json input with different fields name and I would like to filter the data in order to keep at the end of the chain only the records that have a specific field
For example in the data set below I just want to keep records that have field " recordid
"
{
"records": [
{
"fields": {
"last_reported": 1519897717,
"lon": 2.275342586850291,
"station_id": 7234,
"xy": [
48.8296843301,
2.27534258685
],
"lat": 48.8296843300915,
"name": "Colonel Pierre Avia",
"numbikesavailable": 4,
"capacity": 31,
"is_installed": 1,
"numdocksavailable": 25,
"is_renting": 1,
"is_returning": 1
},
"geometry": {
"coordinates": [
2.27534258685,
48.8296843301
],
"type": "Point"
},
"recordid": "e9a4f7a8874ba8dd9b3d004640d99759b3683005"
},
{
"fields": {
"last_reported": 1519897717,
"lon": 2.275342586850291,
"station_id": 7234,
"xy": [
48.8296843301,
2.27534258685
],
"lat": 48.8296843300915,
"name": "Colonel Pierre Avia",
"numbikesavailable": 4,
"capacity": 31,
"is_installed": 1,
"numdocksavailable": 25,
"is_renting": 1,
"is_returning": 1
},
"geometry": {
"coordinates": [
2.27534258685,
48.8296843301
],
"type": "Point"
},
"recordid": "u9h4f5a0874ba8dd9b3d004874d99759b3689740"
},
{
"fields": {
"last_reported": 1519897923,
"station_id": 54000632,
"is_installed": 0,
"numbikesavailable": 26,
"numdocksavailable": 10,
"is_renting": 0,
"is_returning": 0
}
},
{
"fields": {
"last_reported": 1519897923,
"station_id": 54000632,
"is_installed": 0,
"numbikesavailable": 26,
"numdocksavailable": 10,
"is_renting": 0,
"is_returning": 0
}
},
{
"fields": {
"last_reported": 1519897923,
"station_id": 54000632,
"is_installed": 0,
"numbikesavailable": 26,
"numdocksavailable": 10,
"is_renting": 0,
"is_returning": 0
}
}
]
}
I did not find how to do this with prune filter plugin,
Do you have idea how to do this and could you help me to solve my problem please?