/quickbase | Type: Application | PCID required: Yes
Applications, tables, records, and fields
Tools
| Tool | Description |
|---|---|
quickbase_create_record | Create a new record in a Quickbase table |
quickbase_update_record | Update an existing record in a Quickbase table |
quickbase_delete_record | Delete a record from a Quickbase table |
quickbase_query_records | Query records from a Quickbase table |
quickbase_get_app_info | Get information about a Quickbase application |
quickbase_get_table_info | Get information about a Quickbase table |
quickbase_list_tables | List all tables in a Quickbase application |
quickbase_get_fields | Get field definitions for a Quickbase table |
quickbase_list_reports | List all reports/views for a Quickbase table |
quickbase_run_report | Run a saved report/view in a Quickbase table and return its results |
quickbase_get_relationships | Get table relationships (foreign keys, lookups) for a Quickbase table |
quickbase_create_record
Create a new record in a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to create record in |
fieldData | object | Yes | — | Field data as key-value pairs (field ID or name as key) |
fieldsToReturn | string[] | No | — | Specific field IDs to return in response |
quickbase_update_record
Update an existing record in a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID containing the record |
recordId | string | Yes | — | Record ID to update |
fieldData | object | Yes | — | Updated field data as key-value pairs |
fieldsToReturn | string[] | No | — | Specific field IDs to return in response |
quickbase_delete_record
Delete a record from a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID containing the record |
recordId | string | Yes | — | Record ID to delete |
quickbase_query_records
Query records from a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to query |
where | string | No | — | WHERE clause for filtering records |
select | string[] | No | — | Field IDs to select (defaults to all) |
sortBy | object[] | No | — | Sort criteria |
top | number | No | — | Maximum number of records to return |
skip | number | No | — | Number of records to skip |
quickbase_get_app_info
Get information about a Quickbase applicationquickbase_get_table_info
Get information about a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to get info for |
quickbase_list_tables
List all tables in a Quickbase applicationquickbase_get_fields
Get field definitions for a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to get fields for |
includeFieldPerms | boolean | No | false | Include field permissions in response |
quickbase_list_reports
List all reports/views for a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to list reports for |
quickbase_run_report
Run a saved report/view in a Quickbase table and return its results Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID the report belongs to |
reportId | string | Yes | — | Report ID to run |
top | number | No | — | Maximum number of records to return |
skip | number | No | — | Number of records to skip |
quickbase_get_relationships
Get table relationships (foreign keys, lookups) for a Quickbase table Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
tableId | string | Yes | — | Table ID to get relationships for |

