Connecting Grafana to 3CX documentation
Grafana Cloud or Grafana on-premise
Using WebAPI, Grafana makes POST requests to the 3CX database using the standard port (default is 5001). The received data in JSON format is used to display reports and dashboards.
You need to have a WebAPI & Webhook bundle license to use Grafana 3CX connection.
You need to have a WebAPI & Webhook bundle license to use Grafana 3CX connection.
0
You should have an active Grafana Cloud account or have Grafana Enterprise installed
1
Add Data source JSON API
Specify https://{{3CXFQDN}}/webapi/{{AccessKey}}/ as HTTP URL. Default access key is JNJP5UqGDhX89ue2POsb1Kto
Specify https://{{3CXFQDN}}/webapi/{{AccessKey}}/ as HTTP URL. Default access key is JNJP5UqGDhX89ue2POsb1Kto
2
Add Visualization panel to a dashboard
Specify POST /query as a path. Set cache time = 0s
Specify POST /query as a path. Set cache time = 0s
3
Specify a POST JSON request as a body
e.g. {"query":"SELECT * FROM public.call_history_view where segment_start_time >= '${__from:date}' and segment_start_time <= '${__to:date}';",
"count":"100"
}
e.g. {"query":"SELECT * FROM public.call_history_view where segment_start_time >= '${__from:date}' and segment_start_time <= '${__to:date}';",
"count":"100"
}
4
Specify a $.result[*][0], $.result[*][1]... as a JSONPath fields
You can specify as many fields as columns your request contains
You can specify as many fields as columns your request contains
5
For using variables add Query Type and use a similar connection scheme.
For using variable in panel use where Ext = ANY('{${Extension:raw}}')
For using variable in panel use where Ext = ANY('{${Extension:raw}}')
6
Download Grafana to 3CX collection of wallboards (download and import in Grafana)
Integration tutorial 3CX and Grafana BI
3CX custom reports and wallboards with Grafana BI