Tables API

// List all tables in a project
const response: Response = await fetch('/api/tables?projectId=proj-8f3a-4b2c');
const tables: Array<{ id: string; name: string; source: string }> = await response.json();

tables.forEach((t) => console.log(`${t.name} (${t.source}) — ${t.id}`));

// Create a table with typed columns
const response: Response = await fetch('/api/tables', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  name: 'Customer Feedback',
  projectId: 'proj-8f3a-4b2c',
  columns: [
    { name: 'customer', displayName: 'Customer', dataType: 'text', position: 0 },
    { name: 'rating', displayName: 'Rating', dataType: 'number', position: 1 },
    { name: 'feedback', displayName: 'Feedback', dataType: 'text', position: 2 },
  ],
}),
});
const table: { id: string } = await response.json();

console.log(table.id); // "tbl-6c1d-9e7f"

// Clone a template with sample data included
const response: Response = await fetch('/api/tables', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  templateId: 'tpl-4a2b-8c9d',
  name: 'Q3 Budget Tracker',
  projectId: 'proj-8f3a-4b2c',
  includeSampleData: true,
}),
});
const table: { id: string; name: string } = await response.json();

// Fetch table metadata and column definitions
const table: { name: string; columns: Array<{ displayName: string; dataType: string }> } =
await fetch('/api/tables/tbl-6c1d-9e7f').then((r) => r.json());

console.log(`${table.name} — ${table.columns.length} columns`);
table.columns.forEach((c) => console.log(`  ${c.displayName} (${c.dataType})`));

// Update table name
await fetch('/api/tables/tbl-6c1d-9e7f', {
method: 'PATCH',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ name: 'Customer Feedback v2' }),
});

// Delete a table and all associated data
await fetch('/api/tables/tbl-6c1d-9e7f', { method: 'DELETE' });

// Query with filters and sorting
const filters: string = JSON.stringify([
{ column: 'rating', operator: 'gte', value: 4 },
{ column: 'status', operator: 'eq', value: 'open' },
]);
const sorts: string = JSON.stringify([
{ column: 'rating', direction: 'desc' },
]);

const rows: Array<{ data: { customer: string; rating: number; feedback: string } }> = await fetch(
`/api/tables/tbl-6c1d-9e7f/rows?limit=50&filters=${encodeURIComponent(filters)}&sorts=${encodeURIComponent(sorts)}`
).then((r) => r.json());

rows.forEach((row) => {
console.log(`${row.data.customer}: ${row.data.rating}/5 — ${row.data.feedback}`);
});

// Batch insert rows (up to 1000 per request)
const result: Array<{ id: string }> = await fetch('/api/tables/tbl-6c1d-9e7f/rows', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  rows: [
    { data: { customer: 'Acme Corp', rating: 5, feedback: 'Excellent' }, createdBy: 'claude-code' },
    { data: { customer: 'Globex Inc', rating: 3, feedback: 'Average' }, createdBy: 'claude-code' },
  ],
}),
}).then((r) => r.json());

console.log(`Inserted ${result.length} rows`);

// Update a row — full data replacement
await fetch('/api/tables/tbl-6c1d-9e7f/rows/row-a1b2-c3d4', {
method: 'PATCH',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  data: { customer: 'Acme Corp', rating: 4, feedback: 'Good, improved response time', status: 'closed' },
}),
});

// Delete a single row
await fetch('/api/tables/tbl-6c1d-9e7f/rows/row-a1b2-c3d4', { method: 'DELETE' });

// Add a select column with options
const column: { id: string; name: string } = await fetch('/api/tables/tbl-6c1d-9e7f/columns', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  name: 'status',
  displayName: 'Status',
  dataType: 'select',
  config: { options: ['open', 'in_progress', 'closed'] },
}),
}).then((r) => r.json());

// Move status column to the front
await fetch('/api/tables/tbl-6c1d-9e7f/columns', {
method: 'PATCH',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  columnIds: ['col-g7h8', 'col-a1b2', 'col-c3d4', 'col-e5f6'],
}),
});

// Preview first, then import
const preview: { totalRows: number; headers: string[] } = await fetch(
'/api/tables/tbl-6c1d-9e7f/import',
{
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({ documentId: 'doc-7b2e-3f9a', preview: true }),
}
).then((r) => r.json());

console.log(`${preview.totalRows} rows, ${preview.headers.length} columns detected`);

// Execute the import
const result: { rowsImported: number; rowsSkipped: number } = await fetch(
'/api/tables/tbl-6c1d-9e7f/import',
{
  method: 'POST',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({ documentId: 'doc-7b2e-3f9a' }),
}
).then((r) => r.json());

console.log(`Imported ${result.rowsImported}, skipped ${result.rowsSkipped}`);

// Download as CSV and trigger browser save
const res: Response = await fetch('/api/tables/tbl-6c1d-9e7f/export?format=csv');
const blob: Blob = await res.blob();
const url: string = URL.createObjectURL(blob);

const link: HTMLAnchorElement = document.createElement('a');
link.href = url;
link.download = 'customer-feedback.csv';
link.click();

// Check which triggers are active
const triggers: Array<{ name: string; status: string; triggerEvent: string; actionType: string; fireCount: number }> =
await fetch('/api/tables/tbl-6c1d-9e7f/triggers').then((r) => r.json());

triggers.forEach((t) => {
console.log(`${t.name} [${t.status}] — ${t.triggerEvent} → ${t.actionType} (fired ${t.fireCount}x)`);
});

// Auto-run a triage workflow when new rows are added
const trigger: { id: string; name: string } = await fetch('/api/tables/tbl-6c1d-9e7f/triggers', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  name: 'Auto-triage feedback',
  triggerEvent: 'row_added',
  actionType: 'run_workflow',
  actionConfig: { workflowId: 'wf-2a3b-4c5d' },
}),
}).then((r) => r.json());

// Pause a trigger during maintenance
await fetch('/api/tables/tbl-6c1d-9e7f/triggers/trg-5e4d-3c2b', {
method: 'PATCH',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ status: 'paused' }),
});

// Delete a trigger
await fetch('/api/tables/tbl-6c1d-9e7f/triggers/trg-5e4d-3c2b', { method: 'DELETE' });

// List all charts for a table
const charts: Array<{ name: string; config: { type: string } }> =
await fetch('/api/tables/tbl-6c1d-9e7f/charts').then((r) => r.json());
charts.forEach((c) => console.log(`${c.name} (${c.config.type})`));

// Create a ratings distribution chart
const chart: { id: string; name: string } = await fetch('/api/tables/tbl-6c1d-9e7f/charts', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  type: 'bar',
  title: 'Ratings Distribution',
  xColumn: 'rating',
  aggregation: 'count',
}),
}).then((r) => r.json());

// Switch to pie chart
await fetch('/api/tables/tbl-6c1d-9e7f/charts/chart-a1b2-c3d4', {
method: 'PATCH',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ type: 'pie', title: 'Ratings Breakdown' }),
});

// Delete a chart
await fetch('/api/tables/tbl-6c1d-9e7f/charts/chart-a1b2-c3d4', { method: 'DELETE' });

// Fetch recent change history
const history: Array<{ action: string; rowId: string; createdAt: string }> =
await fetch('/api/tables/tbl-6c1d-9e7f/history?limit=50').then((r) => r.json());

history.forEach((entry) => {
console.log(`[${entry.action}] row ${entry.rowId} at ${entry.createdAt}`);
});

// View how a row changed over time
const history: Array<{ version: number; data: { rating: number }; createdAt: string }> =
await fetch('/api/tables/tbl-6c1d-9e7f/rows/row-a1b2-c3d4/history').then((r) => r.json());

history.forEach((entry) => {
console.log(`v${entry.version}: rating=${entry.data.rating} at ${entry.createdAt}`);
});

// Rollback a row to a previous version
await fetch('/api/tables/tbl-6c1d-9e7f/rows/row-a1b2-c3d4/history', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ historyEntryId: 'hist-9f8e-7d6c' }),
});

// List project management templates
const { templates }: { templates: Array<{ name: string; scope: string; description: string }> } =
await fetch('/api/tables/templates?category=pm').then((r) => r.json());

templates.forEach((t) => console.log(`${t.name} [${t.scope}] — ${t.description}`));

// Save a table as a reusable template
const template: { id: string } = await fetch('/api/tables/templates', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
  tableId: 'tbl-6c1d-9e7f',
  name: 'Sprint Planning Board',
  category: 'pm',
  includeSampleData: true,
}),
}).then((r) => r.json());

console.log(`Template saved: ${template.id}`);