Help Center/ DataArts Studio/ API Reference/ DataArts Architecture APIs/ Lookup Table Management/ Creating a Lookup Table

Updated on 2024-11-06 GMT+08:00

Online Debugging

CLI Examples

View PDF

Creating a Lookup Table

Function

Create a lookup table.

Calling Method

For details, see Calling APIs.

URI

POST /v2/{project_id}/design/code-tables

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID.

Request Parameters

**Table 2** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	IAM token, which is obtained by calling the IAM API for obtaining a user token (value of X-Subject-Token in the response header). This field is mandatory for authentication using tokens.
workspace	Yes	String	Workspace ID. For details about how to obtain the workspace ID, see Instance ID and Workspace ID.
X-Project-Id	No	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID. This parameter is mandatory for API requests that use AK/SK authentication in multi-project scenarios.
Content-Type	No	String	Default value: application/json;charset=UTF-8 This parameter is optional. If the body is available, this parameter is mandatory. If the body is unavailable, you do not need to set this parameter or verify it.

**Table 3** Request body parameters
Parameter	Mandatory	Type	Description
id	No	String	Code table ID. The value is of the String type instead of the Long type.
name_en	Yes	String	Table name, in English.
name_ch	Yes	String	Table name, in Chinese.
tb_version	No	Integer	Table version.
directory_id	Yes	String	Directory ID. The value of this parameter is of the String type instead of the Long type.
directory_path	No	String	Directory tree.
description	No	String	Description.
create_by	No	String	Creator.
status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_info	No	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	No	BizVersionManageVO object	Service version management. This parameter is read-only.
code_table_fields	Yes	Array of CodeTableFieldVO objects	Code list attribute information.

**Table 4** ApprovalVO
Parameter	Mandatory	Type	Description
id	No	String	Application ID. The value of this parameter is of the String type instead of the Long type.
tenant_id	No	String	Project ID. For details about how to obtain the project ID, see the API path parameter project_id.
name_ch	No	String	Chinese name of a service.
name_en	No	String	English name of a service.
biz_id	No	String	Service ID. The value is of the String type instead of the Long type.
biz_type	No	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_info	No	String	Serialized service details. The type is string.
biz_info_obj	No	Object	Service details. The type is object.
biz_version	No	Integer	Service version.
biz_status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_status	No	String	Service approval status. This parameter is read-only. Options: DEVELOPING: being reviewed APPROVED: approved REJECT: rejected WITHDREW: approval cancellation
approval_type	No	String	Service review type. Options: PUBLISH: released OFFLINE: offline
submit_time	No	String	Submitted At
create_by	No	String	Creator.
l1	No	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	No	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	No	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_time	No	String	Review time.
approver	No	String	Reviewer.
email	No	String	Email address of the reviewer.
msg	No	String	Review information.
directory_path	No	String	Directory tree.

**Table 5** BizVersionManageVO
Parameter	Mandatory	Type	Description
id	No	String	ID information. The value of this parameter is of the String type instead of the Long type.
biz_type	No	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_id	No	String	Service ID. The value is of the String type instead of the Long type.
biz_info	No	String	Business object information.
status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected

**Table 6** CodeTableFieldVO
Parameter	Mandatory	Type	Description
id	No	String	Field ID in the code table. The value is of the String type instead of the Long type.
code_table_id	No	String	Code table ID. The value is of the string type instead of the long type.
ordinal	Yes	Integer	Sequence number.
name_en	Yes	String	Field name, in English.
name_ch	Yes	String	Field name, in Chinese.
description	No	String	Description.
data_type	Yes	String	Field type
data_type_extend	No	String	Extended field of the data type.
is_unique_key	No	Boolean	Whether the field is unique.
code_table_field_values	No	Array of CodeTableFieldValueVO objects	Code list attribute value.
count_field_values	No	Integer	Total number of lookup table attribute values.

**Table 7** CodeTableFieldValueVO
Parameter	Mandatory	Type	Description
id	No	String	Field ID in the code table. The value is of the String type instead of the Long type.
fd_id	No	String	Attribute ID of the code table. The value is of the String type instead of the Long type.
fd_value	No	String	Code list attribute value.
ordinal	No	Integer	Sequence number.
description	No	String	Description.

Response Parameters

Status code: 200

**Table 8** Response body parameters
Parameter	Type	Description
data	data object	data: unified outermost data structure of the returned result.

**Table 9** data
Parameter	Type	Description
value	CodeTableVO object	Code table structure.

**Table 10** CodeTableVO
Parameter	Type	Description
id	String	Code table ID. The value is of the String type instead of the Long type.
name_en	String	Table name, in English.
name_ch	String	Table name, in Chinese.
tb_version	Integer	Table version.
directory_id	String	Directory ID. The value of this parameter is of the String type instead of the Long type.
directory_path	String	Directory tree.
description	String	Description.
create_by	String	Creator.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
approval_info	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.
code_table_fields	Array of CodeTableFieldVO objects	Code list attribute information.

**Table 11** ApprovalVO
Parameter	Type	Description
id	String	Application ID. The value of this parameter is of the String type instead of the Long type.
tenant_id	String	Project ID. For details about how to obtain the project ID, see the API path parameter project_id.
name_ch	String	Chinese name of a service.
name_en	String	English name of a service.
biz_id	String	Service ID. The value is of the String type instead of the Long type.
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_info	String	Serialized service details. The type is string.
biz_info_obj	Object	Service details. The type is object.
biz_version	Integer	Service version.
biz_status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_status	String	Service approval status. This parameter is read-only. Options: DEVELOPING: being reviewed APPROVED: approved REJECT: rejected WITHDREW: approval cancellation
approval_type	String	Service review type. Options: PUBLISH: released OFFLINE: offline
submit_time	String	Submitted At
create_by	String	Creator.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_time	String	Review time.
approver	String	Reviewer.
email	String	Email address of the reviewer.
msg	String	Review information.
directory_path	String	Directory tree.

**Table 12** BizVersionManageVO
Parameter	Type	Description
id	String	ID information. The value of this parameter is of the String type instead of the Long type.
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_id	String	Service ID. The value is of the String type instead of the Long type.
biz_info	String	Business object information.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
biz_version	Integer	Service version, which is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.

**Table 13** CodeTableFieldVO
Parameter	Type	Description
id	String	Field ID in the code table. The value is of the String type instead of the Long type.
code_table_id	String	Code table ID. The value is of the string type instead of the long type.
ordinal	Integer	Sequence number.
name_en	String	Field name, in English.
name_ch	String	Field name, in Chinese.
description	String	Description.
data_type	String	Field type
domain_type	String	Domain to which a field type belongs. Options: NUMBER: number STRING: character type DATETIME: date type BLOB: large object (BLOB) OTHER: other types
data_type_extend	String	Extended field of the data type.
is_unique_key	Boolean	Whether the field is unique.
code_table_field_values	Array of CodeTableFieldValueVO objects	Code list attribute value.
count_field_values	Integer	Total number of lookup table attribute values.

**Table 14** CodeTableFieldValueVO
Parameter	Type	Description
id	String	Field ID in the code table. The value is of the String type instead of the Long type.
fd_id	String	Attribute ID of the code table. The value is of the String type instead of the Long type.
fd_value	String	Code list attribute value.
ordinal	Integer	Sequence number.
description	String	Description.

Status code: 400

**Table 15** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 401

**Table 16** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 403

**Table 17** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 404

**Table 18** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Example Requests

This API is used to create a lookup table based on the request parameters and save the table as a draft. The information about the successfully created lookup table is returned.

POST https://{endpoint}/v2/{project_id}/design/code-tables

{
  "name_en" : "",
  "name_ch" : "test_create_code_table",
  "description" : "",
  "code_table_fields" : [ {
    "ordinal" : 1,
    "name_ch" : "Message",
    "name_en" : "code",
    "data_type" : "STRING",
    "description" : "",
    "code_table_field_values" : [ ]
  }, {
    "ordinal" : 2,
    "name_ch" : "Economical",
    "name_en" : "province",
    "data_type" : "STRING",
    "description" : "",
    "code_table_field_values" : [ ]
  }, {
    "ordinal" : 3,
    "name_ch" : "Specifies the city where the customer is located.",
    "name_en" : "city",
    "data_type" : "STRING",
    "description" : "",
    "code_table_field_values" : [ ]
  }, {
    "ordinal" : 4,
    "name_ch" : "County",
    "name_en" : "county",
    "data_type" : "STRING",
    "description" : "",
    "code_table_field_values" : [ ]
  } ],
  "tb_version" : 0,
  "directory_id" : "1194963842254491648"
}

Example Responses

Status code: 200

This operation succeeds, and the returned data is CodeTableVO.

{
  "data" : {
    "value" : {
      "id" : "1230204979835502592",
      "name_en" : "DC000007",
      "name_ch" : "test_create_code_table",
      "tb_version" : 0,
      "directory_id" : "1194963842254491648",
      "directory_path" : null,
      "description" : "",
      "create_by" : "ei_dayu_y00321344_01",
      "status" : "DRAFT",
      "create_time" : "2024-04-17T17:15:23.296+08:00",
      "update_time" : "2024-04-17T17:15:23.296+08:00",
      "approval_info" : null,
      "new_biz" : null,
      "code_table_fields" : [ {
        "id" : null,
        "code_table_id" : null,
        "ordinal" : 1,
        "name_en" : "code",
        "name_ch" : "Status",
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : null,
        "data_type_extend" : null,
        "is_unique_key" : false,
        "code_table_field_values" : [ ],
        "count_field_values" : null
      }, {
        "id" : null,
        "code_table_id" : null,
        "ordinal" : 2,
        "name_en" : "province",
        "name_ch" : "Economical",
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : null,
        "data_type_extend" : null,
        "is_unique_key" : false,
        "code_table_field_values" : [ ],
        "count_field_values" : null
      }, {
        "id" : null,
        "code_table_id" : null,
        "ordinal" : 3,
        "name_en" : "city",
        "name_ch" : "City",
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : null,
        "data_type_extend" : null,
        "is_unique_key" : false,
        "code_table_field_values" : [ ],
        "count_field_values" : null
      }, {
        "id" : null,
        "code_table_id" : null,
        "ordinal" : 4,
        "name_en" : "county",
        "name_ch" : "County",
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : null,
        "data_type_extend" : null,
        "is_unique_key" : false,
        "code_table_field_values" : [ ],
        "count_field_values" : null
      } ]
    }
  }
}

Status code: 400

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user request is illegal."
}

Status code: 401

{
  "error_code" : "DS.60xx",
  "error_msg" : "User authentication failed."
}

Status code: 403

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user does not have permission to call this API."
}

Status code: 404

{
  "error_code" : "DS.60xx",
  "error_msg" : "The User Request API does not exist."
}

SDK Sample Code

The SDK sample code is as follows.

This API is used to create a lookup table based on the request parameters and save the table as a draft. The information about the successfully created lookup table is returned.

      
       
         
         
           package com.huaweicloud.sdk.test;

import com.huaweicloud.sdk.core.auth.ICredential;
import com.huaweicloud.sdk.core.auth.BasicCredentials;
import com.huaweicloud.sdk.core.exception.ConnectionException;
import com.huaweicloud.sdk.core.exception.RequestTimeoutException;
import com.huaweicloud.sdk.core.exception.ServiceResponseException;
import com.huaweicloud.sdk.dataartsstudio.v1.region.DataArtsStudioRegion;
import com.huaweicloud.sdk.dataartsstudio.v1.*;
import com.huaweicloud.sdk.dataartsstudio.v1.model.*;

import java.util.List;
import java.util.ArrayList;

public class CreateCodeTableSolution {

    public static void main(String[] args) {
        // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
        // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
        String ak = System.getenv("CLOUD_SDK_AK");
        String sk = System.getenv("CLOUD_SDK_SK");
        String projectId = "{project_id}";

        ICredential auth = new BasicCredentials()
                .withProjectId(projectId)
                .withAk(ak)
                .withSk(sk);

        DataArtsStudioClient client = DataArtsStudioClient.newBuilder()
                .withCredential(auth)
                .withRegion(DataArtsStudioRegion.valueOf("<YOUR REGION>"))
                .build();
        CreateCodeTableRequest request = new CreateCodeTableRequest();
        CodeTableVO body = new CodeTableVO();
        List<CodeTableFieldVO> listbodyCodeTableFields = new ArrayList<>();
        listbodyCodeTableFields.add(
            new CodeTableFieldVO()
                .withOrdinal(1)
                .withNameEn("code")
                .withNameCh("Message")
                .withDescription("")
                .withDataType("STRING")
                .withCodeTableFieldValues()
        );
        listbodyCodeTableFields.add(
            new CodeTableFieldVO()
                .withOrdinal(2)
                .withNameEn("province")
                .withNameCh("Economical")
                .withDescription("")
                .withDataType("STRING")
                .withCodeTableFieldValues()
        );
        listbodyCodeTableFields.add(
            new CodeTableFieldVO()
                .withOrdinal(3)
                .withNameEn("city")
                .withNameCh("Specifies the city where the customer is located.")
                .withDescription("")
                .withDataType("STRING")
                .withCodeTableFieldValues()
        );
        listbodyCodeTableFields.add(
            new CodeTableFieldVO()
                .withOrdinal(4)
                .withNameEn("county")
                .withNameCh("County")
                .withDescription("")
                .withDataType("STRING")
                .withCodeTableFieldValues()
        );
        body.withCodeTableFields(listbodyCodeTableFields);
        body.withDescription("");
        body.withDirectoryId("1194963842254491648");
        body.withTbVersion(0);
        body.withNameCh("test_create_code_table");
        body.withNameEn("");
        request.withBody(body);
        try {
            CreateCodeTableResponse response = client.createCodeTable(request);
            System.out.println(response.toString());
        } catch (ConnectionException e) {
            e.printStackTrace();
        } catch (RequestTimeoutException e) {
            e.printStackTrace();
        } catch (ServiceResponseException e) {
            e.printStackTrace();
            System.out.println(e.getHttpStatusCode());
            System.out.println(e.getRequestId());
            System.out.println(e.getErrorCode());
            System.out.println(e.getErrorMsg());
        }
    }
}

          

        

      
     

This API is used to create a lookup table based on the request parameters and save the table as a draft. The information about the successfully created lookup table is returned.

      
       
         
         
           # coding: utf-8

import os
from huaweicloudsdkcore.auth.credentials import BasicCredentials
from huaweicloudsdkdataartsstudio.v1.region.dataartsstudio_region import DataArtsStudioRegion
from huaweicloudsdkcore.exceptions import exceptions
from huaweicloudsdkdataartsstudio.v1 import *

if __name__ == "__main__":
    # The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    # In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak = os.environ["CLOUD_SDK_AK"]
    sk = os.environ["CLOUD_SDK_SK"]
    projectId = "{project_id}"

    credentials = BasicCredentials(ak, sk, projectId)

    client = DataArtsStudioClient.new_builder() \
        .with_credentials(credentials) \
        .with_region(DataArtsStudioRegion.value_of("<YOUR REGION>")) \
        .build()

    try:
        request = CreateCodeTableRequest()
        listCodeTableFieldsbody = [
            CodeTableFieldVO(
                ordinal=1,
                name_en="code",
                name_ch="Message",
                description="",
                data_type="STRING",
            ),
            CodeTableFieldVO(
                ordinal=2,
                name_en="province",
                name_ch="Economical",
                description="",
                data_type="STRING",
            ),
            CodeTableFieldVO(
                ordinal=3,
                name_en="city",
                name_ch="Specifies the city where the customer is located.",
                description="",
                data_type="STRING",
            ),
            CodeTableFieldVO(
                ordinal=4,
                name_en="county",
                name_ch="County",
                description="",
                data_type="STRING",
            )
        ]
        request.body = CodeTableVO(
            code_table_fields=listCodeTableFieldsbody,
            description="",
            directory_id="1194963842254491648",
            tb_version=0,
            name_ch="test_create_code_table",
            name_en=""
        )
        response = client.create_code_table(request)
        print(response)
    except exceptions.ClientRequestException as e:
        print(e.status_code)
        print(e.request_id)
        print(e.error_code)
        print(e.error_msg)

          

        

      
     

This API is used to create a lookup table based on the request parameters and save the table as a draft. The information about the successfully created lookup table is returned.

      
       
         
         
           package main

import (
	"fmt"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/core/auth/basic"
    dataartsstudio "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1"
	"github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1/model"
    region "github.com/huaweicloud/huaweicloud-sdk-go-v3/services/dataartsstudio/v1/region"
)

func main() {
    // The AK and SK used for authentication are hard-coded or stored in plaintext, which has great security risks. It is recommended that the AK and SK be stored in ciphertext in configuration files or environment variables and decrypted during use to ensure security.
    // In this example, AK and SK are stored in environment variables for authentication. Before running this example, set environment variables CLOUD_SDK_AK and CLOUD_SDK_SK in the local environment
    ak := os.Getenv("CLOUD_SDK_AK")
    sk := os.Getenv("CLOUD_SDK_SK")
    projectId := "{project_id}"

    auth := basic.NewCredentialsBuilder().
        WithAk(ak).
        WithSk(sk).
        WithProjectId(projectId).
        Build()

    client := dataartsstudio.NewDataArtsStudioClient(
        dataartsstudio.DataArtsStudioClientBuilder().
            WithRegion(region.ValueOf("<YOUR REGION>")).
            WithCredential(auth).
            Build())

    request := &model.CreateCodeTableRequest{}
	descriptionCodeTableFields:= ""
	descriptionCodeTableFields1:= ""
	descriptionCodeTableFields2:= ""
	descriptionCodeTableFields3:= ""
	var listCodeTableFieldsbody = []model.CodeTableFieldVo{
        {
            Ordinal: int32(1),
            NameEn: "code",
            NameCh: "Message",
            Description: &descriptionCodeTableFields,
            DataType: "STRING",
        },
        {
            Ordinal: int32(2),
            NameEn: "province",
            NameCh: "Economical",
            Description: &descriptionCodeTableFields1,
            DataType: "STRING",
        },
        {
            Ordinal: int32(3),
            NameEn: "city",
            NameCh: "Specifies the city where the customer is located.",
            Description: &descriptionCodeTableFields2,
            DataType: "STRING",
        },
        {
            Ordinal: int32(4),
            NameEn: "county",
            NameCh: "County",
            Description: &descriptionCodeTableFields3,
            DataType: "STRING",
        },
    }
	descriptionCodeTableVo:= ""
	tbVersionCodeTableVo:= int32(0)
	request.Body = &model.CodeTableVo{
		CodeTableFields: listCodeTableFieldsbody,
		Description: &descriptionCodeTableVo,
		DirectoryId: "1194963842254491648",
		TbVersion: &tbVersionCodeTableVo,
		NameCh: "test_create_code_table",
		NameEn: "",
	}
	response, err := client.CreateCodeTable(request)
	if err == nil {
        fmt.Printf("%+v\n", response)
    } else {
        fmt.Println(err)
    }
}

          

        

      
     