Insert Rows

Creates row inserts 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 insert rows into.

stringrequired

VALUES tuples or a SELECT query to insert.

Uncommon arguments

string

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

string

Optional database to target for the insert statement.

string

Optional comma-separated target columns for the insert statement.

Try this request

Request

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

{
  "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.