Page tree
Skip to end of metadata
Go to start of metadata

针对在eazyBI中做好的报告,我们可以让第三方系统通过rest的这种方式进行调用 ,获得数据后进行按自己的业务计算,将报告显示在自己的环境中。

接口

<jirabaseurl>/plugins/servlet/eazybi/accounts/2/export/report/119-06.json

其中参数包括

值说明
accountid如示例的:2
reportid如示例的:119-06
format

如:json

格式支持:

  • csv
  • xls
  • json
  • pdf
  • png


返回值

{
    "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"
}



  • No labels