数据库列表接口

POST

/api/database/manage/list

请求参数

Body 参数application/json

示例

{
    "name": "string",
    "keyWord": {
        "type": "{value: CONTAIN, desc: 包含}",
        "relation": "{value: OR, desc: 或}",
        "words": [
            "string"
        ],
        "field": "string"
    },
    "deviceId": 0,
    "deviceIdList": [
        0
    ],
    "typeIdList": [
        "string"
    ],
    "categoryList": [
        "string"
    ],
    "companyIdList": [
        "string"
    ],
    "versionIdList": [
        "string"
    ],
    "managementIdList": [
        "string"
    ],
    "districtIdList": [
        "string"
    ],
    "areaList": [
        "string"
    ],
    "securityAreaList": [
        0
    ],
    "firmwareVersion": "string",
    "ip": "string",
    "ipv6": "string",
    "plane": 0,
    "sys": "string",
    "originalSystem": "string",
    "stationName": "string",
    "stationIdList": [
        0
    ],
    "stationTypeList": [
        "string"
    ],
    "stationVoltageList": [
        "string"
    ],
    "label": "string",
    "lvl": 0,
    "master": "string",
    "servicer": "string",
    "setupTimeType": "THIS_HOUR",
    "setupTimeStart": "string",
    "setupTimeEnd": "string",
    "colIdList": [
        "string"
    ],
    "isCollected": 0,
    "pingStatus": 0,
    "isPwd": true,
    "orderRules": [
        {
            "order": "stationId",
            "orderAsc": true
        }
    ],
    "columnsCH": [
        "string"
    ],
    "columns": [
        "string"
    ],
    "groupIdList": [
        0
    ],
    "pageNum": -1,
    "pageSize": -1,
    "port": "string",
    "databaseStatus": 0,
    "driverName": "string"
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST '/api/database/manage/list' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name": "string",
    "keyWord": {
        "type": "{value: CONTAIN, desc: 包含}",
        "relation": "{value: OR, desc: 或}",
        "words": [
            "string"
        ],
        "field": "string"
    },
    "deviceId": 0,
    "deviceIdList": [
        0
    ],
    "typeIdList": [
        "string"
    ],
    "categoryList": [
        "string"
    ],
    "companyIdList": [
        "string"
    ],
    "versionIdList": [
        "string"
    ],
    "managementIdList": [
        "string"
    ],
    "districtIdList": [
        "string"
    ],
    "areaList": [
        "string"
    ],
    "securityAreaList": [
        0
    ],
    "firmwareVersion": "string",
    "ip": "string",
    "ipv6": "string",
    "plane": 0,
    "sys": "string",
    "originalSystem": "string",
    "stationName": "string",
    "stationIdList": [
        0
    ],
    "stationTypeList": [
        "string"
    ],
    "stationVoltageList": [
        "string"
    ],
    "label": "string",
    "lvl": 0,
    "master": "string",
    "servicer": "string",
    "setupTimeType": "THIS_HOUR",
    "setupTimeStart": "string",
    "setupTimeEnd": "string",
    "colIdList": [
        "string"
    ],
    "isCollected": 0,
    "pingStatus": 0,
    "isPwd": true,
    "orderRules": [
        {
            "order": "stationId",
            "orderAsc": true
        }
    ],
    "columnsCH": [
        "string"
    ],
    "columns": [
        "string"
    ],
    "groupIdList": [
        0
    ],
    "pageNum": -1,
    "pageSize": -1,
    "port": "string",
    "databaseStatus": 0,
    "driverName": "string"
}'

返回响应

🟢200成功

application/json

Body

示例

{
  "code": 0,
  "data": [
    {
      "deviceId": 0,
      "name": "",
      "label": "",
      "area": "",
      "sys": "",
      "master": "",
      "ip": "",
      "iplist": "",
      "ipv6": "",
      "ipNum": 0,
      "remark": "",
      "servicer": "",
      "plane": 0,
      "role": 0,
      "securityArea": 0,
      "lvl": 0,
      "stationId": 0,
      "cpuNumber": 0,
      "startU": 0,
      "installLocation": "",
      "operatingStatus": "",
      "dispatchManagement": "",
      "setupTime": "",
      "wgName": "",
      "wgIp": "",
      "districtId": "",
      "managementId": "",
      "companyId": "",
      "versionId": "",
      "typeId": "",
      "routerType": 0,
      "category": "",
      "versionFlag": 0,
      "versionChange": 0,
      "originalId": "",
      "originalSystem": "",
      "descr": "",
      "osname": "",
      "uptime": "",
      "uptimeSec": 0,
      "mac": "",
      "firmwareVersion": "",
      "serialNo": "",
      "collectedtime": "",
      "versionCompliance": "",
      "sysoid": "",
      "stackNum": 0,
      "createTime": "",
      "updateTime": "",
      "deleteFlag": 0,
      "companyName": "",
      "versionName": "",
      "typeName": "",
      "managementName": "",
      "districtName": "",
      "operation": [
        ""
      ],
      "databaseStatus": 0,
      "driverName": "",
      "odbcVersion": "",
      "port": "",
      "currentConnections": 0,
      "maxConnections": 0,
      "collectedTime": ""
    }
  ],
  "message": "",
  "count": 0,
  "currentPage": 0,
  "totalPages": 0
}

修改于 2025-07-01 17:23:02

传输设备列表导出

数据库删除接口