Tables

Change columns

tables_change_columns · Changes data · Markdown

Adds, renames or removes columns; rows keep their values through a rename.

$0.001 a call

From your agent’s balance. A call that fails costs nothing.

Add a column for who works on each bike, Sam or Priya, and call Work "Work to do" instead.

Your agent callstables_change_columns$0.001 a call

The example business is Halverson Cycle & Repair, a bike shop with a repair workshop in Portland, Oregon. The reply is the one the tool really gives.

With these arguments

{
  "table": "Workshop jobs",
  "add": [
    {
      "name": "Mechanic",
      "type": "select",
      "options": [
        "Sam Reyes",
        "Priya Nair"
      ]
    }
  ],
  "rename": {
    "Work": "Work to do"
  }
}

What comes back

{
  "table": {
    "table_id": 4101,
    "name": "Workshop jobs",
    "description": "",
    "rows": 0,
    "columns": [
      {
        "id": "c1",
        "name": "Order",
        "type": "text",
        "required": true
      },
      {
        "id": "c2",
        "name": "Customer",
        "type": "text",
        "required": false
      }
    ]
  }
}

Use it when

The business wants to track one more thing, or a column has the wrong name.

What it does

Add columns, rename them, or remove them (their values go too). Rows keep their values through renames.

What comes back

table: the table with its new columns. Every reply also carries cost_usd and balance_usd.

Inputs

Name	Type	What it is
`table`Required	string	The table's name (or its table_id). 1 to 80 characters.
`add`	array of objects	Up to 50 items.
`add[].name`Required	string	1 to 60 characters.
`add[].type`	string	One of: text,long_text,number,checkbox,date,datetime,select,multi_select,email,url,phone,file. Default: text.
`add[].required`	boolean
`add[].options`	array of strings	Up to 100 items.
`add[].decimals`	integer	0 to 6.
`add[].currency`	string	Matches ^[A-Za-z]{3}$.
`rename`	object	{"old name": "new name"}.
`remove`	array of strings	Up to 50 items.

The call

Over MCP, call tables_change_columns on https://api.conecto.chat/mcp/tables. Over REST:

Terminal

curl -X POST https://api.conecto.chat/v1/tools/tables_change_columns \
  -H "Authorization: Bearer $CONECTO_KEY" \
  -H "Content-Type: application/json" \
  -d '{"table":"Workshop jobs","add":[{"name":"Mechanic","type":"select","options":["Sam Reyes","Priya Nair"]}],"rename":{"Work":"Work to do"}}'

When it refuses

A refused call costs nothing and says what to do next.

Code	When	What to do
`not_found`404	No table has that name or table_id, or the table has no column of that name.	Call tables_list for the tables and their columns.
`invalid_input`400	A column has no name or a name in use, an unknown type, a select without options, or a currency that is not a 3-letter code.	Give each column its own name, a type from the list, and options for select columns.
`invalid_input`400	The change would leave no column, or more than 100.	Keep 1 to 100 columns.

More Tables tools

All 12 tools

Give this to your agent.

Set up Conecto from https://conecto.chat/SKILL.md

Change columns

An example

Use it when

What it does

What comes back

Inputs

The call

When it refuses

More Tables tools

Give this to your agent.