BladePipe 1.6.0 supports Snowflake, Hologres and CloudBerry.
跳到主要内容

Upsert KV Config (MCP Format)

Interface Overview

Batch upsert task KV configurations by task ID. This has the same functionality as /upsertkvconfigs, but the request body wraps the array in an object ({ "configs": [...] }) for easier MCP tool invocation.

Interface Address

/cloudcanal/console/api/v1/openapi/datajob/upsertkvconfig_mcp

Request Manner

POST

Request Parameters

ParameterNameParameter DescriptionRequestTypeWhether RequiredDataType
configsKV configuration listbodyTruearray

Each element in the configs array has the following fields:

ParameterNameParameter DescriptionRequestTypeWhether RequiredDataType
dataJobIdDataJob IDbodyTruelong
configNameConfiguration namebodyTruestring
configValueConfiguration value. Cannot be empty for parameters with default values.bodyFalsestring
endPointTypeEndpoint type

SOURCE
TARGET
INDEPENDENT
bodyTruestring
configTypeConfiguration entity type

SERVER_CORE (task)
DATASOURCE (data source)
MAPPING (metadata mapping)
bodyTruestring
needCreateWhether this configuration does not yet exist in the task (new version config)bodyFalseboolean

Request Example

{
"configs": [
{
"configName": "ddlExceptionSkip",
"configType": "SERVER_CORE",
"configValue": "true",
"dataJobId": 956,
"endPointType": "INDEPENDENT",
"needCreate": false
},
{
"configName": "specId",
"configType": "SERVER_CORE",
"configValue": "17",
"dataJobId": 956,
"endPointType": "INDEPENDENT",
"needCreate": false
}
]
}

Public Response Results

ParameterNameParameter DescriptionType(Java)NotNull
code1: Success, 0: FailurestringTrue
dataobjectFalse
msgstringFalse
requestIdstringTrue

Response Example

{
"requestId": "c5665d7c-2cb7-11ec-a410-bfd57df2q1ea",
"code": "1",
"msg": "request success",
"data": null
}