BASH vs. JSON :)

curl -s “https://www.pegelonline.wsv.de/webservices/rest-api/v2/stations.json?includeTimeseries=true&includeCurrentMeasurement=true”| jq -j –tab ‘.[] | select( ( .timeseries[0].currentMeasurement.stateMnwMhw==”low” or .timeseries[0].currentMeasurement.stateMnwMhw==”high” ) and .timeseries[0].shortname==”W” ) | [ .number, .water.longname, .longname, .latitude, .longitude, .timeseries[0].currentMeasurement.stateMnwMhw, .timeseries[0].currentMeasurement.trend, .timeseries[0].currentMeasurement.value ] | “\(.[0])|\(.[1])|\(.[2])|\(.[3])|\(.[4])|\(.[5])|\(.[6])|\(.[7])\n”‘)