Skip to main content

​
What are Tables?

Tables in ERPLite are customizable data stores that allow you to structure, manage, and access your operational data. Think of them as spreadsheets with superpowers - they support multiple column types, access controls, views, automations, and API access.

Flexible Schema

Define custom columns with 15+ field types

Access Control

Control who can view, edit, and manage data

Multiple Views

Create filtered views for different teams

API Access

Full REST API for programmatic access

​
Creating a Table

1

Navigate to Tables

Click on Tables in the sidebar navigation
2

Create New Table

Click the + Create Table button in the top right
3

Configure Table

Enter a Table Name and optional description
4

Add Columns

Add columns to define your data structure (see Column Types)

​
Table Structure

Each table consists of:
ComponentDescription
ColumnsDefine the fields and data types for your records
RecordsIndividual data entries (rows) in your table
ViewsFiltered/sorted perspectives on your data
PermissionsAccess control rules for the table

​
Key Concepts

​
Records

Records are individual entries in your table. Each record contains values for the columns you’ve defined. Records can be created manually, imported via CSV, or created programmatically via API.

​
Views

Views are saved configurations of filters, sorting, and column visibility. You can create multiple views to show different subsets of data to different teams. See Views for details.

​
Access Control

Tables support granular access control at multiple levels:
  • Table level: Who can see and manage the table
  • Column level: Who can view/edit specific columns
  • Record level: Row-based access restrictions
See Sharing & Permissions for details.

​
For AI Agents

  • Route: /table (table list), /table/:tableType (specific table)
  • Sidebar: Tables dropdown menu lists all available tables

​
API Endpoints

​
List All Tables

GET /zorp-tables-service/table/names
Authorization: Bearer {secretKey}

​
Create Table

POST /zorp-tables-service/table/create
Authorization: Bearer {secretKey}
Content-Type: application/json

{
  "tableType": "my_custom_table",
  "displayName": "My Custom Table",
  "description": "Optional description"
}

​
Get Table Metadata

GET /zorp-tables-service/table/:tableType/metadata
Authorization: Bearer {secretKey}
Response Structure: 
{
  "code": "200",
  "message": "Success",
  "data": {
    "tableType": "my_custom_table",
    "displayName": "My Custom Table",
    "columns": [...],
    "views": [...],
    "permissions": [...]
  }
}

​
UI Elements

ElementSelector/IdentifierPurpose
Create Table Button[data-testid="create-table-btn"]Opens table creation modal
Table List.sidebar-tables-listLists all tables
Table HeaderTableHeader componentShows table name and actions

​
Automation Patterns

Creating a table programmatically:
  1. Call POST /table/create with table configuration
  2. Add columns via POST /table/update with column definitions
  3. Set permissions via PUT /table/table-acl