get_table_rows
Retrieve rows from a specific table in a Glide app by specifying the app ID, table ID, and optional parameters like row limit and offset. Facilitates data access and management through the Glide API MCP Server.
Instructions
Get rows from a table in a Glide app
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| appId | Yes | ID of the Glide app | |
| limit | No | Maximum number of rows to return | |
| offset | No | Number of rows to skip | |
| tableId | Yes | ID of the table |
Implementation Reference
- src/index.ts:307-325 (handler)Executes the get_table_rows tool: parses arguments, constructs API endpoint with optional limit/offset query parameters, calls Glide API via makeRequest, and returns JSON-formatted rows.
case 'get_table_rows': { const { appId, tableId, limit, offset } = request.params.arguments as { appId: string; tableId: string; limit?: number; offset?: number; }; const params = new URLSearchParams(); if (limit) params.append('limit', limit.toString()); if (offset) params.append('offset', offset.toString()); const result = await this.apiClient.makeRequest( 'GET', `/apps/${appId}/tables/${tableId}/rows${params.toString() ? '?' + params.toString() : ''}` ); return { content: [{ type: 'text', text: JSON.stringify(result, null, 2) }], }; } - src/index.ts:166-193 (registration)Registers the get_table_rows tool in the ListToolsRequestSchema handler, providing name, description, and input schema.
{ name: 'get_table_rows', description: 'Get rows from a table in a Glide app', inputSchema: { type: 'object', properties: { appId: { type: 'string', description: 'ID of the Glide app', }, tableId: { type: 'string', description: 'ID of the table', }, limit: { type: 'number', description: 'Maximum number of rows to return', minimum: 1, }, offset: { type: 'number', description: 'Number of rows to skip', minimum: 0, }, }, required: ['appId', 'tableId'], }, }, - src/index.ts:169-192 (schema)Input schema definition for get_table_rows tool, validating appId, tableId (required), limit, and offset parameters.
inputSchema: { type: 'object', properties: { appId: { type: 'string', description: 'ID of the Glide app', }, tableId: { type: 'string', description: 'ID of the table', }, limit: { type: 'number', description: 'Maximum number of rows to return', minimum: 1, }, offset: { type: 'number', description: 'Number of rows to skip', minimum: 0, }, }, required: ['appId', 'tableId'], },