Skip to main content
Glama

grist_get_records

Fetch records from Grist documents using filter criteria to retrieve specific data without writing SQL queries.

Instructions

Fetch records with filters. No SQL needed. Use grist_query_sql for JOINs and aggregations. Filter syntax: {"Status": "Active"}, {"Priority": 1}, {"IsA

Example: {"docId":"abc123","tableId":"Contacts","filters":{"Status":"Active"}}

Use grist_help({tools:["grist_get_records"]}) for full schema.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
docIdYes
tableIdYes
filtersNo
columnsNo
response_formatNo
offsetNo
limitNo

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/gwhthompson/grist-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server