描述

查询报表数据。

请求

• URL

  https://api.dadayun.cn/v1/report/templates/$idOrName/search

• HTTP请求方式

  GET

• HTTP请求参数

响应

• 返回参数

返回报表数据，列表数据项参数说明：

• QueryGridsConfig 参数说明

• QueryFieldsMap 参数说明

• MapConfig 参数说明

• Columns 参数说明

• DataFormat 参数说明

• QueryColumns 参数说明

• LeftAxis 参数说明

• TopAxis 参数说明

示例

请求示例

GET  /v1/report/templates/bddbfff3-3d8d-4539-b7e4-6f67ab1ec6e9?version=-1 HTTP/1.1
Host: api.dadayun.cn
Date: Thu, 30 Aug 2018 02:55:22 GMT

正常返回示例

HTTP/1.1 200 OK
Date: Thu, 30 Aug 2018 02:55:22 GMT
Content-Type: application/json; charset=utf-8

{
    "Id": "bddbfff3-3d8d-4539-b7e4-6f67ab1ec6e9",
    "Name": "产品信息查询",
    "ReportType": 2,
    "TotalSummary": false,
    "GroupSummary": false,
    "DefaultGroupField": "",
    "ForceFit": true,
    "MainDataSource": "af1c1f86-7336-4c8b-942d-7fff47f3d161",
    "Creator": "d63f3678-5082-4c8a-9bd5-5aef58c2be08",
    "CreateTime": "2015-05-28T13:55:30Z",
    "TableMap": "t1",
    "SortType": null,
    "SortField": "",
    "SortDirection": "ASC",
    "DistanceSortConfig": null,
    "QueryColumnCount": 2,
    "DefaultRange": "全部",
    "Aggregator": "sum",
    "MeasureField": "[]",
    "AggregationTitle": "",
    "Status": 1,
    "PageSize": 200,
    "IsReport": true,
    "ShowDraftData": false,
    "IsTabGrouping": false,
    "TabGroupingField": null,
    "QueryMode": "tree",
    "ClickQureyReportTplId": "",
    "ClickQueryReportColumns": null,
    "ClickQueryFields": "36fe4b23-90b8-41c8-8a5a-52444491d678,227e5afc-922f-4682-a112-0f5117535333,da830e78-*d353-4554-8d2b-6ced7e73b975,e9111279-8138-43f6-a6b7-a4c91133ca8c",
    "QueryModes": "normal,tree",
    "QueryNormalName": "产品普通查询器",
    "QueryTreeName": "产品查询树",
    "QueryCascadeFields": "36fe4b23-90b8-41c8-8a5a-52444491d678,227e5afc-922f-4682-a112-0f5117535333,da830e78-*d353-4554-8d2b-6ced7e73b975,e9111279-8138-43f6-a6b7-a4c91133ca8c",
    "QueryFuzzySearchColumns": null,
    "QueryFuzzySearchEmptyText": null,
    "QueryGridsConfig": null,
    "CreatorName": null,
    "BatchProcessorConfiguration": "{\"batchModeEnable\":true,\"batchMode\":1,\"listInputCfg\":{\"actionType\":2,\"btnActionText\":*\"发起采购申请\",\"tempFolderText\":\"购物车\",\"wfTplId\":\"8ac78f4c-a7eb-4d0c-ab8e-19930fa4ec6f\",\"wfTplName\":\"采购申请\",*\"formTplId\":\"240ed22e-b775-4c80-9050-f73b8843f7a4\",\"formTplName\":\"采购申请单\",\"subEntityFormId\":*\"930a4ebc-2a8e-4502-8b20-abd7cfb3aa91\",\"maps\":[{\"ReportColumn\":\"名称\",\"FormField\":\"采购货品清单-名称\"},{\"ReportColumn*\":\"品牌\",\"FormField\":\"采购货品清单-品牌\"},{\"ReportColumn\":\"系列\",\"FormField\":\"采购货品清单-系列\"},{\"ReportColumn\":*\"型号\",\"FormField\":\"采购货品清单-型号\"},{\"ReportColumn\":\"产品类别\",\"FormField\":\"采购货品清单-类别\"},{\"RecId\":\"ext-*gen1069\",\"ReportColumn\":\"测试\",\"FormField\":\"采购货品清单-金额\"}]},\"batchFormEditorCfg\":{},\"batchTaskCfg\":{}}",
    "RemoveDuplicate": false,
    "MapConfig": null,
    "LayoutGraphConfig": null,
    "Columns": [
        {
            "Id": "c692881f-1f83-4291-80b2-0102db759791",
            "ReportTplId": "bddbfff3-3d8d-4539-b7e4-6f67ab1ec6e9",
            "FormId": "af1c1f86-7336-4c8b-942d-7fff47f3d161",
            "FieldId": "684923ae-6fac-4e63-b67a-1791771c5536",
            "FieldMap": "F0",
            "TableMap": "t1",
            "ColumnWidth": 100,
            "Summary": null,
            "Level": null,
            "Header": "产品类别",
            "DataType": 0,
            "NumType": null,
            "TailDigits": null,
            "Unit": null,
            "TimeZone": "0",
            "IsDate": false,
            "IsAddress": false,
            "IsPicture": false,
            "IsAttachment": false,
            "OrderIndex": 0,
            "IsFormulation": false,
            "Formulation": null,
            "IsOperator": false,
            "IsOperateTime": false,
            "WFTplId": null,
            "WFNodeId": null,
            "Hidden": false,
            "Color": null,
            "ColumnStyle": null,
            "DataFormat": null,
            "DataLink": null,
            "InternationalHeader": "产品类别",
            "UseVisualPrecise": false,
            "CalculateAfterPaging": false,
            "GetValueFromCache": false,
            "CacheKeyPreString": null,
            "CacheKeyColumns": null
        },
        ...
    ],
    "QueryColumns": [
        {
            "Id": "36fe4b23-90b8-41c8-8a5a-52444491d678",
            "ReportTplId": "bddbfff3-3d8d-4539-b7e4-6f67ab1ec6e9",
            "OperatorList": null,
            "DefaultOperator": "包含",
            "IsPopular": true,
            "OrderIndex": 0,
            "ShowOperator": true,
            "FieldMap": "t1.Field4",
            "DatetimeQueryField": null,
            "DataType": 0,
            "NumType": null,
            "TailDigits": null,
            "Unit": null,
            "Header": "名称",
            "Summary": null,
            "TimeZone": null,
            "IsDate": false,
            "IsAddress": false,
            "Level": null,
            "FieldId": "a8c156af-6d8a-41f7-a7b8-36094e738a02",
            "FormId": "af1c1f86-7336-4c8b-942d-7fff47f3d161",
            "WFTplId": null,
            "WFNodeId": null,
            "IsDefaultTimeCondition": false,
            "IsOperator": null,
            "IsOperateTime": null,
            "DefaultValue": "",
            "IsLock": false,
            "InternationalHeader": "名称",
            "IsQueryHidden": null
        },
        ...
    ],
    "KeyFields": [],
    "RelatedDataSource": [],
    "RelatedDataObject": [
        {}
    ],
    "LeftAxis": [],
    "TopAxis": [],
    "GraphConfigurations": [],
    "InternationalName": "产品信息查询"
}

异常返回示例

HTTP/1.1 500 Internal Server Error
Date: Thu, 30 Aug 2018 02:55:22 GMT
Content-Type: application/json; charset=utf-8

{
  "Code": "Invalid_Param",
  "Message": "验证参数fields不合法"
}

错误码