What's the best way to parse a JSON response from a web API?

One of the tools I use is Nodeping. Their API can output the details of all the checks and their statuses but it cannot output a simple count of failed checks. What’s the best and/or most efficient way of parsing that JSON response into something that I can use in Grafana?

At the moment, i’m only aiming to put just the number of failed checks in a singlestat panel. In the future I might take per-minute snapshots of the failed checks to form a graph.

simplest thing would be to write a small node app that reads the API json and transforms the data and saves it into a time series database like Graphite or InfluxDB

I was hoping it wouldn’t come to that…but it’s ok if it has to be so. Thanks. :slight_smile: