rocketkind
Database

NocoDB

NocoDB is an open-source spreadsheet database — bases (projects) hold tables, tables hold records.

Authentication

  • API key

Actions

Generic API request. Call any NocoDB API endpoint on this connection, for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to fill.

  • Count recordsCount records in a NocoDB table (GET api/v2/tables/{tableId}/records/count), optionally scoped by a where-filter.
  • Create recordsCreate one or more records in a NocoDB table (POST api/v2/tables/{tableId}/records).
  • Delete recordsDestructiveDelete one or more records from a NocoDB table (DELETE api/v2/tables/{tableId}/records).
  • Get recordRead one row from a NocoDB table by its primary-key value — use it to re-read a record after a write, or to resolve a stored id back to its field values.
  • List basesList the NocoDB bases (projects) the API token can access (GET api/v2/meta/bases).
  • List recordsList records in a NocoDB table (GET api/v2/tables/{tableId}/records), with optional field selection, where-filter, sort, limit and offset.
  • List tablesList the tables inside one NocoDB base, so a record read or write can be addressed by table id.
  • Update recordsDestructiveUpdate one or more records in a NocoDB table (PATCH api/v2/tables/{tableId}/records).

Triggers

  • New or updated recordStarts when a record is created or an existing record is updated in a NocoDB table.
  • Record created (webhook)Starts immediately when a new row is inserted into a NocoDB table, delivered in real time via a NocoDB webhook instead of polling.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.