文档首页/ 华为云SparkPack解决方案/ 最佳实践/ 华为云成长型企业数字化转型包企业ERP条码集成指南/ 华为云成长型企业数字化转型包(B1)和条码集成/ 依赖接口清单描述/ diapi接口/ 执行sql接口
更新时间：2023-11-02 GMT+08:00
查看PDF
分享

执行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接口

相关文档