Data Tables
Store and manage structured data that your AI agents and workflows can query and update in real time.
What are Data Tables?
Data tables are dynamic, structured datasets that live inside InnConnect. Unlike knowledge base articles (which store unstructured text), data tables store rows and columns — like a database table or spreadsheet.
Your AI agents and workflows can query data tables to look up live information, and workflows can insert or update rows automatically.
AI Queries
Agents with data table skills can look up rows in real time. Ask 'Is product X in stock?' and the AI fetches the answer from the table.
Workflow Operations
Workflows can read from and write to data tables. Use this to update order status, log events, or feed results from one workflow into another.
Always Up to Date
Import from CSV, sync from an external API, or edit rows manually in the admin portal. Your AI always reads the latest data.
Creating a Data Table
Go to Data Tables → Create table.
- Give the table a name and optional description.
- Define your columns — choose a name and data type for each.
- Choose a data source: start empty (manual), import CSV, or configure an API source.
- Save. The table is immediately available to agents (via skills) and workflow nodes.
Column Types
Each column has a type that controls what values it accepts.
| Type | Description |
|---|---|
string | Short text — names, codes, identifiers. |
integer | Whole numbers — quantities, IDs, counts. |
decimal | Decimal numbers — prices, scores, measurements. |
boolean | True or false — flags, toggles. |
date | A calendar date (YYYY-MM-DD). |
datetime | A date and time. |
text | Long text — descriptions, notes. |
enum | One of a predefined set of values. |
json | Arbitrary JSON — nested structures, arrays. |
Data Sources
| Source | How data gets in |
|---|---|
| Manual | Add, edit, and delete rows directly in the admin portal. Best for small, infrequently updated datasets. |
| CSV Import | Upload a CSV file to populate the table. Choose replace (overwrite all rows) or append (add new rows). Useful for bulk imports. |
| API Sync | Configure an external URL to pull data from automatically. Supports replace, append, and upsert sync modes. |
Workflow Operations
Workflow nodes can perform these operations on any data table:
| Operation | What it does |
|---|---|
| Query | Filter rows by conditions and return matching records. Use the results in subsequent nodes. |
| Insert | Add a new row to the table. |
| Update | Update existing rows that match a condition. |
| Upsert | Insert a row if it doesn't exist; update it if it does (based on a key column). |
| Delete | Delete rows matching a condition. |