Get Asset Generic Data¶

Get the generic data of specified measurement points of specified devices within a certain period.

Using GET Method¶

Request Format¶

GET https://{apigw-address}/tsdb-service/v2.0/generic

Request Parameters (URI)¶

Name	Location (Path/Query)	Required/Optional	Data Type	Description
orgId	Query	Required	String	The organization ID which the asset belongs to. How to get organization ID >>
modelId	Query	Optional	String	The model ID. How to get model ID >>
assetIds	Query	Required	String	The asset ID. Supports the query of multiple asset IDs, separated by commas. How to get asset ID >>
measurepoints	Query	Required	String	The measurement point ID. Supports the query of multiple measurement point IDs, separated by commas. How to get measurement point ID >>
startTime	Query	Required	String	The start time of the sampling data, where both UTC and local time formats are supported. For UTC time format, the application will query all the asset data by the unified start timestamp and end timestamp. Timezone information is required for the UTC time format: 2019-06-01T00:00:00+08:00. For local time format, the application will query the asset data by the local time of where the device is located. Its format is: YYYY-MM-DD HH:MM:SS.
endTime	Query	Required	String	The end time of the sampling data. Its format must be consistent with `startTime`.
pageSize	Query	Optional	Integer	The upper limit of the returned records in a single page for a single measurement point of a single device, which is 1,000 by default.
accessKey	Query	Optional	String	The service account for authentication purposes. How to get the accessKey>>
withQuality	Query	Optional	Boolean	true = the quality indicator is included in the response false = default, the quality indicator is not included in the response
localTimeAccuracy	Query	Optional	Boolean	Specify whether the local time in the returned data should be in millisecond format. Only effective when `ifWithLocalTime=true`. `true` indicates that the local time should be returned in millisecond format, `false` indicates that millisecond format is not required, and the default value is `false`.

Response Parameters ¶

Name	Data Type	Description
data	List<JSONObject>	The list of asset data. The data returned for a single point of a single device is sorted by the data time stamp in ascending order. For more information, see items

items¶

Sample¶

{
        "assetId": "yourAssetId",
        "timestamp": 1560249312446,
        "localtime": "6/11/2019 6:35:12 PM",
        "yourPointId": 1.1236,
        "quality": 0
}

Parameters¶

Name	Data Type	Description
assetId	String	The asset ID.
timestamp	Long	The data timestamp (UNIX time, accurate to the second).
pointId	Double	This parameter is a variable, where the parameter name in the returned structure represents the identifier of the measurement point, and the parameter value represents the data for that measurement point. The returned data for the same measurement point of the same device will be sorted in ascending order by time.
localtime	String	The data timestamp in local time format (accurate to the second). If UTC time format is used when specifying the `statTime` and `endtime`, this value will be null.
quality	Integer	The quality indicator of the measurement point data.

#

Sample 1 (GET Method)¶

Request Sample¶

Local time format:

url: https://{apigw-address}/tsdb-service/v2.0/generic?orgId=yourOrgId&modelId=&assetIds=yourAssetIds&measurepoints=yourPointIds&startTime=2019-06-01%2010:18:00&endTime=2019-06-11%2018:37:00&pageSize=&accessKey=accessKeyOfYourAPP

method: GET

Return Sample¶

{
  "status": 0,
  "requestId": null,
  "msg": "success",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249312446,
        "localtime": "2019-06-11 18:35:12",
        "yourPointId": 3.123
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249332446,
        "localtime": "2019-06-11 6:35:32 PM",
        "yourPointId": 3.123
      }
    ]
  }
}

Sample 2 (GET Method)¶

Request Sample¶

UTC time format:

url: https://{apigw-address}/tsdb-service/v2.0/generic?assetIds=yourAssetIds&measurepoints=yourPointIds&startTime=2019-06-01T00:00:00%2B08:00&endTime=2019-06-11T23:00:00%2B08:00&pageSize=100&accessKey=accessKeyOfYourAPP&orgId=yourOrgId

method: GET

Return Sample¶

{
    "status": 0,
    "requestId": null,
    "msg": "success",
    "submsg": null,
    "data": {
        "data": [
            {
                "localtime": null,
                "assetId": "yourAssetId",
                "yourPointId": 3.123,
                "timestamp": 1560249312446
            },
            {
                "localtime": null,
                "assetId": "yourAssetId",
                "yourPointId": 3.123,
                "timestamp": 1560249332446
            }
        ]
    }
}

Sample 3 (GET Method)¶

Request Sample¶

Request with quality indicator:

url: https://{apigw-address}/tsdb-service/v2.0/ai?orgId=yourOrgId&modelId=&assetIds=yourAssetIds&measurepoints=yourPointIds&startTime=2019-06-01%2010:00:00&endTime=2019-06-11%2023:00:00&pageSize=&accessKey=accessKeyOfYourAPP&withQuality=true

method: GET

Return Sample¶

{
  "status": 0,
  "requestId": null,
  "msg": "success",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249312446,
        "yourPointId": 1.1236,
        "localtime": "2019-06-11 18:35:12",
        "quality": 0
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249332446,
        "yourPointId": 1.1236,
        "localtime": "2019-06-11 18:35:32",
        "quality": 0
      }
    ]
  }
}

Using POST Method¶

Request Format¶

POST https://{apigw-address}/tsdb-service/v2.0/generic

Request Parameters (Body)¶

Name	Required/Optional	Data Type	Description
orgId	Required	String	The organization ID which the asset belongs to. How to get organization ID >>
modelId	Optional	String	The model ID. How to get model ID >>
assetIds	Required	String	The asset ID. Supports the query of multiple asset IDs, separated by commas. How to get asset ID >>
measurepoints	Required	String	The measurement point ID. Supports the query of multiple measurement point IDs, separated by commas. How to get measurement point ID >>
startTime	Required	String	The start time of the sampling data, where both UTC and local time formats are supported. For UTC time format, the application will query all the asset data by the unified start timestamp and end timestamp. Timezone information is required for the UTC time format: 2019-06-01T00:00:00+08:00. For local time format, the application will query the asset data by the local time of where the device is located. Its format is: YYYY-MM-DD HH:MM:SS.
endTime	Required	String	The end time of the sampling data. Its format must be consistent with `startTime`.
pageSize	Optional	String	The upper limit of the returned records in a single page for a single measurement point of a single device, which is 1,000 by default.
accessKey	Optional	String	The service account for authentication purposes. How to get the accessKey>>
withQuality	Optional	String	true = the quality indicator is included in the response false = the quality indicator is not included in the response
localTimeAccuracy	Optional	String	Specify whether the local time in the returned data should be in millisecond format. Only effective when `ifWithLocalTime=true`. `true` indicates that the local time should be returned in millisecond format, `false` indicates that millisecond format is not required, and the default value is `false`.

Response Parameters¶

See description in Response Parameters of the Using GET Method section.

#

Sample 1 (POST Method)¶

Request Sample¶

Local time format:

url: https://{apigw-address}/tsdb-service/v2.0/generic

method: POST

Content-Type: multipart/form-data;charset=UTF-8

requestBody:
{
  "orgId": "yourOrgId",
  "assetIds": "yourAssetIds",
  "measurepoints": "yourPointIds",
  "startTime": "2020-04-20 00:00:00",
  "endTime": "2020-04-21 00:00:00",
  "pageSize": 1000,
  "accessKey": "accessKey of your APP"
}

Return Sample¶

{
  "status": 0,
  "requestId": null,
  "msg": "success",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249312446,
        "localtime": "2019-06-11 18:35:12",
        "yourPointId": 3.123
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249332446,
        "localtime": "2019-06-11 6:35:32 PM",
        "yourPointId": 3.123
      }
    ]
  }
}

Sample 2 (POST Method)¶

Request Sample¶

UTC time format:

url: https://{apigw-address}/tsdb-service/v2.0/generic

method: POST

Content-Type: multipart/form-data;charset=UTF-8

requestBody:
{
  "orgId": "yourOrgId",
  "assetIds": "yourAssetIds",
  "measurepoints": "yourPointIds",
  "startTime": "2019-06-01T00:00:00%2B08:00",
  "endTime": "2019-06-11T23:00:00%2B08:00",
  "pageSize": 1000,
  "accessKey": "accessKey of your APP"
}

Return Sample¶

{
    "status": 0,
    "requestId": null,
    "msg": "success",
    "submsg": null,
    "data": {
        "data": [
            {
                "localtime": null,
                "assetId": "yourAssetId",
                "yourPointId": 3.123,
                "timestamp": 1560249312446
            },
            {
                "localtime": null,
                "assetId": "yourAssetId",
                "yourPointId": 3.123,
                "timestamp": 1560249332446
            }
        ]
    }
}

Sample 3 (POST Method)¶

Request Sample¶

Request with quality indicator:

url: https://{apigw-address}/tsdb-service/v2.0/generic

method: POST

Content-Type: multipart/form-data;charset=UTF-8

requestBody:
{
  "orgId": "yourOrgId",
  "assetIds": "yourAssetIds",
  "measurepoints": "yourPointIds",
  "startTime": "2019-06-01 00:00:00",
  "endTime": "2019-06-11 23:00:00",
  "pageSize": 1000,
  "accessKey": "accessKey of your APP",
  "withQuality": true
}

Return Sample¶

{
  "status": 0,
  "requestId": null,
  "msg": "success",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249312446,
        "yourPointId": 1.1236,
        "localtime": "2019-06-11 18:35:12",
        "quality": 0
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1560249332446,
        "yourPointId": 1.1236,
        "localtime": "2019-06-11 18:35:32",
        "quality": 0
      }
    ]
  }
}

SDK Samples¶

You can access the `Java SDK Samples<https://github.com/EnvisionIot/sample-code-java/tree/EnOS2.4/tsdbdata>`__for TSDB data service on Github.