【预计可发量查询报表接口说明及示例】

一、接口说明：(平台公共报表查询接口)

1.接口名称：GetSysReportData

   接口组件：Kingdee.BOS.WebApi.ServicesStub.dll

   接口类名：Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.cs

2.接口调用全称：

  SDK调用：Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.GetSysReportData

  HTTP调用：http://服务器地址/k3cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.GetSysReportData.common.kdsvc

【参数说明】

一、请求参数说明： 

1.formid：业务对象表单Id，字符串类型（必录） 2.data：JSON格式数据（详情参考JSON格式数据）（必录）     

2.1.FieldKeys：需查询的字段key集合，字符串类型，格式："key1,key2,..."（必录）

    注（简单账表可能存在动态字段，指定待查字段时，须确保当前查询条件的结果集中包含待查字段）    

2.2.SchemeId：过滤方案内码，字符串类型     

2.3.StartRow：开始行索引，整型（非必录）     

2.4.Limit：最大行数，整型，不能超过10000（非必录）    

2.5.IsVerifyBaseDataField：是否验证所有的基础资料有效性，布尔类，默认true（非必录）     

2.6.FilterString：过滤条件，数组类型，

如：[{"Left":"(","FieldName":"Field1","Compare":"67","Value":"111","Right":")","Logic":"0"},

      {"Left":"(","FieldName":"Field2","Compare":"67","Value":"222","Right":")","Logic":"0"}]     

2.7.Model：表单数据包，JSON类型（必录）

 二、返回结果：

 {"Result": {"IsSuccess": true,"RowCount": 0,"Rows": [ ] }}

【测试示例】

1. WebAPI在线测试验证：

2. PostMan测试验证：

JSON参数格式样例：

{
    "parameters":["SAL_ExpectQtyQueryReport",
           {
                "FieldKeys": "FMasterId,FMaterialName,FStockId,FAWAITOUTQTY,FAVBQTY",
                "SchemeId": "",
                "StartRow": 0,
                "Limit": 2000,
                "IsVerifyBaseDataField": "true",
                "FilterString": [],
                "Model": {
                    "FCheckAuxPropId": "false",
                    "FCheckBomId": "false",
                    "FCheckMtoNo": "false",
                    "FCheckStockId": "true",
                    "FCheckStockLocId": "false",
                    "FCheckLot": "false",
                    "FCheckProduceDate": "false",
                    "FCheckExpiryDate": "false",
                    "FCheckStockStatusId": "false",
                    "FCheckOwnerTypeId": "false",
                    "FCheckKeeperTypeId": "false",
                    "FCheckOwnerId": "false",
                    "FCheckKeeperId": "false",
                    "FMulMaterialIds": [
                        {
                            "FNumber": "KFL1114"
                        },
                        {
                            "FNumber": "KFLLoc"
                        }
                    ],
                    "FMulStockIds": [
                        {
                            "FNumber": ""
                        }
                    ],
                    "FStockOrgIds": [
                        {
                            "FNumber": "100"
                        }
                    ]
                }
            }
    ]

【延伸阅读】

星空 - 《预计可发量》 精华内容合辑

WebAPI接口之【预计可发量查询接口】使用指南和实例https://vip.kingdee.com/article/489160939149874944