响应示例 状态码： 200 Success，返回data数据是 DimensionLogicTableVO 数组, 以及总数 { "data" : { "value" : { "records" : [ { "id" : "873258132317642752", "tb_name" : "dim_vendor", "tb_logic_name" : "供应商", "l1_id" : "873232498044411904", "l2_id" : "873232798230675456", "l3_id" : "873233599258927104", "create_by" : "abc", "description" : "无", "dimension_id" : "873251051724242944", "owner" : "abc", "dimension_type" : "LOOKUP", "code_table_id" : "873235088123527168", "code_table" : null, "queue_name" : "dgc_dli_test", "dw_id" : "2c9080f07b03db8d017b198a4a20002f", "reversed" : null, "partition_conf" : null, "dirty_out_switch" : false, "dirty_out_database" : "", "dirty_out_prefix" : "", "dirty_out_suffix" : "", "db_name" : "demo_dwr_db", "tb_id" : "NativeTable-2c9080f07b03db8d017b198a4a20002f-demo_dwr_db-dim_vendor", "schema" : "", "table_type" : "MANAGED", "status" : "PUBLISHED", "tb_guid" : "cea79c27-446e-4529-86e7-d1b371ebb876", "tb_logic_guid" : "048cc0b7-3c0f-40cb-b0e9-e81261117f2d", "dimension_name" : "供应商", "attributes" : [ { "id" : "873258132321837056", "dimension_logic_table_id" : "873258132317642752", "ordinal" : 1, "dimension_attribute_id" : "873251051732631552", "name_en" : "vendor_id", "name_ch" : "供应商id", "description" : "", "data_type" : "BIGINT", "domain_type" : "NUMBER", "data_type_extend" : null, "is_primary_key" : true, "is_biz_primary" : true, "is_partition_key" : false, "not_null" : true, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null, "self_defined_fields" : null }, { "id" : "873258132321837057", "dimension_logic_table_id" : "873258132317642752", "ordinal" : 2, "dimension_attribute_id" : "873251051732631553", "name_en" : "vendor_value", "name_ch" : "供应商", "description" : "", "data_type" : "STRING", "domain_type" : "STRING", "data_type_extend" : null, "is_primary_key" : false, "is_biz_primary" : false, "is_partition_key" : false, "not_null" : false, "stand_row_id" : null, "stand_row_name" : null, "quality_infos" : null, "alias" : null, "self_defined_fields" : null } ], "dw_type" : " DLI ", "dw_name" : null, "l1" : "城市交通", "l2" : "集团", "l3" : "供应商", "create_time" : "2021-08-06T17:36:03+08:00", "update_time" : "2021-10-14T10:54:58+08:00", "approval_info" : { "id" : "873258129008336896", "tenant_id" : null, "name_ch" : null, "name_en" : null, "biz_id" : "873251051724242944", "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-06T17:36:02+08:00", "create_by" : null, "l1" : null, "l2" : null, "l3" : null, "approval_time" : "2021-08-06T17:36:03+08:00", "approver" : "abc", "email" : null, "msg" : "Fast Approval OK.", "directory_path" : null }, "new_biz" : null, "physical_table" : "CREATE_SUC CES S", "technical_asset" : "UPDATE_SUCCESS", "business_asset" : "UPDATE_SUCCESS", "meta_data_link" : "UPDATE_SUCCESS", "data_quality" : "UPDATE_SUCCESS", "materialization" : null, "summary_status" : "SUMMARY_SUCCESS", "distribute" : null, "distribute_column" : null, "quality_id" : "873258150667665409", "alias" : "", "self_defined_fields" : null } ] } } }

响应参数 状态码： 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 返回的数据信息

URI GET /v2/{project_id}/design/dimension-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 l2_id 否 Long 主题域l2 id dimension_id 否 Long 依据维度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 dimension_type 否 String 维度类型 枚举值： COMMON LOOKUP HIERARCHIES