应用与数据集成平台 ROMA CONNECT-组合任务自动映射:响应示例

时间:2024-07-04 15:42:16

响应示例

状态码: 200

ok

[ {
  "target_instance_id" : "62afe8b5-6bf0-40ea-b4f6-6b06a39be754",
  "source_app_id" : "c24d7cf4-0e5a-416c-b197-30e6696b98f2",
  "mapping" : [ {
    "ext_info" : {
      "server_id" : 1665647763438
    },
    "id" : "f1c1d7f3afc94c1c995628df55939ced",
    "mapping" : [ {
      "is_add_boolean_mapping" : false,
      "is_add_custom_mapping" : false,
      "is_add_date_mapping" : false,
      "is_add_fdi_uuid_mapping" : false,
      "is_add_mapping" : false,
      "source_column" : "c1",
      "source_column_length" : "10",
      "source_column_type" : "INT",
      "target_column" : "c1",
      "target_column_length" : "10",
      "target_column_type" : "INT"
    }, {
      "is_add_boolean_mapping" : false,
      "is_add_custom_mapping" : false,
      "is_add_date_mapping" : false,
      "is_add_fdi_uuid_mapping" : false,
      "is_add_mapping" : false,
      "source_column" : "c2",
      "source_column_length" : "100",
      "source_column_type" : "VARCHAR",
      "target_column" : "c2",
      "target_column_length" : "100",
      "target_column_type" : "VARCHAR"
    } ],
    "mapping_percent" : 100,
    "project_id" : "0ab7e64afd80d2822fe0c00d26395a1f",
    "source_columns" : [ {
      "field_length" : "10",
      "field_name" : "c1",
      "field_type" : "INT",
      "null_able" : "0",
      "unique" : "1"
    }, {
      "field_length" : "100",
      "field_name" : "c2",
      "field_type" : "VARCHAR",
      "null_able" : "1",
      "unique" : "0"
    } ],
    "source_ds_id" : "984edcd6735c4988b15f6a497cb97c5a",
    "source_group" : "SOURCE_GROUP1",
    "source_table" : "test.t1",
    "status" : "ADD",
    "target_columns" : [ {
      "field_length" : "10",
      "field_name" : "c1",
      "field_type" : "INT",
      "null_able" : "0",
      "unique" : "0"
    }, {
      "field_length" : "100",
      "field_name" : "c2",
      "field_type" : "VARCHAR",
      "null_able" : "1",
      "unique" : "0"
    } ],
    "target_ds_id" : "dd14c908aa4d446b85949550f523ff83",
    "target_group" : "TARGET_GROUP1",
    "target_table" : "fditest.t1",
    "task_id" : "e530a006683d400e8b3bac1d7c00952b",
    "updated_time" : 1665647764511
  } ],
  "target_ds_name" : "fdi_MySQL_zqx_205",
  "target_app_id" : "c24d7cf4-0e5a-416c-b197-30e6696b98f2",
  "source_instance_id" : "62afe8b5-6bf0-40ea-b4f6-6b06a39be754",
  "task_id" : "e530a006683d400e8b3bac1d7c00952b",
  "source_ds_type" : "MYSQL",
  "ext_info" : {
    "server_id" : 1665647763438
  },
  "target_ds_type" : "MYSQL",
  "total" : 1,
  "source_group" : "SOURCE_GROUP1",
  "source_ds_id" : "984edcd6735c4988b15f6a497cb97c5a",
  "target_group" : "TARGET_GROUP1",
  "source_ds_name" : "mysql8.0.30",
  "target_ds_id" : "dd14c908aa4d446b85949550f523ff83"
} ]
support.huaweicloud.com/api-roma/CreateMultiTaskMappingsAutomatically.html