【仅供内部供应商使用,不提供对外解答和培训】

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

访问报表Parameter_3.cpt的数据集内容。

获取data结果:

2.2.3

...

报表结果JSON服务API(新版)

URL地址

http://ip:port/webroot/decision/api/report

METHOD

POST

Content-Type

application/json

RAW

{
    "report_path": "tabledataService/Parameter_3.cpt",
    "start_page": 1,
    "end_page": 1,
    "timestamp": "123456789",
    "sign": "468705dc60eff5f67438f9b94ed15245",
    "parameters": [
        {
            "name": "产品类型",
            "type": "String",
            "value": "饮料"
        },
        {
            "name": "地区",
            "type": "String",
            "value": "华北"
        }
    ]
}

Response响应

{
    "err_code": 0,
    "err_msg": "",
    "start_page": 1,
    "end_page": 1,
    "total_page_number": 1,
    "data": [
        {
            "A1": "华北销售额",
            "A2": "地区"
        }
    ]
}

参数说明:

  • report_path:报表模板路径名称(必须项),例如 tabledataService/Parameter_3.cpt。
  • start_page:报表内容起始页码(必须项);
  • end_page:报表内容结束页码(必须项);
  • parameters:报表面板参数(可选);参数名对应模板参数空间名称;
  • timestamp:当前时间的毫秒数(用于签名认证,可选);
  • sign:安全签名(用于签名认证,可选);

 响应说明:

  • err_code:0为正常,其他参见错误码表;
  • err_msg:错误信息;
  • total_page_number:总页数;
  • start_page:报表内容起始页码;
  • end_page:报表内容结束页码;
  • data:获取到的JSON数据;数据key为行列码标识。

 报表结果JSON示例:

访问报表Parameter_3.cpt的数据集内容。

Image Added

Image Added

Image Added

参数JSON转换规则

参数类型

类型值

示例

字符串

String

{"name":"aa","type":"String","value":""}

整型

Integer

{"name":"aa","type":"Integer","value":""}

双精度型

Double

{"name":"aa","type":"Double","value":""}

日期

Date

{"name":"aa","type":"Date","value":""}

布尔型

Boolean

{"name":"aa","type":"Boolean","value":""}

公式

Formula

{"name":"aa","type":"Formula","value":""}

 


2.2.4 报表结果JSON服务API(旧版)

URL地址

http://ip:port/webroot/decision/url/api/report

METHOD

POST

Content-Type

application/json

RAW

{

    "report_path": "Parameter_3.cpt",

    "start_page": 1,

    "end_page": 1,

    "timestamp": "123456789",

    "sign": "468705dc60eff5f67438f9b94ed15245",

    "parameters": [{

           "name": "地区",

           "type": "String",

           "value": "华北"

       },

       {

           "name": "产品类型",

           "type": "String",

           "value": "饮料"

       }

    ]

}

Response响应

{

    "err_code": 0,

    "err_msg": "",

    "start_page": 1,

    "end_page": 1,

    "total_page_number": 1,

    "data": [

       [{

           "A1": "华北销售额","A2": "地区"

       }]

    ]

}

...