Help Center/ Database and Application Migration UGO/ API Reference/ API/ Migration Project/ Querying Syntax Conversion Progress of Objects
Updated on 2023-05-29 GMT+08:00

Querying Syntax Conversion Progress of Objects

Function

This API is used to query syntax conversion progress of objects.

URI

GET /v1/{project_id}/migration-projects/{migration_project_id}/syntax-conversion-progress

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID of a tenant in a region.

For details about how to obtain the project ID, see Obtaining a Project ID.

migration_project_id

Yes

String

Migration project ID.

Request Parameters

Table 2 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token obtained from IAM.

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

total_objects_count

Integer

Total number of objects.

completed_objects_count

Integer

Number of objects whose syntax conversion was complete.

objects_list

Array of Table 4 objects

Objects to be converted.

Table 4 DatabaseObject

Parameter

Type

Description

object_type

String

Object type.

total_count

Long

Total number of objects of this type.

succeed_count

Long

Number of objects that were converted.

failed_count

Long

Number of objects that failed to be converted.

ignored_count

Long

Number of ignored objects.

manual_count

Long

Number of objects that need to be manually modified.

success_rate

String

Success rate.

Example Request

Querying the syntax conversion progress of objects

GET https://{endpoint}/v1/0ac6eb2c8000d2ee2fd9c006dededbe6/migration-projects/220/syntax-conversion-progress

Example Response

Status code: 200

Request succeeded.

{ 
  "total_objects_count" : 11, 
  "completed_objects_count" : 11, 
  "objects_list" : [ { 
    "object_type" : "FUNCTION", 
    "total_count" : 6, 
    "succeed_count" : 6, 
    "failed_count" : 0, 
    "ignored_count" : 0, 
    "manual_count" : 0, 
    "success_rate" : "100.00%" 
  }, { 
    "object_type" : "GRANT", 
    "total_count" : 5, 
    "succeed_count" : 3, 
    "failed_count" : 2, 
    "ignored_count" : 0, 
    "manual_count" : 0, 
    "success_rate" : "60.00%" 
  } ] 
}

Status Codes

Status Code

Description

200

Request succeeded.

Error Codes

For details, see Error Codes.