Grist through One
A flexible data workspace that combines spreadsheet simplicity with database structure, enabling teams to organize, analyze, and collaborate on structured data, build custom apps, and automate workflows without coding.
One exposes Grist through four MCP tools. The table below carries real action ids from One's knowledge base, so for a common operation you can skip search and go straight to reading the action's parameters.
How to run an action
- Find the action in the table below, or call
search_one_platform_actions with platform grist if it is not listed.
- Call
get_one_action_knowledge with the action id. Do this every time, including for actions in this table. The table gives you the id, not the parameters.
- Call
execute_one_action with parameters copied from that knowledge.
Never guess a parameter name, a body field, or an enum value. The knowledge has the real schema, and a guessed field is either a 400 or a silent write of the wrong thing.
Before you start
Call list_one_integrations once and confirm Grist is connected. If it is missing, the user has not connected it: say so and point them at https://app.withone.ai rather than reaching for raw HTTP.
Each connection carries an access field. If it reports {"policy": "methods", "methods": ["GET"]} the agent is read-only here, so plan a read-only answer instead of attempting a write that will be refused.
Before a write
Creates, updates, deletes and sends land on a real Grist account and cannot be recalled. State the action and the specific target in one line before the first write in a task, and let the user stop you. Reads need no confirmation.
Actions
Documents
| Action |
Method |
Path |
Action id |
| Compare Document Versions |
GET |
/docs/{{docId}}/compare |
conn_mod_def::GKIqU8nZXKc::aR4ETrpVQe2kC9Gc8QPzvg |
| Compare Two Documents |
GET |
/docs/{{docId}}/compare/{{docId2}} |
conn_mod_def::GKIqU9PYeds::Lwp3mTVwRhSPc-T4L3zbkw |
| Describe a Document |
GET |
/docs/{{docId}} |
conn_mod_def::GKIqVNp3eIw::ieDtcasnTqOhKcMb_BTPFg |
| Download a Document as a SQLite File |
GET |
/docs/{{docId}}/download |
conn_mod_def::GKIqU8zVLW8::vjPd1XCOSeSAPU5-jtIg5A |
| Download a Document as an Excel File |
GET |
/docs/{{docId}}/download/xlsx |
conn_mod_def::GKIqU86eKfE::6gLFWnriSVGlAM47FLSg6A |
| Download a Document Table as CSV |
GET |
/docs/{{docId}}/download/csv |
conn_mod_def::GKIqVFfqmfM::oElWBzPmQrOAVwmOf2rTKg |
| Download a Document's All Attachments Archive |
GET |
/docs/{{docId}}/attachments/archive |
conn_mod_def::GKIqT1DkwlU::aYJItaSNS46xiahZFWdndw |
| Run an SQL Query Against a Document |
GET |
/docs/{{docId}}/sql |
conn_mod_def::GKIqW-skL6Q::wPuqFJrTTxedyKS_5d2KzA |
| Apply a List of User Actions to a Document |
POST |
/docs/{{docId}}/apply |
conn_mod_def::GKIqUz0EH0Y::9FVGTlXLQuObtNxpLb3DCw |
| Change Access for a Document |
PATCH |
/docs/{{docId}}/access |
conn_mod_def::GKIqU78MC9g::hvVBcekqSNOJwKte_9C0jg |
| Copy a Document to a Workspace |
POST |
/docs/{{docId}}/copy |
conn_mod_def::GKIqVE256iU::7DzcOOnlT5Wx9qVo5ZIEYw |
| Create a Change Proposal for a Document |
POST |
/docs/{{docId}}/propose |
conn_mod_def::GKIqVE9L-1U::Ga4UA9YrSD2uxrPMTp1xrg |
21 more Documents actions are available through search.
Attachments
| Action |
Method |
Path |
Action id |
| Download an Attachment's Contents |
GET |
/docs/{{docId}}/attachments/{{attachmentId}}/download |
conn_mod_def::GKIqT0Fff4Y::wp33pMgeQ-OCtKjaUVdMIA |
| Get a Document's External Attachment Store |
GET |
/docs/{{docId}}/attachments/store |
conn_mod_def::GKIqT0fXfu0::oyntdoC8SAapsQAqaUK3MA |
| Get Attachment Metadata for a Document |
GET |
/docs/{{docId}}/attachments/{{attachmentId}} |
conn_mod_def::GKIqT-2X6SI::zK19e3a3STCM8zV79xMkFA |
| List a Doc's Attachment Metadata |
GET |
/docs/{{docId}}/attachments |
conn_mod_def::GKIqULgErmc::jLX8hX90QtuylMZfjJbNAg |
| Delete Unused Attachments From a Document |
POST |
/docs/{{docId}}/attachments/removeUnused |
conn_mod_def::GKIqT2rI6yg::ib6YuSKwTH6KbaOjqOf5qA |
| Set a Document's Attachment Store |
POST |
/docs/{{docId}}/attachments/store |
conn_mod_def::GKIqT-1HSxM::4ABH4_3VQWS5w3pGzS05lw |
| Start Transferring a Document's Attachments |
POST |
/docs/{{docId}}/attachments/transferAll |
conn_mod_def::GKIqT-Si2As::IrTpHcXqRvaPc-_3a6sj0A |
| Update Attachment Usage Tracking for a Document |
POST |
/docs/{{docId}}/attachments/updateUsed |
conn_mod_def::GKIqUTUSsNk::8lyk7KGGTS-A5907V_0-Lw |
| Upload Attachments to a Doc |
POST |
/docs/{{docId}}/attachments |
conn_mod_def::GKIqUTmfKRA::rZnqv4c5RTykLYO4e64zNg |
| Upload Missing Attachments for a Document |
POST |
/docs/{{docId}}/attachments/archive |
conn_mod_def::GKIqUTvjweA::41gmkT8HT1yX5XDzJT5Hng |
Workspaces
| Action |
Method |
Path |
Action id |
| Describe a Workspace |
GET |
/workspaces/{{workspaceId}} |
conn_mod_def::GKIqXifF4m8::THmNzH1XSh-BrOzEuUr_hw |
| List an Org's Workspaces |
GET |
/orgs/{{orgId}}/workspaces |
conn_mod_def::GKIqXqj7sdo::LrxPO_LRQDmmGhVO-JnE7w |
| Change Access for a Workspace |
PATCH |
/workspaces/{{workspaceId}}/access |
conn_mod_def::GKIqXgsDA1E::5kehJbUyQJeaqNjnZw0WRg |
| Create an Empty Workspace in an Organization |
POST |
/orgs/{{orgId}}/workspaces |
conn_mod_def::GKIqXhfTC48::BjeHymE2TamLvuyjng3Iow |
| Delete a Workspace |
DELETE |
/workspaces/{{workspaceId}} |
conn_mod_def::GKIqXgKLCc4::A470E5pOSrqoWmv9WfbKzw |
| Modify a Workspace |
PATCH |
/workspaces/{{workspaceId}} |
conn_mod_def::GKIqXqKgCBY::r4Daomx_TVeAOKO2rWUz8A |
| Remove a Workspace |
POST |
/workspaces/{{workspaceId}}/remove |
conn_mod_def::GKIqXqbwlwY::R_XI6vwyRnGC2akR4r1sSw |
| Restore a Workspace From Trash |
POST |
/workspaces/{{workspaceId}}/unremove |
conn_mod_def::GKIqXreIy1s::_UEiCJxASlOWrvZa_0ayFw |
ServiceAccounts
| Action |
Method |
Path |
Action id |
| Get a Service Account's Details |
GET |
/service-accounts/{{saId}} |
conn_mod_def::GKIqW1ChxDw::7kWnqOikTJiYQFimNGurlw |
| List Service Accounts |
GET |
/api/service-accounts |
conn_mod_def::GKIqW0MYoIg::kvplbd6YRX6EstXiUNcsdg |
| Create a Service Account |
POST |
/api/service-accounts |
conn_mod_def::GKIqWpjIjnU::KBriIiRyQ9CEX2BaJ13-Cg |
| Delete a Service Account |
DELETE |
/service-accounts/{{saId}} |
conn_mod_def::GKIqW0MHaIQ::RDJHIiVbSoy_nsyiWh4oDg |
| Modify a Service Account |
PATCH |
/service-accounts/{{saId}} |
conn_mod_def::GKIqW9fNWwg::F3AAJhzbQ2ecLViYK3juQA |
| Regenerate a Service Account's API Key |
POST |
/service-accounts/{{saId}}/apikey |
conn_mod_def::GKIqW0bH3b4::SXkWIHLzQymTeXCqsD9u6A |
Records
| Action |
Method |
Path |
Action id |
| List Records From a Document Table |
GET |
/docs/{{docId}}/tables/{{tableId}}/records |
conn_mod_def::GKIqWsHynEA::AQb7kEYgTsqQzYn802ExRw |
| Add or Update Records in a Document Table |
PUT |
/docs/{{docId}}/tables/{{tableId}}/records |
conn_mod_def::GKIqWhs-ab0::Ni5EMj5_S_-KhjUuQOATBw |
| Add Records to a Doc Table |
POST |
/docs/{{docId}}/tables/{{tableId}}/records |
conn_mod_def::GKIqWqun1Zk::Qh_x0U9VTxK0P71ATFEpsA |
| Delete Records of a Table in a Document |
POST |
/docs/{{docId}}/tables/{{tableId}}/records/delete |
conn_mod_def::GKIqWqiv8EA::jy5iOftYRwO24BM1d-VB3A |
| Modify Records of a Table in a Document |
PATCH |
/docs/{{docId}}/tables/{{tableId}}/records |
conn_mod_def::GKIqWrKjqpA::Eh1c7vXyT-WLWIbcYD3tTQ |
Tables
| Action |
Method |
Path |
Action id |
| List Tables in a Document |
GET |
/docs/{{docId}}/tables |
conn_mod_def::GKIqXHQz2-A::XeizaBiqRVevB5G2IWReEw |
| Add Tables to a Document |
POST |
/docs/{{docId}}/tables |
conn_mod_def::GKIqXHI_tSU::8e1MXRJVQQS0lGcvEQK1FQ |
| Modify a Document's Tables |
PATCH |
/docs/{{docId}}/tables |
conn_mod_def::GKIqXHYoons::e2GNNBW6TdCFOMpOmHj-7w |
| Modify Rows of a Table in a Document |
PATCH |
/docs/{{docId}}/tables/{{tableId}}/data |
conn_mod_def::GKIqUz4pCiM::tEtxZqUuSt6sEUhiyoE4LA |
Orgs
| Action |
Method |
Path |
Action id |
| Describe an Org |
GET |
/orgs/{{orgId}} |
conn_mod_def::GKIqWE8Gytk::sBL4-SCMSQiI9OwlLA9DgQ |
| List Orgs |
GET |
/api/orgs |
conn_mod_def::GKIqWT5vRHM::H1kI_gAoTjuFBims_bB9zQ |
| Delete an Org |
DELETE |
/orgs/{{orgId}}/{{name}} |
conn_mod_def::GKIqWFzEHmo::w5SOCvsFQE-NxpRhvH9HUg |
| Modify an Org |
PATCH |
/orgs/{{orgId}} |
conn_mod_def::GKIqWU0d7s8::w0FSmDMRT9muodbbgsL4iw |
Columns
| Action |
Method |
Path |
Action id |
| Add Columns to a Table in a Document |
POST |
/docs/{{docId}}/tables/{{tableId}}/columns |
conn_mod_def::GKIqUd0twRU::vcociUdLST6P1DzCBZK6xA |
| Add or Update Columns of a Table in a Document |
PUT |
/docs/{{docId}}/tables/{{tableId}}/columns |
conn_mod_def::GKIqUmy0Mzs::fpFe-XE3SjmvJ51VjQG6EQ |
| Modify a Table's Columns |
PATCH |
/docs/{{docId}}/tables/{{tableId}}/columns |
conn_mod_def::GKIqUmhj3xM::7-T08rXjT8aku-12IObXGg |
Users
| Action |
Method |
Path |
Action id |
| Delete a User |
DELETE |
/users/{{userId}} |
conn_mod_def::GKIqXP7n5r4::Yd9kYbTKRqmfpb98TncXWg |
| Disable a User |
POST |
/users/{{userId}}/disable |
conn_mod_def::GKIqXPup01c::TODAr4RaTAmR6gGJvk4-Zw |
| Enable a User |
POST |
/users/{{userId}}/enable |
conn_mod_def::GKIqXPhRe2Y::4bQH8x3UT8ir9cKoLpN9EQ |
Webhooks
| Action |
Method |
Path |
Action id |
| List a Document's Webhooks |
GET |
/docs/{{docId}}/webhooks |
conn_mod_def::GKIqXYUE_gU::A5Pi-7kmSBqC0mXMoZHIOw |
| Create Webhooks for a Document |
POST |
/docs/{{docId}}/webhooks |
conn_mod_def::GKIqXYplagE::-iYEPVIIT6a8L_dtw5Mxng |
| Modify a Doc's Webhook |
PATCH |
/docs/{{docId}}/webhooks/{{webhookId}} |
conn_mod_def::GKIqXZPb3RQ::SJdG-AWUQfO8w9gtnxd1wg |
DocumentTableColumns
| Action |
Method |
Path |
Action id |
| List Columns in a Document Table |
GET |
/docs/{{docId}}/tables/{{tableId}}/columns |
conn_mod_def::GKIqUnVMeKE::qnb07AfKTDSYa6rvJoDdOw |
| Delete a Table Column From a Document Table |
DELETE |
/docs/{{docId}}/tables/{{tableId}}/columns/{{colId}} |
conn_mod_def::GKIqUqvDoxU::DOTES-j9SROhVj-gFQIpLA |
DocumentTiming
| Action |
Method |
Path |
Action id |
| Start Formula Timing for a Document |
POST |
/docs/{{docId}}/timing/start |
conn_mod_def::GKIqV8fD0Wg::aIaIrm20Qt6L3h3QzLZGUg |
| Stop Formula Timing for a Document |
POST |
/docs/{{docId}}/timing/stop |
conn_mod_def::GKIqV8fDTDw::kSwSFEmiQ4CCZAl__7ytHg |
Templates
| Action |
Method |
Path |
Action id |
| Get Template Details |
GET |
/templates/{{templateId}} |
conn_mod_def::GKIqXHH8QH8::W80-OP-CTH2P7UssYvRNnA |
| List Available Templates |
GET |
/api/templates |
conn_mod_def::GKIqXPKDdjk::E9I85yltSYWmAndQbCKLXQ |
ApiKey
| Action |
Method |
Path |
Action id |
| Create or Regenerate API Key |
POST |
/api/profile/apikey |
conn_mod_def::GKIqWVeuulI::3YiYjLhXTYCNNLS7UQnBtw |
AttachmentTransferStatus
| Action |
Method |
Path |
Action id |
| Get Attachment Transfer Status for a Document |
GET |
/docs/{{docId}}/attachments/transferStatus |
conn_mod_def::GKIqT09W_Ks::Q-kehFzYSFOe6kCzRCjwdQ |
UserLocale
| Action |
Method |
Path |
Action id |
| Update User Locale |
POST |
/api/profile/user/locale |
conn_mod_def::GKIqWenygI8::DV0ymbk-RYScgo5gwhCkvA |
AttachmentStores
| Action |
Method |
Path |
Action id |
| List a Document's External Attachment Stores |
GET |
/docs/{{docId}}/attachments/stores |
conn_mod_def::GKIqT-fQQos::WnWH7YTBT3-QmSOSZzdb9g |
DocumentTableRows
| Action |
Method |
Path |
Action id |
| Add Rows to a Document Table |
POST |
/docs/{{docId}}/tables/{{tableId}}/data |
conn_mod_def::GKIqUoGUNCw::Et9WyaF8RsKbdEtNjAyq1A |
DocumentProposals
| Action |
Method |
Path |
Action id |
| Apply a Document Proposal |
POST |
/docs/{{docId}}/proposals/{{proposalId}}/apply |
conn_mod_def::GKIqUzGrPFc::R-TlA3z7SzCaho_bVvdeiA |
DocumentTableData
| Action |
Method |
Path |
Action id |
| Fetch Data From a Document Table |
GET |
/docs/{{docId}}/tables/{{tableId}}/data |
conn_mod_def::GKIqU0IUeEM::I9JNUNABQi6ybYGgfIQvww |
DocumentTableDsv
| Action |
Method |
Path |
Action id |
| Download a Document Table as DSV |
GET |
/docs/{{docId}}/download/dsv |
conn_mod_def::GKIqVF4SvGw::ZPPI-mSpRKeTCjz6qqHb9g |
DocumentTableTsv
| Action |
Method |
Path |
Action id |
| Download a Document Table as TSV |
GET |
/docs/{{docId}}/download/tsv |
conn_mod_def::GKIqVF8Hk-w::O5ZohqZZQK6kC0VHs3PhYg |
DocumentActionHistoryStates
| Action |
Method |
Path |
Action id |
| Get a Document's Action History States |
GET |
/docs/{{docId}}/states |
conn_mod_def::GKIqVVgqw3Y::DCpNtw0aSqKrO3RQHFgulw |
FormulaTimingStatus
| Action |
Method |
Path |
Action id |
| Get Formula Timing Status for a Document |
GET |
/docs/{{docId}}/timing |
conn_mod_def::GKIqVV8-5qg::8HiOhO6aTl2Yyx0jaZo9MA |
WorkspaceDocuments
| Action |
Method |
Path |
Action id |
| Import a Workspace Document |
POST |
/workspaces/{{workspaceId}}/import |
conn_mod_def::GKIqVenQ7-k::_LCeQ4U-Tyubydu_Csb-Jw |
DocumentAccess
| Action |
Method |
Path |
Action id |
| List Users With Access to a Document |
GET |
/docs/{{docId}}/access |
conn_mod_def::GKIqVeuU9Iw::TT9Mg1x0RReYYUiNL3jNEg |
DocumentUsersForViewAs
| Action |
Method |
Path |
Action id |
| Get a Document's Users for View As |
GET |
/docs/{{docId}}/usersForViewAs |
conn_mod_def::GKIqVe4o7sY::JzyWJBzdQzm6aooPEDs_Ig |
Proposals
| Action |
Method |
Path |
Action id |
| List a Document's Change Proposals |
GET |
/docs/{{docId}}/proposals |
conn_mod_def::GKIqVfUSjBY::cXD-9C64R0yD7t1zN5U-yw |
Snapshots
| Action |
Method |
Path |
Action id |
| List a Document's Snapshots |
GET |
/docs/{{docId}}/snapshots |
conn_mod_def::GKIqVfmKKSA::bqwwS8G2QYijS6F8K01HHg |
DocumentSnapshots
| Action |
Method |
Path |
Action id |
| Remove Document Snapshots |
POST |
/docs/{{docId}}/snapshots/remove |
conn_mod_def::GKIqVzOEFRE::JQZZG3kTQQqQ_DrYDZ6rJw |
DocumentTableSchema
| Action |
Method |
Path |
Action id |
| Download a Document's Table Schema |
GET |
/docs/{{docId}}/download/table-schema |
conn_mod_def::GKIqV8uG0RY::NAGn8unHSMuT4RNYOxLj7A |
DocsFormViewData
| Action |
Method |
Path |
Action id |
| Get a Doc's Form View Data |
GET |
/docs/{{docId}}/forms/{{viewSectionId}} |
conn_mod_def::GKIqWEfzWS0::ANgzUV-cScGfDPxDrIzmpA |
OrganizationUsageSummary
| Action |
Method |
Path |
Action id |
| Get an Organization's Usage Summary |
GET |
/orgs/{{orgId}}/usage |
conn_mod_def::GKIqWFOPaug::m2E0Ne4UTYS2fsgAuePYBQ |
OrgAccess
| Action |
Method |
Path |
Action id |
| Change Access for an Org |
PATCH |
/orgs/{{orgId}}/access |
conn_mod_def::GKIqWFxNmGE::aVbNT7NNTheXZHkyTFK1FQ |
ApiKeys
| Action |
Method |
Path |
Action id |
| Delete the Current User's API Key |
DELETE |
/api/profile/apikey |
conn_mod_def::GKIqWUKdKXk::Uckb8bb5Rl-HR2OdS8hFcQ |
OrgAccessUsers
| Action |
Method |
Path |
Action id |
| List Users With Access to an Org |
GET |
/orgs/{{orgId}}/access |
conn_mod_def::GKIqWWG4y2w::3KTV_FqtQ4G0rVyHC1vZBg |
ProfileApiKey
| Action |
Method |
Path |
Action id |
| Get User's API Key |
GET |
/api/profile/apikey |
conn_mod_def::GKIqWdSF4U4::2hzrv2IyQm6GtIY89ToDqA |
Profile
| Action |
Method |
Path |
Action id |
| Get Current User's Profile |
GET |
/api/profile/user |
conn_mod_def::GKIqWdhM0hE::MEYfHXeaR7WxxvejBNDwfg |
ProfileUserName
| Action |
Method |
Path |
Action id |
| Update User Name |
POST |
/api/profile/user/name |
conn_mod_def::GKIqWeYzUcY::5cCqszW0SPOoFUtiI-IDoA |
This lists 90 of 120 actions. For anything not here, call search_one_platform_actions with platform grist. The full catalog is at https://www.withone.ai/knowledge/grist.
When a call fails
The error comes from Grist, not from One. A 400 or 422 means your parameters do not match the schema, so re-read the knowledge and fix the field. A 401 or 403 means the connection needs re-authorizing, which no retry will fix. A 404 means the id is not on this account. A 429 means slow down. Never retry a write more than once: the first attempt may have landed.
Full catalog: https://www.withone.ai/knowledge/grist
Integration knowledge by One (withone.ai), licensed under One-Knowledge-1.0. Attribution must be preserved in derivative works.
withoneai