AQW - Publish data to Goliath & visualise in a Grafana Dashboard

jaredwolff

From the link you shared above and ethernet_hub_ble code unchanged, I should be able use Golioth's WebSocket API to graph the LightDB State data.

Steps:

1. Install the Golioth’s WebSocket API in the Grafana Cloud instance

2. Create a WebSocket API data source

3. Fill in the WebSocket API info:
   Host: wss://api.golioth.io/v1/projects/{Project ID}, add Custom Headers
   Header: X-API-Key and the value, then Save & test
   Grafana displays that the “Data source is working”.

4. Create a dashboard with the following.
   Set Data source to WebSocket API
   Add Path and Fields for LightDB State and transform the JSON result into something that the dashboard can display, for example
   Path: /devices/{Device Id}
   Field $..env.hum
   Field $..env.temp

LightDB State
{1 item
     "env":{4 items
       "hum":30
       "pm25":2
       "temp":26
       "voc":52
      }
}

I tried creating a dashboard but got error Some queries returned an error: Query A - undefined.

I don’t see anything wrong with Data source configuration but there may be some other configuration issue.

I’ll open a ticket with Grafana Support.

zpm1066

I’ve also ran curl against the device’s JSON endpoint to confirm that JSON data source returns the expected sensor data. Below, I’ve replaced the actual API key by myapikey.

$ curl -X 'GET' \

'https://api.golioth.io/v1/projects/aqw1066/devices/643c620df272169b4557ee61/data/env' \
-H 'accept: application/json' \
-H 'x-api-key: myapikey' \
-H 'Authorization: myapikey'
{"data":{"hum":20,"pm25":0,"temp":41,"voc":265}

jaredwolff

Hi Jared,

Success!! I had call with Golioth and was recommended to use the JSON APIfor both LightDb State and LightDB Stream, as the sensors publish data at relatively slow interval of per minute.

The resolution turned out to be a minor change in the Grafana Dashboard Path, plus an addition of a query in the Body of the Dashboard configuration.

I used the version of JSON API plugin that is available in Grafana Cloud, the same one that I tried using earlier.

Golioth weren’t sure why the WebSocket API didn’t work and will get back to me.

Later I’ll setup separate charts for each of the sensors, as you had in your JSON.

What’s the best to generate what you had in the Air Quality Wing-1633657750477.json? Thanks.

Data source - JSON API
https://api.golioth.io/v1/projects/aqw1066


Dashboard Configuration

Path
POST
/devices/mydevicei/stream

Fields
$..time
$..env.hum
$..env.voc
$..env.temp
$..env.p25

Body
{
	"start" : "${__from:date}",
        "end" : "${__to:date}",
	"perPage" : 99999,
	"query": {
		"fields" : [
			{ "path": "time" },
			{ "path": "deviceId"},
			{ "path": "*"}
		],
		"timeBucket" : "5s"
	}
}