OCNORA
Start free

Grist

Databases & warehousesAPI keycredential probe

Read and write the records of a Grist document's tables, and list its tables and columns, through the Grist REST API.

OCNORA ships 7 typed Grist operations. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run. Anything not covered by a typed node reaches https://docs.getgrist.com/api through the HTTP node with the same credential.

Connect Grist freeGrist API docs ↗

Operations 7

  • Add Records
    Add one or more rows to a table and return the ids Grist assigned.
    grist.add_records
  • Delete Records
    Remove rows from a table by their Grist row ids.
    grist.delete_records
  • List Columns
    List the columns of a table, with each column's type and label.
    grist.list_columns
  • List Records
    Read the rows of a table, optionally filtered, sorted and limited.
    grist.list_records
  • List Tables
    List the tables in a Grist document, optionally with their columns.
    grist.list_tables
  • Update Records
    Change the cell values of existing rows, each addressed by its row id.
    grist.update_records
  • Add or Update Records
    Add rows or update the ones already matching, using a 'require' matcher per record instead of a row id.
    grist.upsert_records

More in Databases & warehouses

Run your first Grist workflow today.

Create a free workspace, add the connection, pick a template or describe the workflow to Build with AI. Workflow Health checks it before it runs.

Start freeBook a demo