Get last value of statsd gauge from grafana server

statds-last.sh

#!/bin/bash
# Get last value of statsd gauge from grafana server
# Set env vars:
#  GRAFANA_BASE="https://www.example.com"   <-- your grafana base URL
#  GRAFANA_API_KEY="eyJryJzd.....IxMj0F9"   <-- your grafana API key

curl --compressed --silent \
    "$GRAFANA_BASE/api/datasources/proxy/1/render" \
    -H "Authorization: Bearer $GRAFANA_API_KEY" \
    --data-urlencode "target=summarize($1, "'"1h", "last")' \
    --data-urlencode "from=-30min" \
    --data-urlencode "to=now" \
    --data-urlencode "format=json" \
    --data-urlencode "maxDataPoints=4" \
| jq -r '.[0].datapoints[-1]|map(tostring)|join("\t")' \
| cut -f1  # remove this line to return "value<TAB>time"