Skip to main content
Server path: /quickbase | Type: Application | PCID required: Yes Applications, tables, records, and fields

Tools

ToolDescription
quickbase_create_recordCreate a new record in a Quickbase table
quickbase_update_recordUpdate an existing record in a Quickbase table
quickbase_delete_recordDelete a record from a Quickbase table
quickbase_query_recordsQuery records from a Quickbase table
quickbase_get_app_infoGet information about a Quickbase application
quickbase_get_table_infoGet information about a Quickbase table
quickbase_list_tablesList all tables in a Quickbase application
quickbase_get_fieldsGet field definitions for a Quickbase table
quickbase_list_reportsList all reports/views for a Quickbase table
quickbase_run_reportRun a saved report/view in a Quickbase table and return its results
quickbase_get_relationshipsGet table relationships (foreign keys, lookups) for a Quickbase table

quickbase_create_record

Create a new record in a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to create record in
fieldDataobjectYesField data as key-value pairs (field ID or name as key)
fieldsToReturnstring[]NoSpecific field IDs to return in response

quickbase_update_record

Update an existing record in a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID containing the record
recordIdstringYesRecord ID to update
fieldDataobjectYesUpdated field data as key-value pairs
fieldsToReturnstring[]NoSpecific field IDs to return in response

quickbase_delete_record

Delete a record from a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID containing the record
recordIdstringYesRecord ID to delete

quickbase_query_records

Query records from a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to query
wherestringNoWHERE clause for filtering records
selectstring[]NoField IDs to select (defaults to all)
sortByobject[]NoSort criteria
topnumberNoMaximum number of records to return
skipnumberNoNumber of records to skip

quickbase_get_app_info

Get information about a Quickbase application

quickbase_get_table_info

Get information about a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to get info for

quickbase_list_tables

List all tables in a Quickbase application

quickbase_get_fields

Get field definitions for a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to get fields for
includeFieldPermsbooleanNofalseInclude field permissions in response

quickbase_list_reports

List all reports/views for a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to list reports for

quickbase_run_report

Run a saved report/view in a Quickbase table and return its results Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID the report belongs to
reportIdstringYesReport ID to run
topnumberNoMaximum number of records to return
skipnumberNoNumber of records to skip

quickbase_get_relationships

Get table relationships (foreign keys, lookups) for a Quickbase table Parameters:
ParameterTypeRequiredDefaultDescription
tableIdstringYesTable ID to get relationships for