URI GET /v2/{project_id}/design/aggregation-logic-tables 表1 路径参数 参数 是否必选 参数类型 描述 project_id 是 String 项目id 表2 Query参数 参数 是否必选 参数类型 描述 name 否 String 按名称或编码模糊查询 create_by 否 String 按创建者查询 approver 否 String 按审核人查询 owner 否 String 按负责人查询 status 否 String 业务状态 枚举值： DRAFT PUBLISH_DEVELOPING PUBLISHED OFFLINE_DEVELOPING OFFLINE REJECT sync_status 否 String 枚举值： RUNNING NO_NEED SUMMARY_SUCCESS SUMMARY_FAILED sync_key 否 Array 枚举值： BUSINESS_ASSET DATA_QUALITY TECHNICAL_ASSET META_DATA_LINK PHYSICAL_TABLE DLF_TASK MATERIALIZATION l3_id 否 Long 业务对象l3 id begin_time 否 String 时间过滤左边界,与end_time一起使用,只支持时间范围过滤,单边过滤无效 end_time 否 String 时间过滤右边界,与begin_time一起使用只支持时间范围过滤,单边过滤无效 limit 否 Integer 查询条数，即查询Y条数据。默认值50，取值范围[1,100] 最大值：100 缺省值：50 offset 否 Integer 查询起始坐标，即跳过X条数据，仅支持0或limit的整数倍，不满足则向下取整。默认值0 缺省值：0 biz_catalog_id 否 String 所属的业务分层的id auto_generate 否 Boolean 是否自动生成

响应参数 状态码： 200 表4 响应Body参数 参数 参数类型 描述 data Object 返回的数据信息 状态码： 400 表5 响应Body参数 参数 参数类型 描述 error_code String 错误码，如DS.000，请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码： 401 表6 响应Body参数 参数 参数类型 描述 error_code String 错误码，如DS.000，请求处理成功 error_msg String 错误信息 data Object 返回的数据信息 状态码： 403 表7 响应Body参数 参数 参数类型 描述 error_code String 错误码，如DS.000，请求处理成功 error_msg String 错误信息 data Object 返回的数据信息

响应示例 状态码： 200 Success，返回data数据是 AggregationLogicTableVO 数组, 以及总数 { "data" : { "value" : { "records" : [ { "id" : "874242075850342400", "tb_name" : "dws_rate_code", "tb_logic_name" : "费率代码汇总", "l1_id" : "873232498044411904", "l2_id" : "873232716601204736", "l3_id" : "873233519286059008", "description" : "无", "owner" : "abc", "create_by" : "abc", "queue_name" : "dgc_dli_test", "dw_id" : "2c9080f07b03db8d017b198a4a20002f", "db_name" : "demo_dm_db", "tb_id" : "NativeTable-2c9080f07b03db8d017b198a4a20002f-demo_dm_db-dws_rate_code", "schema" : "", "dw_name" : null, "status" : "PUBLISHED", "tb_guid" : "a268644b-31b6-42e5-84ec-e35c31b541a5", "tb_logic_guid" : "8948f715-3567-4684-9950-e3ed01e77121", "dw_type" : "DLI", "l1" : "城市交通", "l2" : "行程记录", "l3" : "记录统计", "create_time" : "2021-08-09T10:45:54+08:00", "update_time" : "2021-09-26T15:36:53+08:00", "approval_info" : { "id" : "874242076399796224", "tenant_id" : null, "name_ch" : null, "name_en" : null, "biz_id" : "874242075850342400", "biz_type" : null, "biz_info" : null, "biz_info_obj" : null, "biz_version" : 0, "biz_status" : "PUBLISHED", "approval_status" : "APPROVED", "approval_type" : null, "submit_time" : "2021-08-09T10:45:54+08:00", "create_by" : null, "l1" : null, "l2" : null, "l3" : null, "approval_time" : "2021-08-09T10:45:53+08:00", "approver" : "abc", "email" : null, "msg" : "Fast Approval OK.", "directory_path" : null }, "new_biz" : null, "dimension_group" : "873252544997130240", "group_name" : "费率代码", "group_code" : null, "time_period" : { "id" : "874242075984560130", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 1, "name_en" : "dtime", "name_ch" : "统计日期", "attribute_type" : "SUMMARY_TIME", "is_primary_key" : false, "is_partition_key" : true, "not_null" : false, "description" : null, "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "ref_id" : null, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, "table_attributes" : [ { "id" : "874242075984560130", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 1, "name_en" : "dtime", "name_ch" : "统计日期", "attribute_type" : "SUMMARY_TIME", "is_primary_key" : false, "is_partition_key" : true, "not_null" : false, "description" : null, "data_type" : "TIMESTAMP", "domain_type" : "DATETIME", "data_type_extend" : null, "ref_id" : null, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560131", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 2, "name_en" : "sum_total_amount", "name_ch" : "总车费(费率代码)", "attribute_type" : "DERIVATIVE_INDEX", "is_primary_key" : false, "is_partition_key" : false, "not_null" : false, "description" : "", "data_type" : "DOUBLE", "domain_type" : "NUMBER", "data_type_extend" : null, "ref_id" : "873265784540004352", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560132", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 3, "name_en" : "dim_rate_code_rate_code_id", "name_ch" : "费率代码_费率id", "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE", "is_primary_key" : false, "is_partition_key" : false, "not_null" : true, "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "ref_id" : "873252544997130240.873258130849636352", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null }, { "id" : "874242075984560133", "aggregation_logic_table_id" : "874242075850342400", "ordinal" : 4, "name_en" : "dim_rate_code_rate_code_value", "name_ch" : "费率代码_费率说明", "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE", "is_primary_key" : false, "is_partition_key" : false, "not_null" : false, "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : null, "ref_id" : "873252544997130240.873258130849636353", "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null } ], "physical_table" : "CREATE_SUCCESS", "technical_asset" : "UPDATE_SUCCESS", "business_asset" : "UPDATE_SUCCESS", "meta_data_link" : "UPDATE_SUCCESS", "data_quality" : "UPDATE_SUCCESS", "dlf_task" : "CREATE_SUCCESS", "publish_to_dlm" : "NO_NEED", "summary_status" : "SUMMARY_SUCCESS", "distribute" : null, "distribute_column" : null, "table_type" : "MANAGED", "dlf_task_id" : "demo_dm_db_dws_rate_code_874242075850342400", "quality_id" : "874242188178075649", "reversed" : null, "table_version" : 0, "partition_conf" : null, "dirty_out_switch" : false, "dirty_out_database" : "", "dirty_out_prefix" : "", "dirty_out_suffix" : "", "alias" : "", "self_defined_fields" : [ ], "api_id" : null } ] } } }