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 Calls:

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 Calls:

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 Calls:

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