NocoDB

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

API key20 tools{base_url}

GET

nocodb_get_current_user

Get the NocoDB user associated with the connected API token.

/api/v1/auth/user/me

GET

nocodb_list_bases

List bases visible to the connected NocoDB API token.

/api/v2/meta/bases/

GET

nocodb_get_base_schema

Get schema metadata for one NocoDB base.

/api/v2/meta/bases/{baseId}

1 parameter

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.

GET

nocodb_list_tables

List tables in a NocoDB base or in a specific base source.

/api/v2/meta/bases/{baseId}/{sourceId}/tables

2 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
sourceId	string	required	The NocoDB source ID.

GET

nocodb_get_table_metadata

Get metadata for one NocoDB table, including columns and views when available.

/api/v2/meta/tables/{tableId}

1 parameter

Param	Type	Required	Description
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.

DELETE

nocodb_delete_table

Delete a NocoDB table using the v3 metadata API.

/api/v3/meta/bases/{baseId}/tables/{tableId}

2 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.

GET

nocodb_list_table_views

List views for a NocoDB table using the v3 metadata API.

/api/v3/meta/bases/{baseId}/tables/{tableId}/views

2 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.

POST

nocodb_create_table_view

Create a view for a NocoDB table using the v3 metadata API.

/api/v3/meta/bases/{baseId}/tables/{tableId}/views

3 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
view	object	required	The NocoDB v3 view creation payload.

POST

nocodb_create_table_field

Create a field in a NocoDB table using the v3 metadata API.

/api/v3/meta/bases/{baseId}/tables/{tableId}/fields

3 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
field	object	required	The NocoDB v3 field creation payload.

GET

nocodb_list_records

List records from one NocoDB table with optional where, sort, field, limit, and offset parameters.

/api/v2/tables/{tableId}/records

8 parameters

Param	Type	Required	Description
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
limit	integer	optional	The maximum number of records to return.
offset	integer	optional	The zero-based offset for pagination.
where	string	optional	A NocoDB where expression, such as (Status,eq,Done).
sort	string	optional	A comma-separated sort expression. Prefix a field with - for descending sort.
fields	string	optional	A comma-separated list of fields to include.
viewId	string	optional	The NocoDB view ID used to restrict records to a specific view.
shuffle	boolean	optional	Whether to shuffle the returned records.

GET

nocodb_count_records

Count records in one NocoDB table, optionally filtered by a where expression.

/api/v2/tables/{tableId}/records/count

3 parameters

Param	Type	Required	Description
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
where	string	optional	A NocoDB where expression, such as (Status,eq,Done).
viewId	string	optional	The NocoDB view ID used to restrict records to a specific view.

GET

nocodb_read_record

Read one record from a NocoDB table by record ID.

/api/v2/tables/{tableId}/records/{recordId}

3 parameters

Param	Type	Required	Description
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
recordId	string	required	The NocoDB record ID value.
fields	string	optional	A comma-separated list of fields to include.

DELETE

nocodb_delete_records

Delete one or more records from a NocoDB table.

/api/v2/tables/{tableId}/records

2 parameters

Param	Type	Required	Description
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
rows	array	required	Records to delete. Each record must include its NocoDB record ID.

GET

nocodb_list_table_records

List records from one NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/records

10 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
page	integer	optional	The one-based page number to retrieve.
nestedPage	integer	optional	The one-based page number for nested linked record data.
pageSize	integer	optional	The maximum number of records to return.
where	string	optional	A NocoDB v3 where expression, such as (Status,eq,Done).
sort	string	optional	A NocoDB v3 sort expression.
fields	string	optional	A comma-separated list or JSON array string of fields to include.
viewId	string	optional	The NocoDB view ID used to restrict records to a specific view.
linksAsLtar	boolean	optional	Whether Links fields should return full linked record data.

GET

nocodb_count_table_records

Count records in one NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/count

4 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
where	string	optional	A NocoDB v3 where expression, such as (Status,eq,Done).
viewId	string	optional	The NocoDB view ID used to restrict records to a specific view.

GET

nocodb_read_table_record

Read one record from a NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/records

5 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
recordId	string	required	The NocoDB record ID value.
fields	string	optional	A comma-separated list or JSON array string of fields to include.
linksAsLtar	boolean	optional	Whether Links fields should return full linked record data.

POST

nocodb_create_table_records

Create one or more records in a NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/{suffix}

4 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
records	array	required	Records to create in the table.
suffix	string	required	Path parameter: suffix

PATCH

nocodb_update_table_records

Update one or more records in a NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/{suffix}

4 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
records	array	required	Records to update in the table.
suffix	string	required	Path parameter: suffix

DELETE

nocodb_delete_table_records

Delete one or more records from a NocoDB table using the v3 data API.

/api/v3/data/{baseId}/{tableId}/{suffix}

4 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
records	array	required	Records to delete from the table.
suffix	string	required	Path parameter: suffix

POST

nocodb_upsert_table_records

Create or update records in a NocoDB table by matching up to three fields using the v3 data API.

/api/v3/data/{baseId}/{tableId}/records

4 parameters

Param	Type	Required	Description
baseId	string	required	The NocoDB base ID.
tableId	string	required	The NocoDB table ID, such as m1abcdefghijk.
fieldsToMergeOn	array	required	Field titles or IDs used to match existing records.
records	array	required	Records to create or update.