Help Center/ Data Replication Service/ API Reference/ APIs V3.0 (Deprecated)/ Public API Management/ Querying Row Comparison Details
Updated on 2024-05-27 GMT+08:00
View PDF
Share

Querying Row Comparison Details

Function

This API is used to query row comparison details.

URI

GET /v3/{project_id}/jobs/{job_id}/compare/{compare_job_id}/line-detail

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID of a tenant in a region.

For details, see Obtaining a Project ID.

job_id

Yes

String

Task ID.

compare_job_id

Yes

String

ID of a comparison task.
Table 2 Query parameters

Parameter

Mandatory

Type

Description

status

No

Integer

Comparison status.

  • 0: The comparison result is inconsistent.
  • 2: The comparison result is consistent.
  • 3: The destination database table does not exist.
  • 4: The comparison failed.
  • 5: The comparison task is in progress.
  • 6: The comparison task is waiting to be started.
  • 7: The comparison task is canceled.
  • 8: The source database is empty.
  • 9: The destination database is empty.
  • 10: Both the source and destination databases are empty.
  • 11: The source table does not exist.
  • 12: The destination table does not exist.
  • 13: Neither the source table nor the destination table exists.
  • 14: Failed to connect to the source database.
  • 15: Failed to connect to the destination database.
  • 16: SQL execution timed out on the source database.
  • 17: SQL execution timed out on the destination database.
  • 18: A source database SQL execution error occurred.
  • 19: A destination database SQL execution error occurred.
  • 20: Neither the source database nor the destination database exists.
  • 21: The source database does not exist.
  • 22: The destination database does not exist.
  • 23: The number of rows exceeds 100 million, and the comparison cannot be performed.
  • 27: The comparison task timed out.

type

No

String

Type.

  • compare: Items that can be compared.
  • unCompare: Items that cannot be compared.

db_name

No

String

Source database name.

target_db_name

No

String

Destination database name.

query_tb_name

No

String

Keyword for filtering table names.

limit

No

Integer

Number of items displayed per page.

Default value: 1000

offset

No

Integer

Offset, which is the position where the query starts. The value must be no less than 0.

Default value: 0

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

Content-Type

Yes

String

The content type.

The default value is application/json.

X-Auth-Token

Yes

String

User token obtained from IAM.

X-Language

No

String

Request language type.

Default value: en-us

Enumerated values:

  • en-us
  • zh-cn

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

total_count

Integer

Comparison quantity.

table_line_compare_result_infos

Array of objects

Comparison information list.

For details, see Table 5.
Table 5 Data structure description of field TableLineCompareResultInfo

Parameter

Type

Description

source_table_name

String

Table name of the source database.

source_row_num

Long

Number of table rows in the source database.

target_table_name

String

Table name of the destination database.

target_row_num

Long

Number of table rows in the destination database.

difference_row_num

Long

Row differences.

status

Integer

Comparison status.

  • 0: The comparison result is inconsistent.
  • 2: The comparison result is consistent.
  • 3: The destination database table does not exist.
  • 4: The comparison failed.
  • 5: The comparison task is in progress.
  • 6: The comparison task is waiting to be started.
  • 7: The comparison task is canceled.
  • 8: The source database is empty.
  • 9: The destination database is empty.
  • 10: Both the source and destination databases are empty.
  • 11: The source table does not exist.
  • 12: The destination table does not exist.
  • 13: Neither the source table nor the destination table exists.
  • 14: Failed to connect to the source database.
  • 15: Failed to connect to the destination database.
  • 16: SQL execution timed out on the source database.
  • 17: SQL execution timed out on the destination database.
  • 18: A source database SQL execution error occurred.
  • 19: A destination database SQL execution error occurred.
  • 20: Neither the source database nor the destination database exists.
  • 21: The source database does not exist.
  • 22: The destination database does not exist.
  • 23: The number of rows exceeds 100 million, and the comparison cannot be performed.
  • 27: The comparison task timed out.

compare_line_config_filter

String

Row filtering condition.

Example Request

Querying row comparison details

https://{endpoint}/v3/054ba152d480d55b2f5dc0069e7ddef0/jobs/f8688cfa-4e05-406f-a2e6-37a773cjb20y/table/compare/48c6acb4-1473-48fd-8676-df3705758c27/line-detail?offset=0&limit=10

Example Response

Status code: 200

OK

{
  "total_count" : 2,
  "table_line_compare_result_infos" : [ {
    "source_table_name" : "tb2",
    "source_row_num" : 2434882,
    "target_table_name" : "tb2",
    "target_row_num" : 2434882,
    "difference_row_num" : 0,
    "status" : 2
  }, {
    "source_table_name" : "tb1",
    "source_row_num" : 1,
    "target_table_name" : "tb1",
    "target_row_num" : 1,
    "difference_row_num" : 0,
    "status" : 2
  } ]
}

Status code: 400

Bad Request

{
  "error_code" : "DRS.M00202",
  "error_msg" : "The value of jobId is invalid."
}

Status Code

Status Code

Description

200

OK

400

Bad Request

Error Code

For details, see Error Code.

Parent topic: Public API Management