Substations_V2

Get analog and digital-event data from a single substation.

Substation variables are open-ended (each installation reports its own
set of analog measurements and digital events), so this returns raw
varname/value readings instead of fixed columns.

You can enter a range of dates to get the data for that period.

/v2/substations/<dev-id>/?start=XXX&end=XXX&varname=XXX

Arguments

  • dev_id [*]: Device id number

  • start: (Optional) (yyyy-mm-dd hh:ii:ss) Start date of search interval.
    If you only enter the start date it will show the reading of that moment.

  • end: (Optional) (yyyy-mm-dd hh:ii:ss) End date of search interval.
    Can not be greater than the current date or the difference
    between dates can not be greater than 32 days
  • varname: (Optional) Filter by variable name. Supports SQL LIKE wildcards (%).
    If omitted, all variables are returned.

Response

JSON object with the result. May return the following errors:

  • 404 Not found : No device found or don't have rights to get data
  • 400 Wrong plant or substation id: The id format is incorrect
  • 400 Bad Dates: Dates entered are incorrect
  • 204 No data found: The data entered have not produced any results

Example

Get all substation data (last quarter) for device_id 5

GET /v2/substations/5 HTTP/1.1
Host: apiexternal.mvscada.com
MV-API-Key: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
Content-Type: application/json

Response

{
    "plant": "XXXXXXXX",
    "devices_id": XXXX,
    "start": "2025-04-25 11:15:00",
    "end": "",
    "varname": null,
    "analog": [
        {
            "data_sub_analog_datetime": "2025-04-25 11:15:00",
            "data_sub_analog_varname": "Tension Va dev A",
            "data_sub_analog_value": 231.4
        }
    ],
    "events": [
        {
            "data_sub_events_datetime": "2025-04-25 11:12:03",
            "data_sub_events_type": "change",
            "data_sub_events_varname": "CB1.1",
            "data_sub_events_value": 1
        }
    ]
}

Other examples

Get all data of a substation between requested dates

/v2/substations/<dev-id>/?start=2025-04-25 00:00:00&end=2025-04-25 11:15:00

Get only one variable (exact match or with LIKE wildcards)

/v2/substations/<dev-id>/?varname=Tension Va dev A
/v2/substations/<dev-id>/?varname=Tension%25