更新时间：2023-11-02 GMT+08:00
执行sql接口
|
接口地址 |
https://api-service.sperp.myhuaweicloud.com/diapi/XXXX/b1dis/v1/exec-sql |
|
接口功能描述 |
执行sql，查询B1数据 |
|
请求方式 |
POST |
请求体参数:
|
参数名称 |
参数描述 |
参数类型 |
|
Sql |
需要执行的sql |
字符串 |
响应体参数：
|
参数名称 |
参数描述 |
参数类型 |
|
code |
响应编码 |
字符串 |
|
message |
响应信息 |
字符串 |
|
data |
响应数据 |
对象 |
请求样例：
{
"Sql": "Select \"ItemCode\",\"ItemName\",\"CstGrpCode\",\"FrgnName\",\"BuyUnitMsr\",\"CardCode\",TO_VARCHAR (TO_DATE(\"UpdateDate\"), 'YYYY-MM-DD') UpdateDate,TO_VARCHAR (TO_DATE(\"CreateDate\"), 'YYYY-MM-DD') CreateDate,\"InvntryUom\",\"U_SFJY\",\"U_CX\",\"U_CC\" from OITM WHERE ifnull(\"U_SYN\",'N')='N' "
}
响应体样例：
{
"code": "RIS.10000000",
"message": "OK",
"data": {
"value": [
{
"ItemCode": "XN0004",
"ItemName": "XN0004",
"CstGrpCode": -1,
"FrgnName": "",
"BuyUnitMsr": "",
"CardCode": "",
"UPDATEDATE": "2023-10-20",
"CREATEDATE": "2023-10-20",
"InvntryUom": "",
"U_SFJY": "",
"U_CX": "",
"U_CC": ""
},
{
"ItemCode": "XN0001",
"ItemName": "XN0001",
"CstGrpCode": -1,
"FrgnName": "",
"BuyUnitMsr": "",
"CardCode": "",
"UPDATEDATE": "2023-10-20",
"CREATEDATE": "2023-10-20",
"InvntryUom": "",
"U_SFJY": "",
"U_CX": "",
"U_CC": ""
}]}}
父主题： diapi接口
