数据治理中心 DATAARTS STUDIO-查找汇总表:响应示例

时间:2023-11-15 11:25:48

响应示例

状态码: 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
      } ]
    }
  }
}
support.huaweicloud.com/api-dataartsstudio/SearchAggregationLogicTables.html