import { CodaClient } from '../coda-client.js';
export function getRowTools() {
return [
{
name: 'coda_list_rows',
description: 'List all rows in a table with optional filtering',
inputSchema: {
type: 'object',
properties: {
docId: { type: 'string', description: 'The ID of the document' },
tableId: { type: 'string', description: 'The ID or name of the table' },
query: { type: 'string', description: 'Optional query to filter rows' },
limit: { type: 'number', description: 'Maximum rows to return (default: 100)' },
},
required: ['docId', 'tableId'],
},
},
{
name: 'coda_create_row',
description:
'Create a new row in a table. Accepts either `cells` for one row or `rows` for advanced/batch payload.',
inputSchema: {
type: 'object',
properties: {
docId: { type: 'string', description: 'The ID of the document' },
tableId: { type: 'string', description: 'The ID or name of the table' },
cells: {
type: 'array',
description: 'Array of cell objects with column and value',
items: {
type: 'object',
properties: {
column: { type: 'string', description: 'Column ID or name' },
value: { description: 'Value to set' },
},
required: ['column', 'value'],
},
},
rows: {
type: 'array',
description: 'Optional advanced format matching Coda API: array of row objects',
items: {
type: 'object',
properties: {
cells: {
type: 'array',
items: {
type: 'object',
properties: {
column: { type: 'string', description: 'Column ID or name' },
value: { description: 'Value to set' },
},
required: ['column', 'value'],
},
},
},
required: ['cells'],
},
},
row: {
type: 'object',
description:
'Optional legacy alias for a single row object. Prefer `cells` or `rows`.',
properties: {
cells: {
type: 'array',
items: {
type: 'object',
properties: {
column: { type: 'string', description: 'Column ID or name' },
value: { description: 'Value to set' },
},
required: ['column', 'value'],
},
},
},
required: ['cells'],
},
keyColumns: {
type: 'array',
description:
'Optional key columns for upsert behavior (Coda API keyColumns parameter)',
items: { type: 'string' },
},
disableParsing: {
type: 'boolean',
description: 'Optional. If true, Coda will not parse/formula-convert input values.',
},
},
required: ['docId', 'tableId'],
},
},
{
name: 'coda_update_row',
description: 'Update an existing row in a table',
inputSchema: {
type: 'object',
properties: {
docId: { type: 'string', description: 'The ID of the document' },
tableId: { type: 'string', description: 'The ID or name of the table' },
rowId: { type: 'string', description: 'The ID of the row to update' },
cells: {
type: 'array',
description: 'Array of cell objects to update',
items: {
type: 'object',
properties: {
column: { type: 'string', description: 'Column ID or name' },
value: { description: 'New value' },
},
required: ['column', 'value'],
},
},
disableParsing: {
type: 'boolean',
description: 'Optional. If true, Coda will not parse/formula-convert input values.',
},
},
required: ['docId', 'tableId', 'rowId', 'cells'],
},
},
];
}
export async function handleRowToolCall(request: any, client: CodaClient) {
const { name, arguments: args } = request.params;
try {
switch (name) {
case 'coda_list_rows':
const rows = await client.listRows(args.docId, args.tableId, {
query: args.query,
useColumnNames: true,
limit: args.limit || 100,
});
return { content: [{ type: 'text', text: JSON.stringify(rows, null, 2) }] };
case 'coda_create_row':
const rowsPayload = Array.isArray(args.rows)
? args.rows
: Array.isArray(args.cells)
? [{ cells: args.cells }]
: args.row && Array.isArray(args.row.cells)
? [args.row]
: null;
if (!rowsPayload || rowsPayload.length === 0) {
return {
content: [
{
type: 'text',
text: 'Error: coda_create_row requires `cells` (single row) or `rows` (array).',
},
],
isError: true,
};
}
const createResult = await client.createRow(args.docId, args.tableId, {
rows: rowsPayload,
keyColumns: Array.isArray(args.keyColumns) ? args.keyColumns : undefined,
disableParsing: typeof args.disableParsing === 'boolean' ? args.disableParsing : undefined,
});
return { content: [{ type: 'text', text: JSON.stringify(createResult, null, 2) }] };
case 'coda_update_row':
const updatedRow = await client.updateRow(args.docId, args.tableId, args.rowId, {
row: { cells: args.cells },
disableParsing: typeof args.disableParsing === 'boolean' ? args.disableParsing : undefined,
});
return { content: [{ type: 'text', text: JSON.stringify(updatedRow, null, 2) }] };
default:
return { content: [{ type: 'text', text: 'Tool not found' }], isError: true };
}
} catch (error) {
return {
content: [{ type: 'text', text: `Error: ${error instanceof Error ? error.message : String(error)}` }],
isError: true,
};
}
}
