执行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": "" }]}}