Get Asset AI Raw Data¶

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

Request Format¶

POST https://{apigw-address}/tsdb-service/v2.1/ai

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

Request Parameters (Body)¶

Name	Required/Optional	Data Type	Description
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 >>
pointIds	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 sample data can be specified in either the device’s local time or in UTC time. The format for the device’s local time is `YYYY-MM-DD HH:MM:SS`. When using the local time format, the query will be performed using the local time of the device’s location. The UTC time format is `2019-06-01T00:00:00+08:00`, where `+08:00` represents the time zone. When using the UTC time format, the query will be performed across all assets using the same unified start and end times.
endTime	Required	String	The end time of the sampling data. Its format must be consistent with `startTime`.
pageSize	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.
withQuality	Optional	Boolean	true = the quality indicator is included in the response false = the quality indicator is not included in the response
localTimeAccuracy	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`.
localTimeFormat	Optional	Integer	Specify whether the local time value includes time zone information of devices. `0` (default): without time zone information; `1`: with time zone information.
itemFormat	Optional	Integer	Specify the displaying format of the returned device data. Available options are `0`, `1`, and `2`. For the example of each displaying format, see Item Format Example>>
boundaryType	Optional	String	Specify the type/scope of data to be queried if data is stored after compression. Available options are: + `inside`: query compressed raw data only, default. + `outside`: query compressed raw data and data records before the specified start time and after the end time. + `interpolated`: query compressed raw data and interpolated data records at the specified start time and end time. + `sample`: return interpolated data records by specified time interval and algorithm within the specified start time and end time. The interpolated data can be used for making data in TSDB complete based on business needs.
interval	Optional	Integer	For `boundaryType=sample`, specify the time interval for generating the interpolated data records. The default value is 60, in seconds.
interpolation	Optional	String	For `boundaryType=sample`, specify the algorithm for generating the interpolated data records. Available options are: `linear` (linear interpolation, default), `previous` (previous value interpolation), `near` (near value interpolation), `after` (next value interpolation). For detailed information about the algorithm, see Data Interpolation Algorithm>>

Response Parameters¶

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

items¶

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).

Sample 1¶

Request Sample¶

Local time format:

url: https://{apigw-address}/tsdb-service/v2.1/ai?orgId=yourOrgId

method: POST

Content-Type: application/json

requestBody:
{
  "assetIds": "yourAssetIds",
  "pointIds": "yourPointIds",
  "startTime": "2020-04-20 00:00:00",
  "endTime": "2020-04-21 00:00:000",
  "pageSize": 10,
  "localTimeAccuracy": true,
  "localTimeFormat": 1,
  "itemFormat": 0,
  "withQuality": false
}

Return Sample¶

{
  "code": 0,
  "msg": "OK",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1587312000000,
        "yourPointId": 1.1236,
        "localtime": "2020-04-20T00:00:00+08:00"
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1587312003000,
        "yourPointId": 1.1236,
        "localtime": "2020-04-20T00:00:03+08:00"
      }
    ]
  }
}

Sample 2¶

Request Sample¶

UTC time format:

url: https://{apigw-address}/tsdb-service/v2.1/ai?orgId=yourOrgId

method: POST

Content-Type: application/json

requestBody:
{
  "assetIds": "yourAssetIds",
  "pointIds": "yourPointIds",
  "startTime": "2020-04-20T00:00:00+08:00",
  "endTime": "2020-04-21T00:00:00+08:00",
  "pageSize": 10,
  "localTimeAccuracy": true,
  "localTimeFormat": 0,
  "itemFormat": 0,
  "withQuality": false
}

Return Sample¶

{
  "code": 0,
  "msg": "OK",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1587312000000,
        "yourPointId": 1.1236,
        "localtime": "2020-04-20 00:00:00"
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1587312003000,
        "yourPointId": 1.1236,
        "localtime": "2020-04-20 00:00:03"
      }
    ]
  }
}

Sample 3¶

Request Sample¶

Request with quality indicator:

url: https://{apigw-address}/tsdb-service/v2.1/ai?orgId=yourOrgId

method: POST

Content-Type: application/json

requestBody:
{
  "assetIds": "yourAssetIds",
  "pointIds": "yourPointIds",
  "startTime": "2020-04-20T00:00:00+08:00",
  "endTime": "2020-04-21T00:00:00+08:00",
  "pageSize": 10,
  "localTimeAccuracy": true,
  "localTimeFormat": 0,
  "itemFormat": 0,
  "withQuality": true
}

Return Sample¶

{
  "code": 0,
  "msg": "OK",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "Ps4PViva",
        "timestamp": 1587312000000,
        "ai_point": 1.1236,
        "localtime": "2020-04-20 00:00:00",
        "quality": 0
      },
      {
        "assetId": "Ps4PViva",
        "timestamp": 1587312003000,
        "ai_point": 1.1236,
        "localtime": "2020-04-20 00:00:03",
        "quality": 0
      }
    ]
  }
}

Sample 4¶

Request Sample¶

Query compressed raw data and data records before the specified start time and after the specified end time.

url: https://{apigw-address}/tsdb-service/v2.1/ai?orgId=yourOrgId

method: POST

Content-Type: application/json

requestBody:
{
  "assetIds": "yourAssetIds",
  "pointIds": "yourPointIds",
  "startTime": "2020-08-28T11:33:00+08:00",
  "endTime": "2020-08-28T11:35:00+08:00",
  "boundaryType", "outside"
}

Return Sample¶

{
  "code": 0,
  "msg": "OK",
  "submsg": null,
  "data": {
    "items": [
      {
        "assetId": "yourAssetId",
        "timestamp": 1598585576906,
        "yourPointId": 0.8807087,
        "localtime": "2020-08-28 11:32:56"
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1598585587039,
        "yourPointId": 0.26798052,
        "localtime": "2020-08-28 11:33:07"
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1598585597125,
        "yourPointId": 0.65514636,
        "localtime": "2020-08-28 11:33:17"
      },
      {
        "assetId": "yourAssetId",
        "timestamp": 1598585708013,
        "yourPointId": 0.342161,
        "localtime": "2020-08-28 11:35:08"
      }
    ]
  }
}

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.