自定义sql查询数据
开发中
POST
/openApi/datapool/select
责任人：未设置
请求参数
Body 参数application/json
entId
string
必需
excuteSql
string
必需
sqlArgs
array[string]
必需
示例
{
"entId": "kaahuanjing",
"excuteSql": "SELECT xingming FROM ent_kaahuanjing_datapool_xingming",
"sqlArgs": [
"1"
]
}返回响应
🟢200成功
application/json
Body
status
integer
必需
code
integer
必需
result
array [object {13}]
必需
id
string
可选
title
string
可选
type
string
可选
belongs
string
可选
index
integer
可选
creator
string
可选
modifier
string
可选
created_time
string
可选
last_modified
string
可选
basic
boolean
可选
required
boolean
可选
report
boolean
可选
disable
boolean
可选
msg
string
必需
示例
{
"status": 200,
"code": 1000000,
"result": [
{
"id": "FuJian",
"title": "附件",
"type": "attach",
"belongs": "CaiGouShenPiBiao",
"index": 10,
"creator": "ApiTest",
"modifier": "ApiTest",
"created_time": "2016-08-24 08:35:42",
"last_modified": "2016-08-24 08:35:42",
"basic": false,
"required": false,
"report": false,
"disable": false
}
],
"msg": "成功"
}修改于 2023-04-27 01:09:50