Generate export target column mappings¶

Generate export column-mapping suggestions for a MatrixOne target table.

POST https://moi.matrixorigin.cn/newmoi/connectors/mo/column/mapping

Before you call¶

Confirm the target MatrixOne connector, database, and table. Prepare a personal access token, workspace ID, and connector ID.

Request example¶

curl -X POST "https://moi.matrixorigin.cn/newmoi/connectors/mo/column/mapping" \
  -H "X-API-Key: $AI_STUDIO_API_KEY" \
  -H "X-Workspace-ID: $WORKSPACE_ID" \
  -H "Content-Type: application/json" \
  -d "{
    \"connector_id\": \"$CONNECTOR_ID\",
    \"database\": \"analytics\",
    \"table\": \"orders\",
    \"export_columns\": {\"source_id\": \"id\"}
  }"

Request body¶

Parameter	Type	Required	Description
`connector_id`	string	Yes	MatrixOne connector ID.
`database`	string	Yes	Target database name.
`table`	string	Yes	Target table name.
`export_columns`	object	Yes	Mapping of source column names to target column names.

Successful response¶

A successful response returns column-mapping suggestions. Before using them to configure an export task, verify the intended meaning of the source and target columns.

Error response¶

If the connector, database, table, or column mapping is invalid, check the request body and retry.

Last updated on Sep 3, 2026