获取应用巡检规则列表

第三方应用可以直接通过调用该接口，获取特定租户的特定产品中特定子系统对应的规则列表 (==注意使用V2.0授权方式==)

接口说明

• 调用地址

正式：https://zenith.fdcyun.com/v20/api/pub/patrol/get-category-rules.svc
测试：https://planet-test.fdcyun.com/v20/api/pub/patrol/get-category-rules.svc

• 调用方式：POST
• 请求头信息（header）

x-token:xxxxx //调用服务云[认证接口]得到的token，未传输此头的请求无法获取数据
x-custid:xxxx //客户主数据GUID
Content-Type: application/json; charset=utf-8

• 请求体（body）

{
    "size":100,
    "page":1,
    "product_id":265, //产品ID 
    "subsystem_code":"0011",//产品子系统编码 
    "type":"标准" ,// 标准|专项 **注意当前服务云平台暂不提供对个性化的规则进行查询和修改
    "key_type":-1,  //0：查询规则名称，1查询SQL 其他值一律不生效
    "keyword":"939", //需要查询的模糊匹配的内容
    "enable":1, //2020-06-01新增，enable=1查询启用状态的规则,enable=0查询未启用的规则
    "process_state": 1 //2020-06-01新增，process_state=1查询可修改的规则，process_state=0查询不可修改的规则
}

• 返回结果

成功返回，http状态码为 200
{
    "total": 3,
    "items": [
        {
            "product_id": 265,
            "product_name": "V1.0SP5",
            "subsystem_code": "0011",
            "subsystem": "销售系统",
            "bu_name": "销售系统应用巡检",
            "bu_scope": 1,
            "bu_type": "业务评估",
            "mold": "专项",
            "index_name": "房款-转账",
            "index_type": "业务功能应用",
            "rule_id": 5430,
            "name": "近3个月存在转账记录",
            "description": "在售项目下的单据类型为转账单且创建时间在最近3个月的平均记录数都 ≥ 3（3条/平均在售分期/90天）",
            "status": 1,
            "sql": "select 1 as score"
        },
        {
            "product_id": 265,
            "product_name": "V1.0SP5",
            "subsystem_code": "0011",
            "subsystem": "销售系统",
            "bu_name": "tt应用监控巡检",
            "bu_scope": 1,
            "bu_type": "业务评估",
            "mold": "专项",
            "index_name": "活跃用户",
            "index_type": "系统活跃情况",
            "rule_id": 5997,
            "name": "低:近3个月活跃用户占比超30%",
            "description": "近3个月活跃用户占比超30%",
            "status": 1,
            "sql": "SELECT case when  COUNT (a.paramname)>0 then 10 else 0 end as score FROM    myBizParamRegist a  LEFT JOIN (SELECT   ParamName,     ParamValue  FROM     myBizParamOption  GROUP BY myBizParamOption.ParamName,   myBizParamOption.ParamValue  ) b ON b.ParamName = a.ParamName      AND SUBSTRING(a.Options,          (CHARINDEX('工作流', a.Options) - 2), 1) = b.[ParamValue] WHERE   a.ParamType = '参数配置' AND CHARINDEX('工作流', a.Options) > 0 AND b.ParamName IS NOT NULL"
        },
        {
            "product_id": 265,
            "product_name": "V1.0SP5",
            "subsystem_code": "0011",
            "subsystem": "销售系统",
            "bu_name": "应用监控巡检sss",
            "bu_scope": 1,
            "bu_type": "项目评估",
            "mold": "专项",
            "index_name": "活跃用户",
            "index_type": "系统活跃情况",
            "rule_id": 6045,
            "name": "低:近3个月活跃用户占比超30%",
            "description": "近3个月活跃用户占比超30%",
            "status": 1,
            "sql": "SELECT case when  COUNT (a.paramname)>0 then 10 else 0 end as score FROM    myBizParamRegist a        LEFT JOIN (SELECT   ParamName,                            ParamValue                   FROM     myBizParamOption                 GROUP BY myBizParamOption.ParamName,     myBizParamOption.ParamValue       ) b ON b.ParamName = a.ParamName            AND SUBSTRING(a.Options,                     (CHARINDEX('工作流', a.Options) - 2), 1) = b.[ParamValue] WHERE   a.ParamType = '参数配置'      AND CHARINDEX('工作流', a.Options) > 0  AND b.ParamName IS NOT NULL"
        }
    ]
}

失败返回，http状态码为 500
//失败返回
{
    "Message": "应用ID不存在",
    "ExceptionType":"System.Exception",
    "xxx": "xxx" //后续扩展
}

• 返回代码说明

更新说明

2020-06-01新增两个参数用于过滤

• "enable": enable=1查询启用状态的规则,enable=0查询未启用的规则
• "process_state": process_state=1查询可修改的规则，process_state=0查询不可修改的规则