Hi Grafana Community! I am running Grafana in docker (latest) on Ubuntu 16.04 on a ‘shuttle’ mini-computer. I want to display a state timeline for my external monitors. I use a REST API from UptimeRobot through the infinity datasource. I managed to get the result I wanted : [image] My problem…

UQL can be enhanced like this to get each line of log item. Hope this gives some hint. parse-json | scope "0.schema.meta.custom.data.monitors" | extend "create_datetime"=unixtime_seconds_todatetime("create_datetime") | mv-expand "log"="logs" | extend "log_date"=unixtime_seconds_todatetime("log.date…

Welcome Could you please post the json data coming back from getMonitors?

Hi yosiasz, thanks for the extremely quick response. here is the json : "meta": { "custom": { "data": { "monitors": [ { "create_datetime": 1661423792, "custom_down_durations": "210", "custom_uptime_ratio": "99.984", "fr…

parses as invalid json. please vet json data on online json validator?

Here is a valid JSON. thanks a lot for all your help. [{ "schema": { "refId": "COGILOG", "meta": { "custom": { "data": { "monitors": [{ "create_datetime": 1661423792, "custom_down_durations": "210", "custom_uptime_ratio": "99.986", "friendly_name": "OHA…

Wow, thanks a lot for this, i will try it asap.

I have been trying to make it work with UQL and jsonata. The input of the timeline should be logs.startdate and logs.type for each monitor. This allows me to show up/down time sequence for each monitor. but I don’t know how to structure my data with JSONata so that the timeline panel understands …

Which data points do you want to plot and what kind of visualization? I do not see logs.startdate

I want to use the state timeline visualisation to display the on/off timeline of my monitors. the input needed for that are logs.datetime (start of each state) and logs.type (value of each state) for each monitor I am sorry if I am unclear, english is not my native language.

logs is an array. so which one do you want. all of them? "logs": [ { "datetime": 1662069251, "duration": 918119, "id": 2730362006, "reason": { "code": "1", "detail": "OK" }, "type": 2 }, { "datetime": 1662069104, "duration": 147, "id": 2730360265, "reason…

Use several tables from the same query in State Timeline panel

Grafana Developers & API

yosiasz September 12, 2022, 3:10pm 7

use UQL and jsonata

parse-json
| jsonata "schema.meta.custom.data.monitors"
| extend "start"=unixtime_seconds_todatetime("create_datetime")
| project "type","start", "friendly_name"

Topic		Replies	Views
Time duration calculation between rows Dashboards infinity-datasource	21	847	March 18, 2025
Empty values not shown Bar Chart Panel	37	5169	November 23, 2022
View json data in table - Grafana Dashboards api , query-help , json-api-datasource , json , infinity-datasource	2	11949	September 12, 2022
Unable to plot trend using timeseries panel using infinity datasource Dashboards infinity-datasource	7	109	November 5, 2025
How to create a table with multiple fields using UQL Dashboards infinity-datasource	3	560	January 11, 2024

Use several tables from the same query in State Timeline panel

Related topics