BladePipe 1.6.0 supports Snowflake, Hologres and CloudBerry.
Skip to main content

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
}