Smart Columns

Use {{column_name}} in URLs, request bodies, and run conditions to reference other columns in the same record. When the smart column runs, each {{...}} placeholder is replaced with the actual value from that record.

https://api.example.com/companies/{{company}}

{
  "company": "{{company}}",
  "website": "{{website}}"
}

Every smart column has a kind that determines what it does when processing a record. There are 6 smart-column kinds:

Add a smart column that processes data per record. HTTP columns call APIs, formula columns compute values, integration columns push data, and lookup columns join across tables.

{
  "tool": "hypertab_add_smart_column",
  "arguments": {
    "table": "leads",
    "name": "industry",
    "type": "text",
    "kind": "formula",
    "config": {
      "expression": "company"
    },
    "rate_limit": "moderate",
    "auto_run": true
  }
}

Formula columns compute a value from other columns in the same record. No external API calls, no rate limiting. The expression is evaluated locally for each record.

{
  "tool": "hypertab_add_smart_column",
  "arguments": {
    "table": "orders",
    "name": "total",
    "type": "number",
    "kind": "formula",
    "config": {
      "expression": "price * quantity"
    }
  }
}

Integration columns push record data to a configured public HTTP(S) destination. Each record triggers one outbound request when the final destination passes Hypertab safety checks. Private, local, metadata, redirecting, Hypertab-owned, and token-bearing webhook URLs are blocked.

{
	  "tool": "hypertab_save_api_account",
	  "arguments": {
	    "name": "CRM",
	    "service": "crm",
	    "auth_type": "bearer",
	    "token": "<crm-api-token>",
	    "base_url": "https://api.crm.example.com"
	  }
	}

Lookup columns perform a cross-table VLOOKUP. For each record, they find a matching record in another table and return a value from it. No external API calls, no rate limiting.

{
  "tool": "hypertab_add_smart_column",
  "arguments": {
    "table": "orders",
    "name": "customer_company",
    "type": "text",
    "kind": "lookup",
    "config": {
      "source_table": "customers",
      "match_column": "customer_id",
      "return_column": "company_name"
    }
  }
}

Run conditions let you skip records that don't have the required data. Add a run_condition to any smart column's config. Records that don't match the condition are marked as "skipped" instead of "error".

Update the configuration of a smart column after creation. Change the HTTP URL or body, formula expression, rate limit preset, or auto-run setting. Only provided fields are updated; omitted fields are left unchanged.

{
  "tool": "hypertab_update_column_config",
  "arguments": {
    "table": "leads",
    "column": "summary",
    "rate_limit": "aggressive"
  }
}

Trigger smart column processing for all records or specific record IDs. Creates a column run and enqueues cells for batch processing. Rate limits are enforced per column config.

{
  "tool": "hypertab_run_column",
  "arguments": {
    "table": "countries",
    "column": "capital"
  }
}

Check the progress of a smart column run. Shows total records, processed count, error count, and completion status. Use the run_id returned by hypertab_run_column.

{
  "tool": "hypertab_get_column_run_status",
  "arguments": {
    "run_id": "run_abc123"
  }
}

Get per-cell execution states for a smart column. Each cell in a smart column has its own execution state tracking. Filter by status to find failures or pending cells.

{
  "tool": "hypertab_get_cell_states",
  "arguments": {
    "table": "countries",
    "column": "capital",
    "status": "error"
  }
}

Retry all failed cells in a smart column. Creates a new column run for just the cells with "error" status, re-enqueuing them for processing.

{
  "tool": "hypertab_retry_failed_cells",
  "arguments": {
    "table": "countries",
    "column": "capital"
  }
}

Every HTTP smart column stores a structured response with metadata alongside the extracted value. Click any completed cell in the UI to open the Cell Details Panel showing all response fields with the ability to add any field as a new column.

Get the full response metadata for a specific cell.

curl https://api.hypertab.ai/v1/tables/tbl_countries001/records/d54e84ca-1a2b-4c3d-8e9f-1234567890ab/cells/capital \
  -H "Authorization: Bearer ht_sk_..." \
  -H "X-Hypertab-Workspace: growth-ops"

HTTP columns support advanced configuration: query parameters, retries, timeouts, multi-extract, saved API accounts, and more.

{
  "config": {
    "url": "https://api.github.com/orgs/{{company}}",
    "method": "GET",
    "account_id": "acct_...",
    "extracts": {
      "repos": "public_repos",
      "followers": "followers",
      "blog": "blog",
      "location": "location"
    },
    "timeout_ms": 10000,
    "retry_on_failure": true,
    "max_retries": 2,
    "retry_status_codes": [429, 500, 502, 503]
  }
}

Save named API accounts with auth headers. Use account_id in HTTP column config to auto-inject headers. Inline credentials and credential-bearing URLs are rejected from stored column configs.

{
  "tool": "hypertab_save_api_account",
  "arguments": {
    "name": "My GitHub API",
    "service": "github",
    "auth_type": "bearer",
    "token": "ghp_your_token_here",
    "base_url": "https://api.github.com",
    "description": "GitHub production API key"
  }
}

Manage accounts: hypertab_list_api_accounts, hypertab_update_api_account, hypertab_delete_api_account. Or use Settings → API Accounts in the UI.

A table can contain multiple tabs (pipeline stages). Each tab has its own columns and records. Linked tabs auto-sync data from a parent tab based on filter conditions. JSON fields from smart columns are expanded into real columns on the linked tab.

{
  "tool": "hypertab_create_tab",
  "arguments": {
    "table": "my_leads",
    "name": "qualified_leads",
    "source_column": "research",
    "filter": {
      "research.employee_count": { "gte": 500 }
    },
    "description": "Leads with 500+ employees"
  }
}

// Creates a new tab that:
// 1. Inherits parent columns (company, website)
// 2. Expands JSON fields from 'research' column (industry, employee_count, hq_city, revenue)
// 3. Only syncs records where employee_count >= 500

Set auto_run: true in a smart column's config to automatically process new records when they're inserted. The column run triggers immediately afterhypertab_insert_rows completes.

{
  "tool": "hypertab_update_column_config",
  "arguments": {
    "table": "my_leads",
    "column": "research",
    "config": { "auto_run": true }
  }
}

// Now when you insert records:
// hypertab_insert_rows({ table: "my_leads", rows: [...] })
// → 'research' column automatically starts processing the new records