All Products
Search
Document Center

Data Management:GetDataArchiveOrderDetail

最終更新日:Oct 21, 2024

Queries the details of a data archiving ticket, including the time when the ticket was created, the scheduling information of the data archiving task, the logs of the data archiving task, and the database to which data is archived.

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Authorization information

There is currently no authorization information disclosed in the API.

Request parameters

ParameterTypeRequiredDescriptionExample
OrderIdlongYes

The IDs of data archiving tickets.

868****
TidlongNo

The tenant ID.

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.
5***

Response parameters

ParameterTypeDescriptionExample
object
TraceIdstring

Tracks service requests.

0a06e1e316757357507896067d3780
Successboolean

Indicates whether the request was successful. Valid values:

  • true
  • false
true
ErrorMessagestring

The error message that is returned if the request failed.

User [19929582****] not exist
ErrorCodestring

The error code returned if the call failed.

NoPermission
RequestIdstring

The ID of the request, which is used to query logs and troubleshoot issues.

4161CE36-28DF-5191-8A6F-A17076A0B124
DataArchiveOrderDetailobject

The details of data archiving tickets.

Commentstring

The description of the data archiving tickets.

Archiving of test results
Committerstring

The user who submitted the ticket.

dmstest
CommitterIdlong

The ID of the user who submitted the ticket. The ID is a user ID and not the ID of an Alibaba Cloud account.

26***
GmtCreatestring

The time when the ticket was created.

2023-05-15 16:00:48
GmtModifiedstring

The time when the ticket was last modified.

2023-05-23 16:00:48
Idlong

The ID of data archiving tickets.

868****
PluginExtraDataobject

The additional information about the ticket.

DagInfoobject

The information about the workflow.

CreatorIdstring

The ID of the user who created the task flow.

59****
CronBeginDatestring

The start time for scheduling. The task flow is not scheduled before this point in time.

1970-01-01
CronEndDatestring

The end time for scheduling. The task flow is not scheduled after this point in time.

9999-01-01
CronTriggerboolean

Indicates whether the archiving task is a scheduled task. Valid values:

  • true
  • false
false
DWDevelopboolean

Indicates whether the task is used to develop warehouses.

Note This field is a retained field that is not in use.
false
DagNamestring

The name of the workflow.

data-archive-9099197
DagOwnerIdstring

The ID of the owner of the workflow.

13****
DeployIdlong

The ID of the deployment record.

93***
Descriptionstring

The description of the workflow.

order id:9099197
EditDagIdlong

The ID of the editable workflow version.

24***
GmtCreatestring

The time when the workflow was created.

2023-05-15 16:00:48
GmtModifiedstring

The time when the workflow was last modified.

2023-06-15 16:00:48
Idlong

The ID of the task flow.

24***
IsPubliclong

Indicates whether the workflow is public. Valid values:

  • 0: not public.
  • 1: public.
0
Legacyboolean

Indicates whether the task is a historical task. Valid values:

  • true
  • false
false
Systemboolean

Indicates whether the task was created by the system. Valid values:

  • true
  • false
false
TenantIdstring

The tenant ID.

5***
TriggerOnceboolean

Indicates whether the workflow is triggered to run once. Valid values:

  • true
  • false
false
DbBaseInfoobject

The database information related to data archiving tickets.

Aliasstring

The alias of the database instance.

tf-testAccDMSEnterpriseLogicDatabase853****
AlterTimeoutlong

The timeout period of queries on the database.

600
AssetControlboolean

Indicates whether access control is enabled for data assets. Valid values:

  • true
  • false
true
CatalogNamestring

The name of the instance in the instance list.

test
ClusterNodestring

Indicates whether the instance is added to the DMS whitelist.

whitelist_done
DbIdlong

The ID of the database. You can call the SearchDatabase operation to query the ID of the database.

Note You can call the ListDatabases operation to query the ID of a physical database or the ListLogicDatabases operation to query the ID of a logical database.
348****
DbTypestring

The type of the database. For information about the valid values of this parameter, see DbType parameter.

MySQL
DbaIdlong

The ID of the database administrator (DBA) of the instance.

16****
DbaNamestring

The nickname of the DBA of the instance.

DBA
Descriptionstring

The complete endpoint of the database.

test@rm-2ze756u8837****.mysql.rds.aliyuncs.com:3306 [test]
Encodingstring

The encoding format of the database.

utf8
EnvTypestring

The type of the environment to which the database belongs. Valid values:

  • product: production environment
  • dev: development environment
  • pre: staging environment
  • test: test environment
  • sit: system integration testing (SIT) environment
  • uat: user acceptance testing (UAT) environment
  • pet: stress testing environment
  • stag: STAG environment
product
Followboolean

Indicates whether the instance needs special attention. Valid values:

  • true
  • false
false
Hoststring

The endpoint that is used to connect to the database.

rm-2ze756u8837****.mysql.rds.aliyuncs.com
Idcstring

The region in which the database instance resides.

cn-beijing
IdcTitlestring

The name of the region in which the database instance resides.

cn-beijing
InstanceIdlong

The ID of the instance to which the database belongs.

175****
InstanceSourcestring

The source of the database instance.Valid values:

  • RDS: an ApsaraDB RDS instance.
  • ECS_OWN: a self-managed database deployed on an Elastic Compute Service (ECS) instance.
  • PUBLIC_OWN: a self-managed database instance that is connected over the Internet.
  • VPC_ID: a self-managed database instance in a virtual private cloud (VPC) that is connected over Express Connect circuits.
  • GATEWAY: a database instance connected by using a database gateway.
RDS
LastSyncTimestring

The time when the database information was last obtained.

2023-05-14 18:34:45
Levelstring

The instance level.

medium
Logicboolean

Indicates whether the database is logical. Valid values:

  • true
  • false
false
OwnerIdsarray

The IDs of the owners of the databases, which are stored as an array. You can call the GetUser or ListUsers operation to query the IDs of the owners.

Note The value of OwnerIds is the same as the value of UserId
OwnerIdslong

The ID of the owner of the instance.

77****
OwnerNamesarray

The usernames of the database owners.

OwnerNamesstring

The username of the database owner.

day
Portlong

The port that is used to connect to the database.

3306
SchemaNamestring

The name of the database.

test
SearchNamestring

The name that is used to search for the database.

test@rm-2ze756u8837****.mysql.rds.aliyuncs.com:3306 [test]
StandardGroupobject

The details of the control mode of the instance.

DbTypestring

The type of the instance engine. For information about the valid values of this parameter, see DbType parameter.

MySQL
Descriptionstring

The description of the security rule set.

adb_mysql default
FreeOrStableboolean

Indicates whether the instance is managed in Flexible Management or Stable Change mode. Valid values:

  • true
  • false
false
GmtCreatestring

The time when the security rule was created.

2020-05-24 14:12:32
GmtModifiedstring

The time when the security rule was last modified.

2020-05-25 14:12:32
GroupModestring

The type of the control mode of the instance. Valid values:

  • COMMON: The instance is managed in Security Collaboration mode.
  • NONE_CONTROL: The instance is managed in Flexible Management mode.
  • STABLE: The instance is managed in Stable Change mode.
COMMON
GroupNamestring

The name of the security rule that corresponds to the control mode.

adb_mysql default
Idlong

The ID of the security rule.

24***
LastMenderIdlong

The user ID of the last modified security rule.

12****
Statestring

The status of the database. Valid values:

  • NORMAL: The database is running as expected.
  • DISABLE: The database is disabled.
  • OFFLINE: The database is unpublished.
  • NOT_EXIST: The database does not exist.
NORMAL
TableCountlong

The number of tables.

201
TnsNamestring

The name of TNS.

TNS_4010
UnitTypestring

The unit type.

-1
InstanceTotallong

The total number of archiving tasks.

2
Instancesarray<object>

The list of archiving tasks.

Instancesobject
BusinessTimestring

The business time of the task flow. The time is displayed in the yyyy-MM-DD HH:mm:ss format.

2023-05-14 16:00:57
DagIdlong

The task flow ID. You can call the ListTaskFlow or ListLhTaskFlowAndScenario operation to obtain the value of this parameter.

37***
EndTimestring

The time when the task flow ended. The time is displayed in the yyyy-MM-DD HH:mm:ss format.

2022-06-04 15:14:00
GmtCreatestring

The time when the task flow was created.

2023-05-14 16:00:57
GmtModifiedstring

The time when the task flow was last modified.

2023-05-14 16:00:57
HistoryDagIdlong

The ID of the historical task flow.

32***
Idlong

The ID of the instance in the task flow that is executed.

24***
LastRunningContextstring

The context of the previous execution of the task flow.

{ "nodes": [ 48** ], "edges": {} }
Msgstring

The context of the current execution of the task flow.

2023-05-15 16:37:48[GMT+08:00] INFO - Resource Control is active!\n2023-05-15 16:37:48[GMT+08:00] INFO - Starting job j_4834 at Mon May 15 16:37:48 CST 2023
Statuslong

The status of the task. Valid values:

  • 0: The task is waiting for execution.
  • 1: The task is in progress.
  • 2: The task is suspended.
  • 3: The task failed.
  • 4: The task is successful.
  • 5: The task is complete.
4
TenantIdstring

The tenant ID.

5***
TriggerTypelong

The mode in which the task flow was triggered. Valid values:

  • 0: The task flow was triggered based on a schedule.
  • 1: The task flow was manually triggered.
1
Versionstring

The version number.

1
NextFireTimeResultobject

The time when the next task is triggered.

CronFireTypestring

The type of scheduled triggering.

NOT_SET
PageIndexlong

The page number.

10
PageSizelong

The number of entries per page.

20
TempTableNameMapobject

The name of the temporary table that is generated by the archiving task (indicated by the archiving task ID).

{ "803***": [ "tmp_dms_21321_20230704144336_temp_test_check" ] }
PluginParamobject

The ticket creation parameter. The value is a JSON string. For more information, see PluginType parameter.

ArchiveMethodstring

The type of the archiving destination.

inner_oss
DbSchemastring

The schema of the database and table to be archived.

test
Logicboolean

Indicates whether the database is logical.

  • true
  • false
true
OrderAfterarray

The post behavior of archiving.

AfterOrderstring

The post behavior of archiving. The post behavior is to use the DELETE statement to clean up the table.

delete
RunMethodstring

The running method, which indicates whether to run the task immediately or at a specific point in time.

now
SourceDatabaseIdlong

The ID of the source database.

12***
TableIncludesarray<object>

The list of the archived tables and the filter conditions.

IncludeTablesobject
TableNamestring

The table name.

tm_insured_cb
TableWherestring

The filter condition.

id<1000 or gmt_create<'2023-05-14 16:00:57'
TableMappingarray

The mapping of schemas.

MappingTablestring

The mapping of the source table name, source column name, destination table name, and destination column name.

{ "schema": "oracle_info", "tarTb": "eoa_context_test", "tbPartKey": [], "oriTb": "eoa_context", "columns": [ { "tName": "dbid_test", "oName": "dbid" } ], "dbPartKey": [], "customPk": [ "id" ] }
TargetInstanceIdstring

The ID of the destination instance.

12***
Variablesarray

The time variable defined for scheduled archiving.

Variablesstring

The time variable that calculates an offset based on the previous day of the current time.

{ "name": "test", "pattern": "yyyy-MM-dd|-10d" }
PluginTypestring

The plug-in type that corresponds to the type of the ticket. The plug-in type for data archiving is DATA_ARCHIVE. For more information, see PluginType parameter.

DATA_ARCHIVE
RelatedUserListarray

The user IDs related to the ticket.

RelatedUserListlong

The user IDs related to the ticket.

65****
RelatedUserNickListarray

The nicknames of the users that are related to the ticket.

RelatedUserNickListstring

The nickname of the user that is related to the ticket.

publicyuhzou
StatusCodestring

The status code of the ticket. Valid values:

  • new: newly created.
  • toaudit: being reviewed.
  • Approved: approved.
  • reject: rejected.
  • processing: being executed.
  • Success: successful.
  • closed: disabled.
processing
StatusDescstring

The status description of the ticket.

a ticket task is being executed.
WorkflowInstanceIdlong

The ID of the approval process. You can call the GetOrderBaseInfo operation to obtain the ID of the approval process.

29****
WorkflowStatusDescstring

The description of the approval process.

approved

Examples

Sample success responses

JSONformat

{
  "TraceId": "0a06e1e316757357507896067d3780",
  "Success": true,
  "ErrorMessage": "User [19929582****] not exist",
  "ErrorCode": "NoPermission",
  "RequestId": "4161CE36-28DF-5191-8A6F-A17076A0B124",
  "DataArchiveOrderDetail": {
    "Comment": "Archiving of test results",
    "Committer": "dmstest",
    "CommitterId": 0,
    "GmtCreate": "2023-05-15 16:00:48",
    "GmtModified": "2023-05-23 16:00:48",
    "Id": 0,
    "PluginExtraData": {
      "DagInfo": {
        "CreatorId": "59****",
        "CronBeginDate": "1970-01-01",
        "CronEndDate": "9999-01-01",
        "CronTrigger": false,
        "DWDevelop": false,
        "DagName": "data-archive-9099197",
        "DagOwnerId": "13****",
        "DeployId": 0,
        "Description": "order id:9099197",
        "EditDagId": 0,
        "GmtCreate": "2023-05-15 16:00:48",
        "GmtModified": "2023-06-15 16:00:48",
        "Id": 0,
        "IsPublic": 0,
        "Legacy": false,
        "System": false,
        "TenantId": "5***",
        "TriggerOnce": false
      },
      "DbBaseInfo": {
        "Alias": "tf-testAccDMSEnterpriseLogicDatabase853****",
        "AlterTimeout": 600,
        "AssetControl": true,
        "CatalogName": "test",
        "ClusterNode": "whitelist_done",
        "DbId": 0,
        "DbType": "MySQL",
        "DbaId": 0,
        "DbaName": "DBA",
        "Description": "test@rm-2ze756u8837****.mysql.rds.aliyuncs.com:3306 [test]",
        "Encoding": "utf8",
        "EnvType": "product",
        "Follow": false,
        "Host": "rm-2ze756u8837****.mysql.rds.aliyuncs.com",
        "Idc": "cn-beijing",
        "IdcTitle": "cn-beijing",
        "InstanceId": 0,
        "InstanceSource": "RDS",
        "LastSyncTime": "2023-05-14 18:34:45",
        "Level": "medium",
        "Logic": false,
        "OwnerIds": [
          0
        ],
        "OwnerNames": [
          "day"
        ],
        "Port": 3306,
        "SchemaName": "test",
        "SearchName": "test@rm-2ze756u8837****.mysql.rds.aliyuncs.com:3306 [test]",
        "StandardGroup": {
          "DbType": "MySQL",
          "Description": "adb_mysql default",
          "FreeOrStable": false,
          "GmtCreate": "2020-05-24 14:12:32",
          "GmtModified": "2020-05-25 14:12:32",
          "GroupMode": "COMMON",
          "GroupName": "adb_mysql default",
          "Id": 0,
          "LastMenderId": 0
        },
        "State": "NORMAL",
        "TableCount": 201,
        "TnsName": "TNS_4010",
        "UnitType": "-1"
      },
      "InstanceTotal": 2,
      "Instances": [
        {
          "BusinessTime": "2023-05-14 16:00:57",
          "DagId": 0,
          "EndTime": "2022-06-04 15:14:00",
          "GmtCreate": "2023-05-14 16:00:57",
          "GmtModified": "2023-05-14 16:00:57",
          "HistoryDagId": 0,
          "Id": 0,
          "LastRunningContext": "{\n      \"nodes\": [\n            48**\n      ],\n      \"edges\": {}\n}",
          "Msg": "2023-05-15 16:37:48[GMT+08:00] INFO - Resource Control is active!\\n2023-05-15 16:37:48[GMT+08:00] INFO - Starting job j_4834 at Mon May 15 16:37:48 CST 2023",
          "Status": 4,
          "TenantId": "5***",
          "TriggerType": 1,
          "Version": "1"
        }
      ],
      "NextFireTimeResult": {
        "CronFireType": "NOT_SET"
      },
      "PageIndex": 10,
      "PageSize": 20,
      "TempTableNameMap": {
        "803***": [
          "tmp_dms_21321_20230704144336_temp_test_check"
        ]
      }
    },
    "PluginParam": {
      "ArchiveMethod": "inner_oss",
      "DbSchema": "test",
      "Logic": true,
      "OrderAfter": [
        "delete"
      ],
      "RunMethod": "now",
      "SourceDatabaseId": 0,
      "TableIncludes": [
        {
          "TableName": "tm_insured_cb",
          "TableWhere": "id<1000 or gmt_create<'2023-05-14 16:00:57'"
        }
      ],
      "TableMapping": [
        "{\n                    \"schema\": \"oracle_info\",\n                    \"tarTb\": \"eoa_context_test\",\n                    \"tbPartKey\": [],\n                    \"oriTb\": \"eoa_context\",\n                    \"columns\": [\n                        {\n                            \"tName\": \"dbid_test\",\n                            \"oName\": \"dbid\"\n                        }\n                    ],\n                    \"dbPartKey\": [],\n                    \"customPk\": [\n                        \"id\"\n                    ]\n                }"
      ],
      "TargetInstanceId": "12***",
      "Variables": [
        "{\n                    \"name\": \"test\",\n                    \"pattern\": \"yyyy-MM-dd|-10d\"\n                }"
      ]
    },
    "PluginType": "DATA_ARCHIVE",
    "RelatedUserList": [
      0
    ],
    "RelatedUserNickList": [
      "publicyuhzou"
    ],
    "StatusCode": "processing",
    "StatusDesc": "a ticket task is being executed.",
    "WorkflowInstanceId": 0,
    "WorkflowStatusDesc": "approved"
  }
}

Error codes

For a list of error codes, visit the Service error codes.

Change history

Change timeSummary of changesOperation
2023-07-06The response structure of the API has changedView Change Details