GristInstall

Summary

Retrieve multiple records from a specific table within a Grist document, with optional filtering, sorting, and limit controls.

Inputs

• Organization (required) — Select the Grist organization from which to fetch records, either from a list or by specifying its ID.
• Workspace (required) — Select the workspace within the chosen organization, either from a list or by specifying its ID.
• Document (required) — Select the document within the organization and workspace, either from a list or by specifying its ID.
• Table (required) — Select the table within the document from which records will be retrieved, either from a list or by specifying its ID.
• Return All — Boolean to specify whether to return all matching records or restrict to a set limit.
• Limit — Maximum number of records to return if 'Return All' is false; minimum value is 1.
• Options — Additional settings including filters to only return rows matching specified column values, sorting preferences on columns with ascending or descending direction, and an option to include hidden columns in the results.

Output shape

a list of records each as a JSON object combining the record's ID and its fields

The operation returns an array of JSON objects where each contains the record 'id' and fields as key-value pairs. If no records match, an empty list is returned. Filtering supports multiple conditions combined as AND. Sorting and hidden column inclusion are optional. Pagination applies if 'Return All' is false.

Examples

Example 1: Fetch up to 100 records from the 'Projects' table in a specified Grist document, filtered to those where the 'Status' column equals 'Active', sorted by 'Due Date' descending.

Set Organization, Workspace, Document, and Table parameters accordingly. Set 'Return All' to false and 'Limit' to 100. Add a filter for column 'Status' with value 'Active'. Add a sort order on column 'Due Date' descending.

Links

• n8n community nodes installation guide