---
title: "Upsert Smart Column"
method: POST
path: "/api/v3/workspaces/{workspace_id}/smart-columns"
tags: ["Smart Columns"]
---

# Upsert Smart Column

`POST /api/v3/workspaces/{workspace_id}/smart-columns`

Create or update a smart column for a workspace using SQLModel.

## Path parameters

- `workspace_id` string, required

## Request body

- SmartColumnRequest
  - `column_id` string, nullable
  - `column_type` 'smart' | 'static', required
  - `column_name` string, required
  - `column_version` number, nullable
  - `description` string, required
  - `data_source` 'meeting_minutes' | 'purchase_orders' | 'online_research' | 'strategic_plans' | 'contacts' | 'annual_budgets' | 'procurement_guidelines' | 'news' | 'rfps' | 'legislation' | 'grants' | 'intent' | 'email' | 'google_search' | 'summary' | 'signals' | 'call_script', required
  - `keyword_config` AppRoutesV3SmartColumnsKeywordConfig, required
    - `logic` 'AND' | 'OR', required
    - `keywords` string[], required
    - `is_strict` boolean, required
  - `rerun_frequency` 'daily' | 'weekly' | 'monthly' | 'none', required
  - `last_run` string, date-time, nullable
  - `date_range` AppRoutesV3SmartColumnsDateRange
    - `from` string, date-time, required
    - `to` string, date-time, nullable
  - `intent_factors` IntentFactors
    - `key_factors` string, required
    - `scoring_rubric` string, required
  - `reference_column_ids` string[], nullable

## Response `200`

Successful Response

- unknown

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/nationgraph/apis/nationgraph-api.md) · [All operations](https://skmtc.dev/nationgraph/apis/nationgraph-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/nationgraph/nationgraph-api/revisions/85804e68d86d/schema)