华为云SPARKPACK解决方案-执行sql接口

时间：2023-11-02 20:19:58

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