针对在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" }