Querying Value Comparison Differences

Updated on 2024-08-23 GMT+08:00

View PDF

Function

This API is used to query value comparison differences.

URI

GET /v3/{project_id}/jobs/{job_id}/compare/{compare_job_id}/content-difference

**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
table_name	No	String	Table name.
db_name	No	String	Source database name.
limit	No	Integer	Number of records displayed on each page. The maximum value is 1000. Minimum value: 1 Maximum value: 1000 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
count	Long	Total number of records.
target_meta_is_null	Long	Inconsistency details: The objects were found only in the source database.
source_meta_is_null	Long	Inconsistency details: The objects were found only in the destination database.
source_target_meta_not_null	Long	Inconsistency details: The objects were found in the source and destination databases.
contents_infos	Array of objects	List of detailed information. For details, see Table 5.

**Table 5** Data structure description of field **contents_infos**
Parameter	Type	Description
source_key_value	Array of strings	Key value list of the source database.
target_key_value	Array of strings	Key value list of the destination database.
select_sql	String	Query the SQL statements of the source database.
target_select_sql	String	Query the SQL statements of the destination database.

Example Request

Querying value comparison differences

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

Example Response

Status code: 200

{
  "count" : 1,
  "target_meta_is_null" : 0,
  "source_meta_is_null" : 0,
  "source_target_meta_not_null" : 1,
  "contents_infos" : [ {
    "source_key_value" : [ "id=5" ],
    "target_key_value" : [ "id=5" ],
    "select_sql" : "select * from db1.tb1 where id=5",
    "target_select_sql" : "select * from db1.tb1 where id=5"
  } ]
}

Status code: 400

Bad Request

{
  "error_code" : "DRS.10000010",
  "error_msg" : "Task not found. Check the task ID."
}

Status Code

Status Code	Description
200	OK
400	Bad Request

Error Code

For details, see Error Code.

Parent topic: Public API Management

Previous topic: Querying Value Comparison Details

Next topic: Creating an Object-level Comparison Task

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel