Queries the analysis result of a schema synchronization task.
Debugging
Authorization information
There is currently no authorization information disclosed in the API.
Request parameters
| Parameter | Type | Required | Description | Example |
|---|---|---|---|---|
| OrderId | long | Yes | The ID of the ticket. | 1342355 |
| CompareType | string | No | The type of the comparison. Valid values:
| CREATE_TABLE |
| PageNumber | long | No | The number of the page to return. | 1 |
| PageSize | long | No | The number of entries to return on each page. | 20 |
| Tid | long | No | The ID of the tenant. Note
To view the tenant ID, move the pointer over the profile picture in the upper-right corner of the Data Management (DMS) console. For more information, see Manage DMS tenants.
| 1 |
Response parameters
Examples
Sample success responses
JSONformat
{
"RequestId": "1810E635-A2D7-428B-BAA9-85DAEB9B1A77",
"Success": true,
"ErrorMessage": "UnknownError",
"ErrorCode": "UnknownError",
"StructSyncJobAnalyzeResult": {
"SummaryList": [
{
"CompareType": "CREATE_TABLE",
"Count": 1
}
],
"ResultList": [
{
"SourceTableName": "helloz_bak",
"TargetTableName": "helloz_bak",
"Script": "/\\* origin table\\[helloz_bak] exist, target table\\[helloz_bak] not exist \\*/\\n/\\* generate \\[helloz_bak] create table sql \\*/\\ncreate table \\`helloz_bak\\`(\\n\\t\\`id\\` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary key',\\n\\t\\`gmt_create\\` datetime NOT NULL COMMENT 'Creation time',\\n\\t\\`gmt_modified\\` datetime NOT NULL COMMENT 'Modification time',\\n\\t\\`num\\` int(11) NOT NULL COMMENT 'Number',\\n\\t\\`addr\\` varchar(50) CHARACTER SET utf8 COLLATE utf8\\_general_ci NOT NULL COMMENT 'Address',\\n\\tPRIMARY KEY (\\`id\\`)\\n)\\nDEFAULT CHARACTER SET=utf8 COLLATE=utf8\\_general_ci\\nCOMMENT='test'\\n\\n;\n"
}
]
}
}Error codes
For a list of error codes, visit the Service error codes.
Change history
| Change time | Summary of changes | Operation |
|---|
No change history