数据源-分页数据

请求参数

Authorization

在 header 添加参数

示例：

X-Token: ********************

Query 参数

fields

string

可选

选择需要返回的字段，多个字段采用CSV表示方式。默认：null，表示返回支持的所有字段,支持选择的字段有： name,url,username,dbType,createdDatetime,modifiedDatetime

filters

string

可选

条件过滤，对选择的字段fields进行条件判断，支持>、<、=、!=，多个条件之间用","分隔表示逻辑"与"，暂不支持逻辑"或"（因为可能存在歧义）

sorts

string

可选

根据选择的字段fields中某些字段进行排序。书写数据："+/-字段名称"，"+"表示升序，"-"表示降序，多个排序字段之间","分隔。支持排序字段： createdDatetime

offset

string

可选

分页时起始偏移量。默认值：0，取值>=0

limit

string

可选

分页时每页返回的最大数据量。默认值：20，取值范围：0<=limit<=100

Header 参数

X-Requested-Session

string

必需

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

code

string

必需

message

string

必需

data

object

必需

rows

array [object {14}]

必需

page

object

必需

示例

{
    "code": "100100000",
    "message": "操作成功",
    "data": {
        "rows": [
            {
                "wsid": "WSID_CDSO_000001952623cb1e00ff14e774256856",
                "systemWsid": "WSID_CSYS_00000186a6984e6b00ff14e774256eb7",
                "name": "技科八议族他",
                "url": "10.10.1.47:3306",
                "dbName": "qhy_db",
                "username": "eSignServerSql",
                "password": "@~mysql@signit@iskey!",
                "dbType": "MYSQL",
                "jdbcUrlParams": "autoReconnect=true&failOverReadOnly=false&useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai&useSSL=false&allowPublicKeyRetrieval=true",
                "timeout": 0,
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1740101637000,
                "modifiedDatetime": 1740101704000
            },
            {
                "wsid": "WSID_CDSO_0000018e086ff852c2c5f2fac55d60f1",
                "systemWsid": "",
                "name": "电子病历系统数据库",
                "url": "10.10.1.47:3306",
                "dbName": "emr_test",
                "username": "eSignServerSql",
                "password": "@~mysql@signit@iskey!",
                "dbType": "MYSQL",
                "jdbcUrlParams": "",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1709538540000,
                "modifiedDatetime": 1735618019000
            },
            {
                "wsid": "WSID_CDSO_0000018bb35557bcf64b34686cde60bf",
                "systemWsid": "",
                "name": "测试11091",
                "url": "10.10.1.47:3306",
                "dbName": "qhy_db",
                "username": "eSignServerSql",
                "password": "@~mysql@signit@iskey!",
                "dbType": "MYSQL",
                "jdbcUrlParams": "124",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1699520762000,
                "modifiedDatetime": 1701849577000
            },
            {
                "wsid": "WSID_CDSO_00000189291ef94cf64b34686cde2130",
                "systemWsid": "",
                "name": "ce11",
                "url": "10.10.1.26:1433",
                "dbName": "my_data",
                "username": "sa",
                "password": "@Server@Sql!",
                "dbType": "SQL_SERVER",
                "jdbcUrlParams": "11",
                "timeout": 110,
                "status": 0,
                "statusEnumName": "DISABLE",
                "createdDatetime": 1688612029000,
                "modifiedDatetime": 1697791915000
            },
            {
                "wsid": "WSID_CDSO_00000188710ae48e00ff14e774254077",
                "systemWsid": "",
                "name": "嘉禾数据源",
                "url": "172.21.1.111:15111",
                "dbName": "jhemr",
                "username": "jhemr",
                "password": "jhemr",
                "dbType": "ORACLE",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1685523690000
            },
            {
                "wsid": "WSID_CDSO_0000018730df010500ff14e774257203",
                "systemWsid": "",
                "name": "测试tt",
                "url": "10.10.1.26:1433",
                "dbName": "my_data",
                "username": "sa",
                "password": "@Server@Sql!",
                "dbType": "SQL_SERVER",
                "jdbcUrlParams": "11",
                "timeout": 100,
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1680152135000,
                "modifiedDatetime": 1688611532000
            },
            {
                "wsid": "WSID_CDSO_00000186bab10d3e7e04ecdc029172e8",
                "systemWsid": "",
                "name": "sqlserver0307",
                "url": "10.10.1.26:1433",
                "dbName": "my_data",
                "username": "sa",
                "password": "@Server@Sql!",
                "dbType": "SQL_SERVER",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1678169405000
            },
            {
                "wsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "systemWsid": "",
                "name": "mysql0307",
                "url": "10.10.1.47:3306",
                "dbName": "qhy_db",
                "username": "eSignServerSql",
                "password": "@~mysql@signit@iskey!",
                "dbType": "MYSQL",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1678169291000,
                "modifiedDatetime": 1678169414000
            },
            {
                "wsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "systemWsid": "",
                "name": "测试47数据库",
                "url": "10.10.1.47",
                "dbName": "qhy_db",
                "username": "eSignServerSql",
                "password": "@~mysql@signit@iskey!",
                "dbType": "MYSQL",
                "status": 1,
                "statusEnumName": "ENABLE",
                "createdDatetime": 1677832347000
            }
        ],
        "page": {
            "size": 20,
            "totalElements": 9,
            "totalPages": 0,
            "number": 0
        }
    }
}