Grist

Grist integration (Productivity, Data). Imported from open-connector.

API key8 toolshttps://api.getgrist.com/api

GET

grist_list_workspaces

List the Grist workspaces and documents that the authenticated API key can access on the current Grist site.

/workspaces

GET

grist_get_document

Fetch metadata for a Grist document by document ID or short URL alias.

/docs/{docId}

1 parameter

Param	Type	Required	Description
docId	string	required	The Grist document identifier.

GET

grist_list_tables

List the tables defined in a Grist document.

/docs/{docId}/tables

1 parameter

Param	Type	Required	Description
docId	string	required	The Grist document identifier.

GET

grist_list_columns

List the columns defined in a Grist table.

/docs/{docId}/tables/{tableId}/columns

3 parameters

Param	Type	Required	Description
docId	string	required	The Grist document identifier.
tableId	string	required	The Grist table identifier.
hidden	boolean	optional	Whether hidden metadata columns should be included.

GET

grist_list_records

List records from a Grist table with optional filtering, sorting, limits, and hidden-column inclusion.

/docs/{docId}/tables/{tableId}/records

6 parameters

Param	Type	Required	Description
docId	string	required	The Grist document identifier.
tableId	string	required	The Grist table identifier.
hidden	boolean	optional	Whether hidden metadata columns should be included.
sort	string	optional	Comma-separated columns to sort by. Prefix with '-' for descending.
filter	string	optional	JSON string that maps column IDs to allowed values arrays, such as '{"pet":["ca…
limit	integer	optional	Maximum number of records to return. Use 0 for no limit.

POST

grist_add_records

Add one or more records to a Grist table.

/docs/{docId}/tables/{tableId}/records

4 parameters

Param	Type	Required	Description
docId	string	required	The Grist document identifier.
tableId	string	required	The Grist table identifier.
noparse	boolean	optional	Whether Grist should store values without automatic parsing.
records	array	required	Records to add to the target table.

PATCH

grist_update_records

Update one or more existing Grist records by row ID.

/docs/{docId}/tables/{tableId}/records

4 parameters

Param	Type	Required	Description
docId	string	required	The Grist document identifier.
tableId	string	required	The Grist table identifier.
noparse	boolean	optional	Whether Grist should store values without automatic parsing.
records	array	required	Records to update in the target table.

POST

grist_delete_records

Delete one or more records from a Grist table by row ID.

/docs/{docId}/tables/{tableId}/records/delete

3 parameters

Param	Type	Required	Description
docId	string	required	The Grist document identifier.
tableId	string	required	The Grist table identifier.
rowIds	array	required	Row IDs to delete from the target table.