The SQL DM for MySQL API allows users to retrieve monitor and chart values programmatically. The API supports fetching current, delta, and historical data.
http://127.0.0.1:5555/
All API requests require authentication using the following parameters:
_user=admin _password=Test@123
Get All Monitors Values
Retrieves all enabled monitors' values.
_object=MONyogAPI&_action=GetAllMonitorsValues&_user=admin&_password=Test@123&_server=[server_name]&_type=[current/delta/history]&_starttime=[timestamp]&_endtime=[timestamp]
_server: Server name_type: current, delta, or history_starttime & _endtime: Required if _type=history (Start time & end time in UNIX timestamp format)http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetAllMonitorsValues&_user=admin&_password=Test@123&_server=testServer1&_type=current
Get Monitor Value
Fetches the value of a specific monitor.
_object=MONyogAPI&_action=GetMonitorValue&_user=admin&_password=Test@123&_server=[server_name]&_group_id=[group_id]&_counter_id=[counter_id]&_type=[current/delta/history]&_starttime=[timestamp]&_endtime=[timestamp]
_server: Server name_group_id: Monitor’s group ID_counter_id: Monitor’s counter ID_type: current, delta, or history_starttime & _endtime: Required if _type=history (Start time & end time in UNIX timestamp format)http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetMonitorValue&_user=admin&_password=Test@123&_server=testServer1&_type=current&_group_id=5&_counter_id=1
Get Monitor Trend Values
Retrieves trend values of a specific monitor over time.
_object=MONyogAPI&_action=GetMonitorTrendValues&_user=admin&_password=Test@123&_server=[server_name]&_group_id=[group_id]&_counter_id=[counter_id]&_starttime=[timestamp]&_endtime=[timestamp]
_server: Server name_group_id: Monitor’s group ID_counter_id: Monitor’s counter ID_starttime: Start time in UNIX timestamp format(Mandatory)_endtime: End time in UNIX timestamp format(Mandatory)http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetMonitorTrendValues&_user=admin&_password=Test@123&_server=test11&_type=current&_starttime=1737484200&_endtime=1737533940&_group_id=5&_counter_id=2
Get All Charts Values
Retrieves all chart values of a specific dashboard.
_object=MONyogAPI&_action=GetAllChartsValues&_user=admin&_password=Test@123&_server=[server_name]&_dashboard=[dashboard_name]&_starttime=[timestamp]&_endtime=[timestamp]
_server: Server name_dashboard: Dashboard name_starttime: Start time in UNIX timestamp format (optional for current values)_endtime: End time in UNIX timestamp format (optional for current values)http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetAllChartsValues&_user=admin&_password=Test@123&_server=server1&_dashboard=Performance Metrics
Get Chart Values
Retrieves values of a specific chart.
_object=MONyogAPI&_action=GetChartValues&_user=admin&_password=Test@123&_server=[server_name]&_dashboard=[dashboard_name]&_group_id=[group_id]&_counter_id=[counter_id]&_starttime=[timestamp]&_endtime=[timestamp]
_server: Server name_dashboard: Dashboard name_group_id: Chart group ID_counter_id: Chart counter ID_starttime: Start time in UNIX timestamp format (optional for current values)_endtime: End time in UNIX timestamp format (optional for current values)http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetChartValues&_user=admin&_password=Test@123&_server=server1&_dashboard=Performance Metrics&_group_id=23&_counter_id=2
All API responses return JSON data.
{
{