You need to enable JavaScript to run this app.
文档中心
大数据研发治理套件

大数据研发治理套件

复制全文
下载 pdf
DataSail-解决方案
ListSolutionTableMappings - 获取解决方案表映射
复制全文
下载 pdf
ListSolutionTableMappings - 获取解决方案表映射

获取数据集成解决方案库表映射信息

请求参数

下表仅列出该接口特有的请求参数和部分公共参数。更多信息请见公共参数。

Query

参数
类型
是否必填
示例值
描述
Action
String
是

ListSolutionTableMappings

要执行的操作,取值:ListSolutionTableMappings。

Version
String
是

2026-03-01

API的版本,取值:2026-03-01。

Body

参数
类型
是否必填
示例值
描述
ProjectId
Long
是

1

项目 ID

SolutionType
String
是

SYNC_STREAMING_MULTI_SNAP_ONCE_INCR

解决方案类型

Reader
Array of Object
否

--

解决方案 Reader

LogicReader
Object
否

--

解决方案 Logic Reader

Writer
Object
是

--

解决方案 Writer

TransformConfigs
Array of String
否

--

解决方案 Transform 配置

IdentifierMappingRule
Object
是

--

解决方案库、表名称映射规则配置

AdvancedConfig
Object
否

--

库、表映射自定义参数

ColumnMappingRules
String
否

--

列映射规则配置

返回参数

下表仅列出本接口特有的返回参数。更多信息请参见返回结构。

参数
类型
示例值
描述
TableMappings
Array of Object

--

解决方案表映射配置

请求示例

POST /?Action=ListSolutionTableMappings&Version=2026-03-01 HTTP/1.1
Host: dataleap.cn-beijing.volcengineapi.com
Content-Type: application/json; charset=UTF-8
X-Date: 20260414T092729Z
X-Content-Sha256: 287e874e******d653b44d21e
Authorization: HMAC-SHA256 Credential=Adfks******wekfwe/20260414/cn-beijing/dataleap/request, SignedHeaders=host;x-content-sha256;x-date, Signature=47a7d934ff7b37c03938******cd7b8278a40a1057690c401e92246a0e41085f

{
  "ProjectId": 1,
  "SolutionType": "SYNC_STREAMING_MULTI_SNAP_ONCE_INCR",
  "Reader": [
    {
      "DataSourceId": 1,
      "DataSourceType": "mysql",
      "DataSourceName": "读数据源",
      "CatalogMetas": [
        {
          "DatabaseName": "test_database",
          "SchemaName": "test_schema",
          "TableName": "test_table"
        }
      ],
      "Properties": [
        {
          "Name": "key1",
          "Value": "value1"
        }
      ]
    }
  ],
  "LogicReader": {
    "Readers": [],
    "FilterExps": {
      "DatabaseName": [
        {
          "FilterType": "FULL",
          "FilterAction": "INCLUDE",
          "FilterPattern": "test"
        }
      ],
      "SchemaName": [
        {
          "FilterType": "FULL",
          "FilterAction": "INCLUDE",
          "FilterPattern": "test"
        }
      ],
      "TableName": [
        {
          "FilterType": "FULL",
          "FilterAction": "INCLUDE",
          "FilterPattern": "test"
        }
      ]
    },
    "ReaderTableMode": "STATIC_TABLE_SPECIFIED",
    "BinlogType": "DEBEZIUM_JSON",
    "LogicCatalogMeta": {
      "DatabaseName": "test_database",
      "SchemaName": "test_schema",
      "TableName": "test_table"
    },
    "Parameter": {
      "LogicDatabaseName": "default",
      "LogicTableName": "default",
      "Columns": [
        {
          "Name": "column1",
          "Type": "String",
          "Value": "D3p",
          "Nullable": true,
          "Description": "test column",
          "IsPartitionColumn": true,
          "IsPrimaryKey": true,
          "Precision": 32,
          "Scale": 6,
          "IsAdditionalColumn": "false",
          "SupportTypeList": [
            "h1"
          ],
          "DefaultValue": "test",
          "DefaultValueRawExpression": true,
          "Properties": "HGZeNoc2Kn",
          "Length": 128
        }
      ],
      "SplitKeys": [
        "FxQGyy32l7"
      ]
    }
  },
  "Writer": {
    "DataSourceId": 1,
    "DataSourceType": "mysql",
    "DataSourceName": "写数据源",
    "Partitions": [],
    "Properties": [
      {
        "Name": "key1",
        "Value": "value1"
      }
    ]
  },
  "TransformConfigs": [
    "MbHmiYCp4"
  ],
  "IdentifierMappingRule": {
    "DatabaseMappings": [
      {
        "SourceName": "source_database",
        "TargetName": "target_database"
      }
    ],
    "SchemaMappings": [
      {
        "SourceName": "source_schema",
        "TargetName": "target_schema"
      }
    ],
    "TableMappings": [
      {
        "SourceName": "source_table",
        "TargetName": "target_table"
      }
    ]
  },
  "AdvancedConfig": {
    "ColumnAlignmentType": "NO_ALIGNMENT",
    "BatchMode": "JDBC",
    "DtsSubscriptionTaskId": "dts_123",
    "DtsSubscriptionTaskName": "test_subscribe",
    "Debezium": [
      "c"
    ],
    "CustomParameter": [
      {
        "Key": "key1",
        "Value": "value1",
        "Type": "String"
      }
    ]
  },
  "ColumnMappingRules": "F83P"
}

返回示例

{
  "ResponseMetadata": {
    "RequestId": "20260414172737011046019171598F0B",
    "Action": "ListSolutionTableMappings",
    "Version": "2026-03-01",
    "Service": "dataleap",
    "Region": "cn-beijing"
  },
  "Result": {
    "TableMappings": [
      {
        "EnableSnapshot": true,
        "EnabledTruncateTable": true,
        "TableCreationType": "NEW",
        "Reader": {
          "DataSourceId": 1,
          "Parameter": {
            "ProjectId": 1,
            "DatabaseName": "test_database",
            "SchemaName": "test_schema",
            "TableName": "test_table",
            "Columns": [
              {
                "Name": "column1",
                "Type": "String",
                "Value": "SqP3T52M2Jj",
                "Nullable": true,
                "Description": "test column",
                "IsPartitionColumn": true,
                "IsPrimaryKey": true,
                "Precision": 32,
                "Scale": 6,
                "IsAdditionalColumn": "false",
                "SupportTypeList": [
                  "z6IQ"
                ],
                "DefaultValue": "test",
                "DefaultValueRawExpression": true,
                "Properties": "b",
                "Length": 128
              }
            ],
            "SplitKeys": [
              "0kjKA"
            ],
            "ShardingKeys": [
              "X"
            ],
            "SortStrategy": {
              "SortType": "SMART"
            },
            "PartitionKeys": [
              "96otoJL"
            ],
            "OrderByKeys": [
              "84fp9g"
            ],
            "Properties": [
              {
                "Name": "key1",
                "Value": "value1"
              }
            ]
          }
        },
        "LogicReader": {
          "Readers": [
            {
              "DataSourceId": 1,
              "DataSourceType": "mysql",
              "DataSourceName": "读数据源",
              "CatalogMetas": [],
              "Properties": [
                {
                  "Name": "key1",
                  "Value": "value1"
                }
              ]
            }
          ],
          "FilterExps": {
            "DatabaseName": [
              {
                "FilterType": "FULL",
                "FilterAction": "INCLUDE",
                "FilterPattern": "test"
              }
            ],
            "SchemaName": [
              {
                "FilterType": "FULL",
                "FilterAction": "INCLUDE",
                "FilterPattern": "test"
              }
            ],
            "TableName": [
              {
                "FilterType": "FULL",
                "FilterAction": "INCLUDE",
                "FilterPattern": "test"
              }
            ]
          },
          "ReaderTableMode": "STATIC_TABLE_SPECIFIED",
          "BinlogType": "DEBEZIUM_JSON",
          "LogicCatalogMeta": {
            "DatabaseName": "test_database",
            "SchemaName": "test_schema",
            "TableName": "test_table"
          },
          "Parameter": {
            "LogicDatabaseName": "default",
            "LogicTableName": "default",
            "Columns": [
              {
                "Name": "column1",
                "Type": "String",
                "Value": "GDHp01Yoi",
                "Nullable": true,
                "Description": "test column",
                "IsPartitionColumn": true,
                "IsPrimaryKey": true,
                "Precision": 32,
                "Scale": 6,
                "IsAdditionalColumn": "false",
                "SupportTypeList": [
                  "Dp"
                ],
                "DefaultValue": "test",
                "DefaultValueRawExpression": true,
                "Properties": "pPerWDRuA",
                "Length": 128
              }
            ],
            "SplitKeys": [
              "ffcQQY4c"
            ]
          }
        },
        "Writer": {
          "DataSourceId": 1,
          "Parameter": {}
        },
        "TransformConfigs": [
          "56XEAUwej6"
        ],
        "SyncStrategy": {
          "Ddl": {
            "CreateTable": "IGNORE",
            "DropTable": "IGNORE",
            "AddTableColumn": "IGNORE",
            "DropTableColumn": "IGNORE",
            "RenameTable": "IGNORE",
            "RenameTableColumn": "IGNORE",
            "UpdateTableColumn": "IGNORE",
            "TruncateTable": "IGNORE"
          },
          "Cycle": {
            "Frequency": "hourly",
            "RetryNum": 1,
            "RetryInterval": 1,
            "ScheduleTime": "0",
            "ScheduleDay": "1,2,3",
            "ScheduleMonth": "1"
          },
          "Incremental": {
            "FilterCondition": "ID > 0"
          },
          "WriteMode": "OsxY57njiKm"
        },
        "AdvancedConfig": {
          "ColumnAlignmentType": "NO_ALIGNMENT",
          "BatchMode": "JDBC",
          "DtsSubscriptionTaskId": "dts_123",
          "DtsSubscriptionTaskName": "test_subscribe",
          "Debezium": [
            "c"
          ],
          "CustomParameter": [
            {
              "Key": "key1",
              "Value": "value1",
              "Type": "String"
            }
          ]
        },
        "PartitionMode": "NoPartitionMode",
        "PartitionDefinition": "partition1"
      }
    ]
  }
}

错误码

下表为您列举了该接口与业务逻辑相关的错误码。公共错误码请参见公共错误码文档。

状态码
错误码
错误信息
说明
200
InternalError

access denied, user {0} does not have {1} permission

获取表映射配置错误

最近更新时间:2026.06.09 11:28:25
这个页面对您有帮助吗?
有用
有用
无用
无用