针对在eazyBI中做好的报告,我们可以让第三方系统通过rest的这种方式进行调用 ,获得数据后进行按自己的业务计算,将报告显示在自己的环境中。
接口
其中参数包括
| 项 | 值说明 |
|---|---|
| accountid | 如示例的:2 |
| reportid | 如示例的:119-06 |
| format | 如:json 格式支持:
|
返回值
{
"report_name":"Created vs resolved issues over time",
"query_results":{
"column_positions":[
[
{
"name":"Issues created",
"full_name":"[Measures].[Issues created]",
"depth":0,
"format_string":"#,##0",
"annotations":{
"predefined":"true"
}
}
],
[
{
"name":"Issues resolved",
"full_name":"[Measures].[Issues resolved]",
"depth":0,
"format_string":"#,##0",
"annotations":{
"predefined":"true"
}
}
],
[
{
"name":"Average resolution days",
"full_name":"[Measures].[Average resolution days]",
"depth":0,
"format_string":"#,##0.00",
"annotations":{
"group":"Default",
"predefined":"true"
},
"calculated":true
}
],
[
{
"name":"Open issues",
"full_name":"[Measures].[Open issues]",
"depth":0,
"format_string":"#,##0",
"annotations":{
"group":"Default",
"predefined":"true"
},
"calculated":true
}
]
],
"row_positions":[
[
{
"name":"Apr 2020",
"full_name":"[Time].[2020].[Q2 2020].[Apr 2020]",
"drillable":true,
"depth":3,
"start_date":"2020-04-01"
}
],
[
{
"name":"May 2020",
"full_name":"[Time].[2020].[Q2 2020].[May 2020]",
"drillable":true,
"depth":3,
"start_date":"2020-05-01"
}
],
[
{
"name":"Jun 2020",
"full_name":"[Time].[2020].[Q2 2020].[Jun 2020]",
"drillable":true,
"depth":3,
"start_date":"2020-06-01"
}
],
[
{
"name":"Jul 2020",
"full_name":"[Time].[2020].[Q3 2020].[Jul 2020]",
"drillable":true,
"depth":3,
"start_date":"2020-07-01"
}
],
[
{
"name":"Aug 2020",
"full_name":"[Time].[2020].[Q3 2020].[Aug 2020]",
"drillable":true,
"depth":3,
"start_date":"2020-08-01"
}
]
],
"values":[
[
72,
1,
0.02,
71
],
[
561,
54,
1.565925925925926,
578
],
[
null,
null,
null,
578
],
[
null,
null,
null,
578
],
[
12,
1,
0,
589
]
],
"formatted_values":[
[
"72",
"1",
"0.02",
"71"
],
[
"561",
"54",
"1.57",
"578"
],
[
"",
"",
"",
"578"
],
[
"",
"",
"",
"578"
],
[
"12",
"1",
"0.00",
"589"
]
]
},
"definition":{
"columns":{
"dimensions":[
{
"name":"Measures",
"selected_set":[
"[Measures].[Issues created]",
"[Measures].[Issues resolved]",
"[Measures].[Average resolution days]",
"[Measures].[Open issues]"
]
}
]
},
"rows":{
"dimensions":[
{
"name":"Time",
"selected_set":[
"[Time].[Last 12 months]"
],
"selected_set_expression":"DescendantsSet({{selected_set}}, [Time].[Month])"
}
]
},
"pages":{
"dimensions":[
{
"name":"Time",
"current_page_members":[
"[Time].[Last 12 months]"
],
"members":[
{
"full_name":"[Time].[Last 12 months]",
"name":"Last 12 months"
}
],
"selected_set":[
"[Time].[All Times]",
"[Time].[Last 12 months]",
"[Time].[Current year]",
"[Time].[Previous year]"
],
"duplicate":true
},
{
"name":"Project",
"selected_set":[
"[Project].DefaultMember"
]
},
{
"name":"Issue Type",
"selected_set":[
"[Issue Type].DefaultMember"
]
},
{
"name":"Priority",
"selected_set":[
"[Priority].DefaultMember"
]
},
{
"name":"Assignee",
"selected_set":[
"[Assignee].DefaultMember"
]
}
]
},
"options":{
},
"view":{
"current":"line_chart",
"line_chart":{
"area":false,
"swap_axes":false,
"series_options":{
"Issues created":{
"type":"column",
"color":"#B31238"
},
"Issues resolved":{
"type":"column",
"color":"#00875A"
},
"Average resolution days":{
"separateAxis":true,
"color":"#274380",
"type":"spline"
},
"Open issues":{
"separateAxis":true,
"color":"#F24B13",
"type":"spline"
}
},
"y_axis":{
"1":{
"labelSuffix":" days"
}
}
}
}
},
"cube_name":"Issues",
"last_import_at":"2020-08-12T19:00:06.000Z"
}