Query Metric Data


Query metric data in batches. At most the first 10000 pieces of data sorted by time can be returned.

Before You Start


Ensure that the derived metrics, compound metrics, and the query mappings have been created and published.

Using Get Method

Request Format


GET https://{apigw-address}/metric-mgmt/v1.0/metricIds/data/normal

Request Parameters (Header)


Name

Mandatory/Optional

Data Type

Description

Content-type

Mandatory

String

The content or file types. The value is set to application/json by default.

Request Parameters (URI)


Name

Location(Path/Query)

Mandatory/Optional

Data Type

Description

orgId

Query

Mandatory

String

The organization ID which the attribute belongs to. How to get orgId >>

metricIds

Query

Mandatory

String

The metric IDs needs to be queried. Separate multiple metric IDs by commas.

startTime

Query

Optional

String

The start time. Format: yyyy-MM-dd HH:mm:ss.

Notes:

This parameter can be ignored when querying single-valued metrics. For example, when querying the power generation of this month, the metric data will be returned according to the current time.

This parameter is optional when querying multi-valued metrics. The start time will be set as 00:00:00 by default if this parameter is not passed.

When only passing the partially time, the time will be filled in according to the format. For example, when passing 2021 as this parameter, the time will be set as 2021-01-01 00:00:00 by default.

endTime

Query

Optional

String

The end time. Format: yyyy-MM-dd HH:mm:ss.

Notes:

This parameter can be ignored when querying single-valued metrics. For example, when querying the power generation of this month, the metric data will be returned according to the current time.

This parameter is optional when querying multi-valued metrics. The end time will be set as 23:59:59 by default if this parameter is not passed.

When only passing the partially time, the time will be filled in according to the format. For example, when passing 2021 as this parameter, the time will be set as 2021-01-01 00:00:00 by default.

mdmIds

Query

Optional

String

The device ID. Separate multiple device IDs by commas. If this parameter is null, all of the devices will be queried by default.

extraFields

Query

Optional

String

Query the attributes of other dimensions.

valueEnum

Query

Optional

Boolean

The enum values of the metrics.

format

Query

Optional

Int

The return format of the query result.

When the value of the format is 0:The default format. The device ID, time, and metric data related to the metric will be returned when setting the metric ID as the query index.

When the value of the format is 1:The time and metric data related to the metric will be returned when setting the metric ID and device ID as the query index.

When the value of the format is 2:The time and metric data of metrics related to the devices will be returned when setting the device ID as the query index.

Response Parameters


Name

Data Type

Description

data

List<JSONObject>

Return metric data. For more information, see Metric Data Format>>

Metric Data Format


Name

Data Type

Description

metricIdentifier

String

Metric ID

time

String

Time

mdmId

String

Device

Samples

Request Sample


url: https://{apigw-address}/metric-mgmt/v1.0/metricIds/data/normal?orgId=orgId&metricIds=metricId0,metricId1&startTime=2021-05-19 00:00:00&endTime=2021-05-21 00:00:00

method: GET

Return Sample


The return sample is as bellow when the value of the request parameter format is 0.


{
  "msg": "OK",
  "code": 0,
  "data": [
        {
            "metricIdentifier":"MetricId0",
            "value":[
                {
                "storage_active_electric": 2200.00,
                "time": "2021-05-20",
                "mdmId": "mdmId0"
                },
                {
                "storage_active_electric": 100.00,
                "time": "2021-05-20",
                "mdmId": "mdmId1"
                }
            ]
        },
        {
            "metricIdentifier":"MetricId1",
            "value":[
                {
                "storage_reactive_electric": 2200.00,
                "time": "2021-05-20",
                "mdmId": "mdmId0"
                },
                {
                "storage_reactive_electric": 100.00,
                "time": "2021-05-20",
                "mdmId": "mdmId1"
                }
            ]
        }
    ]
}


The return sample is as bellow when the value of the request parameter format is 1.


{
  "msg": "OK",
  "code": 0,
  "data": [
        {
            "metricIdentifier": "MetricId0",
            "mdmId": "mdmId0",
            "value": [
                {
                    "storage_active_electric": 2200.00,
                    "time": "2021-05-20"

                },
                {
                    "storage_active_electric": 100.00,
                    "time": "2021-05-20"
                }
            ]
        },
        {
            "metricIdentifier": "MetricId0",
            "mdmId": "mdmId1",
            "value": [
                {
                    "storage_active_electric": 2200.00,
                    "time": "2021-05-20"

                },
                {
                    "storage_active_electric": 100.00,
                    "time": "2021-05-20"
                }
            ]
        },
        {
            "metricIdentifier": "MetricId1",
            "mdmId": "mdmId0",
            "value": [
                {
                    "storage_reactive_electric": 2200.00,
                    "time": "2021-05-20"
                },
                {
                    "storage_reactive_electric": 100.00,
                    "time": "2021-05-20",
                }
            ]
        },
        {
            "metricIdentifier": "MetricId1",
            "mdmId": "mdmId1",
            "value": [
                {
                    "storage_reactive_electric": 2200.00,
                    "time": "2021-05-20"
                },
                {
                    "storage_reactive_electric": 100.00,
                    "time": "2021-05-20"
                }
            ]
        }
    ]
}


The return sample is as bellow when the value of the request parameter format is 2.


{
  "msg": "OK",
  "code": 0,
  "data": [
    {
        "mdmId": "mdmId0",
        "value":[
            {
                "MetricId0": 2200.00,
                "MetricId1": 2200.00,
                "time": "2021-05-20"
            },
            {
                "MetricId0": 100.00,
                "MetricId1": 100.00,
                "time": "2021-05-21"
            }
        ]
    },
    {
        "mdmId": "mdmId1",
        "value":[
            {
                "MetricId0": 2200.00,
                "MetricId1": 2200.00,
                "time": "2021-05-20"
            },
            {
                "MetricId0": 100.00,
                "MetricId1": 100.00,
                "time": "2021-05-21"
            }
        ]
    }
]
}

SDK Sample


You can access the SDK samples for metric management service on GitHub:

Using POST Method

Request Format


POST https://{apigw-address}/metric-mgmt/v1.0/metricIds/data/normal

Request Parameters (Header)


Name

Mandatory/Optional

Data Type

Description

Content-type

Mandatory

String

The content or file types. The value is set to application/json by default.

Request Parameters (Body)


Name

Mandatory/Optional

Data Type

Description

orgId

Mandatory

String

The organization ID which the attribute belongs to. How to get orgId >>

metricIds

Mandatory

String

The metric IDs needs to be queried. Separate multiple metric IDs by commas.

startTime

Optional

String

The start time. Format: yyyy-MM-dd HH:mm:ss.

Notes:

This parameter can be ignored when querying single-valued metrics. For example, when querying the power generation of this month, the metric data will be returned according to the current time.

This parameter is optional when querying multi-valued metrics. The start time will be set as 00:00:00 by default if this parameter is not passed.

When only passing the partially time, the time will be filled in according to the format. For example, when passing 2021 as this parameter, the time will be set as 2021-01-01 00:00:00 by default.

endTime

Optional

String

The end time. Format: yyyy-MM-dd HH:mm:ss.

Notes:

This parameter can be ignored when querying single-valued metrics. For example, when querying the power generation of this month, the metric data will be returned according to the current time.

This parameter is optional when querying multi-valued metrics. The end time will be set as 23:59:59 by default if this parameter is not passed.

When only passing the partially time, the time will be filled in according to the format. For example, when passing 2021 as this parameter, the time will be set as 2021-01-01 00:00:00 by default.

mdmIds

Optional

String

The device ID. Separate multiple device IDs by commas. If this parameter is null, all of the devices will be queried by default.

extraFields

Optional

String

Query the attributes of other dimensions.

valueEnum

Optional

Boolean

The enum values of the metrics.

format

Optional

Int

The return format of the query result.

When the value of the format is 0:The default format. The device ID, time, and metric data related to the metric will be returned when setting the metric ID as the query index.

When the value of the format is 1:The time and metric data related to the metric will be returned when setting the metric ID and device ID as the query index.

When the value of the format is 2:The time and metric data of metrics related to the devices will be returned when setting the device ID as the query index.

Response Parameters


Name

Data Type

Description

data

List<JSONObject>

Return metric data. For more information, see Metric Data Format>>

Metric Data Format


Name

Data Type

Description

metricIdentifier

String

Metric ID

time

String

Time

mdmId

String

Device

Samples

Request Sample


url: http://{apigw-address}/metric-mgmt/v1.0/metricIds/data/normal?orgId=orgId

method: POST

request body:

{
    "orgId": "orgId of metric",
    "metricIds": "metricId",
    "mdmIds": "mdmId",
    "startTime": "2022-01-19 14:18:07",
    "endTime": "2022-01-20 14:18:07",
    "extraFields":"",
    "format":0
}

Return Sample


See return samples of Get method: Return Samples>>

SDK Sample


You can access the SDK samples for metric management service on GitHub: