跳至主要內容

查询设备事件数据

eview大约 2 分钟loctube-api

查询设备事件数据

接口地址:/api/v1/device/{deviceId}/event/{eventId}/_query
请求方式:POST
请求数据类型:application/json
响应数据类型:*/*
接口描述:

根据物模型的不同,返回对应的字段,如果物模型定义为Object类型,则对应属性,否则value字段则为事件数据.

请求示例

{
  "terms": [
    {
      "column": "",
      "value": {},
      "type": "",
      "termType": "",
      "options": [],
      "terms": [
        {
          "column": "",
          "value": {},
          "type": "",
          "termType": "",
          "options": [],
          "terms": [
            {}
          ]
        }
      ]
    }
  ],
  "includes": [],
  "excludes": [],
  "paging": true,
  "firstPageIndex": 0,
  "pageIndex": 0,
  "pageSize": 0,
  "sorts": [
    {
      "name": "",
      "order": "",
      "value": {}
    }
  ],
  "context": {},
  "where": "",
  "orderBy": "",
  "total": 0,
  "parallelPager": true
}

请求参数:

参数名称参数说明请求类型是否必须数据类型schema
deviceIdpathtruestring
eventIdpathtruestring
queryParamEntityQueryParamEntitybodytrueQueryParamEntityQueryParamEntity
termsfalsearrayTerm
column字段名falsestring
value条件值falseobject
type多个条件关联类型,可用值:or,andfalsestring
termType动态条件类型falsestring
options拓展选项falsearraystring
terms嵌套条件falsearrayTerm
includes指定要查询的列falsearraystring
excludes指定不查询的列falsearraystring
paging是否分页falseboolean
firstPageIndex第一页索引falseinteger(int32)
pageIndex页码falseinteger(int32)
pageSize每页数量falseinteger(int32)
sortsfalsearraySort
name字段名falsestring
order排序方式,可用值:asc,descfalsestring
value指定值排序falseobject
context上下文信息falseobject
wherewhere条件表达式,与terms参数不能共存.语法: name = 张三 and age > 16falsestring
orderByorderBy条件表达式,与sorts参数不能共存.语法: age asc,createTime descfalsestring
total设置了此值后将不重复执行count查询总数falseinteger(int32)
parallelPager是否进行并行分页falseboolean

响应状态码-200:
响应参数:

参数名称参数说明类型schema
message消息提示string
resultPagerResultDeviceEventPagerResultDeviceEvent
pageIndex页码integer(int32)
pageSize每页数据量integer(int32)
total数据总量integer(int32)
data数据列表arrayDeviceEvent
timestampinteger
status状态码integer(int32)integer(int32)
code业务码string
timestamp时间戳(毫秒)integer(int64)integer(int64)

响应示例:

{
	"message": "",
	"result": {
		"pageIndex": 0,
		"pageSize": 0,
		"total": 0,
		"data": [
			{
				"timestamp": 0
			}
		]
	},
	"status": 0,
	"code": "",
	"timestamp": 0
}