Merge Rows

Creates row merges in Firebolt.

POST

Query

Field selectionChoose which fields should be included in the response. Learn more

string

Comma-separated response fields to include.

Body

Arguments

stringrequired

Firebolt user-engine host, for example account-1-mindcloud.api.us-east-1.app.firebolt.io.

stringrequired

Target table to merge into.

stringrequired

USING clause source, such as a SELECT subquery with an alias.

stringrequired

ON clause that matches source rows to target rows.

stringrequired

One or more WHEN clauses that define the merge behavior.

Uncommon arguments

string

Optional user engine name when routing through a shared user-engine host.

string

Optional database to target for the merge statement.

Try this request

Request

curl --request POST \
  --url "https://connect.mindcloud.co/v1/universal/firebolt/0.0.5/actions/merge-rows" \
  --header "Authorization: Bearer $MINDCLOUD_API_TOKEN" \
  --header "Content-Type: application/json" \
  --data '{
  "connectionId": "$CONNECTION_ID",
  "engineHost": "",
  "targetTableName": "",
  "sourceClause": "",
  "joinCondition": "",
  "whenClauses": ""
}'

{
  "success": true,
  "data": [
    {
      "data": [
        {}
      ],
      "meta": [
        {}
      ],
      "query": {},
      "rows": 1,
      "statistics": {}
    }
  ],
  "meta": {}
}

Every app you connect,one REST pattern

Call any app with one REST pattern. MindCloud handles each provider's auth, request shape, and responses for you.

Learn what the Universal API is

One REST patternUse the same request structure across apps like Slack, HubSpot, Salesforce, and thousands more.

Managed connectionsSend a MindCloud connection ID instead of handling provider tokens, refresh logic, and credential storage yourself.

Action-level docsEach action page shows the exact endpoint, required arguments, optional controls, and response behavior for that app version.