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