数据库列表导出

POST

/api/database/manage/export

请求参数

Body 参数application/json

name

string

可选

keyWord

object (KeyWord)

可选

设备名称, 多个关键字

type

enum<string>

可选

关键字操作默认为 CONTAIN

枚举值:

CONTAINNOT_CONTAINSTART_WITHEND_WITHBELONGNOT_BELONGNULL

默认值:

{value: CONTAIN, desc: 包含}

relation

enum<string>

可选

关键字关系默认为 OR

枚举值:

ANDOR

默认值:

{value: OR, desc: 或}

words

array[string]

关键字

可选

field

string

筛选字段名

可选

deviceId

integer <int64>

设备id

可选

deviceIdList

array[integer]

可选

typeIdList

array[string]

设备类型

可选

categoryList

array[string]

设备分类

可选

companyIdList

array[string]

公司

可选

versionIdList

array[string]

版本号

可选

managementIdList

array[string]

责任单位

可选

districtIdList

array[string]

区域

可选

areaList

array[string]

网络管理域

可选

securityAreaList

array[integer]

安全管理区

可选

firmwareVersion

string

软件版本

可选

string

采集地址

可选

ipv6

string

采集地址

可选

plane

integer

平面

可选

sys

string

业务系统

可选

originalSystem

string

来源系统

可选

stationName

string

厂站id

可选

stationIdList

array[integer]

可选

stationTypeList

array[string]

厂站类型

可选

stationVoltageList

array[string]

厂站电压等级

可选

label

string

设备标签

可选

lvl

integer

设备层级

可选

master

string

管理员

可选

servicer

string

运维厂商

可选

setupTimeType

enum<string>

投运时间

可选

枚举值:

THIS_HOURTODAYTHIS_WEEKTHIS_MONTHTHIS_QUARTERTHIS_YEARLAST_HOURLAST_DAYLAST_WEEKLAST_MONTHLAST_QUARTERLAST_YEARNEAR_15_MINUTENEAR_HOURNEAR_6_HOURNEAR_DAYNEAR_WEEKNEAR_MONTHNEAR_QUARTERNEAR_THREE_MONTHNEAR_YEARYEARMONTHDAYHOURMINUTECUSTOM

setupTimeStart

string

投运时间起始

可选

setupTimeEnd

string

投运时间结束

可选

colIdList

array[string]

采集器筛选

可选

isCollected

integer

可选

采集状态 -1未配置 0失败 1成功

pingStatus

integer

可选

ping状态 -1未配置 0失败 1成功

isPwd

boolean

是否有密码权限

可选

orderRules

array[object (DeviceStatusVoOrderRuleVo) {2}]

排序规则

可选

order

enum<string>

排序字段

可选

枚举值:

stationIdvoltagestationTypetypeIdcompanyIdversionIddistrictIdmanagementIddeviceIdnameisPwdpingStatusisCollectedipipv6setupTimeuptimeareamastersecurityArea

orderAsc

boolean

正序/逆序

可选

columnsCH

array[string]

可选

导出头部列名称排序,查询不需要传此字段

columns

array[string]

可选

导出头部列字段排序,查询不需要传此字段

groupIdList

array[integer]

可选

pageNum

integer

可选

默认值:

-1

pageSize

integer

可选

默认值:

-1

port

string

数据库端口

可选

databaseStatus

integer

可选

数据库状态 0失败 1成功

driverName

string

数据库驱动

可选

示例

{
    "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/export' \
--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

integer

响应码

可选

data

array[integer]

返回数据

可选

message

string

反馈信息

可选

默认值:

SUCCESS.getDesc()

count

integer

总条数

可选

currentPage

integer

当前页

可选

totalPages

integer

总页数

可选

示例

{
  "code": 0,
  "data": [
    0
  ],
  "message": "",
  "count": 0,
  "currentPage": 0,
  "totalPages": 0
}

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

批量修改数据库进度接口

数据库面板实时数据查询