The SQL DM for MySQL API allows users to retrieve monitor and chart values programmatically. The API supports fetching current, delta, and historical data.

Base URL

http://127.0.0.1:5555/

Authentication

All API requests require authentication using the following parameters:

API Endpoints

Description:

Retrieves all enabled monitors' values.

Endpoint:

_object=MONyogAPI&_action=GetAllMonitorsValues&_user=admin&_password=Test@123&_server=[server_name]&_type=[current/delta/history]&_starttime=[timestamp]&_endtime=[timestamp]

Request Parameters:

  • _server: Server name
  • _type: current, delta, or history
  • _starttime & _endtime: Required if _type=history (Start time & end time in UNIX timestamp format)

Example Call:

http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetAllMonitorsValues&_user=admin&_password=Test@123&_server=testServer1&_type=current

Description:

Fetches the value of a specific monitor.

Endpoint:

_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]

Request Parameters:

  • _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)

Example Call:

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

Description:

Retrieves trend values of a specific monitor over time.

Endpoint:

_object=MONyogAPI&_action=GetMonitorTrendValues&_user=admin&_password=Test@123&_server=[server_name]&_group_id=[group_id]&_counter_id=[counter_id]&_starttime=[timestamp]&_endtime=[timestamp]

Request Parameters:

  • _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)

Example Call:

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

Description:

Retrieves all chart values of a specific dashboard.

Endpoint:

_object=MONyogAPI&_action=GetAllChartsValues&_user=admin&_password=Test@123&_server=[server_name]&_dashboard=[dashboard_name]&_starttime=[timestamp]&_endtime=[timestamp]

Request Parameters:

  • _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)

Example Call:

http://127.0.0.1:5555/?_object=MONyogAPI&_action=GetAllChartsValues&_user=admin&_password=Test@123&_server=server1&_dashboard=Performance Metrics 

Description:

Retrieves values of a specific chart.

Endpoint:

_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]

Request Parameters:

  • _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)

Example Call:

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

Response Format

All API responses return JSON data.

Success Response:

{
"STATUS": "SUCCESS",
"RESPONSE": [{
"GroupName": "xxxx",
"CounterName": "xxxx",
"Value": "Yes",
"AlertStatus": "1",
"AlertCondition": "None"
}]
}

Failure Response:

{
"STATUS": "FAILURE",
"RESPONSE": "Error Message"
}