Documentation Index
Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
Use this file to discover all available pages before exploring further.
Server path: /quickbase | Type: Application | PCID required: Yes
| 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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to create record in"
},
"fieldData": {
"type": "object",
"additionalProperties": true,
"description": "Field data as key-value pairs (field ID or name as key)"
},
"fieldsToReturn": {
"type": "array",
"items": {
"type": "string"
},
"description": "Specific field IDs to return in response"
}
},
"required": [
"PCID",
"tableId",
"fieldData"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID containing the record"
},
"recordId": {
"type": "string",
"description": "Record ID to update"
},
"fieldData": {
"type": "object",
"additionalProperties": true,
"description": "Updated field data as key-value pairs"
},
"fieldsToReturn": {
"type": "array",
"items": {
"type": "string"
},
"description": "Specific field IDs to return in response"
}
},
"required": [
"PCID",
"tableId",
"recordId",
"fieldData"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID containing the record"
},
"recordId": {
"type": "string",
"description": "Record ID to delete"
}
},
"required": [
"PCID",
"tableId",
"recordId"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to query"
},
"where": {
"type": "string",
"description": "WHERE clause for filtering records"
},
"select": {
"type": "array",
"items": {
"type": "string"
},
"description": "Field IDs to select (defaults to all)"
},
"sortBy": {
"type": "array",
"items": {
"type": "object",
"properties": {
"fieldId": {
"type": "string",
"description": "Field ID to sort by"
},
"order": {
"type": "string",
"enum": [
"ASC",
"DESC"
],
"description": "Sort order"
}
}
},
"description": "Sort criteria"
},
"top": {
"type": "number",
"description": "Maximum number of records to return"
},
"skip": {
"type": "number",
"description": "Number of records to skip"
}
},
"required": [
"PCID",
"tableId"
]
}
quickbase_get_app_info
Get information about a Quickbase application
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
}
},
"required": [
"PCID"
]
}
quickbase_get_table_info
Get information about a Quickbase table
Parameters:
| Parameter | Type | Required | Default | Description |
|---|
tableId | string | Yes | — | Table ID to get info for |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to get info for"
}
},
"required": [
"PCID",
"tableId"
]
}
quickbase_list_tables
List all tables in a Quickbase application
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
}
},
"required": [
"PCID"
]
}
quickbase_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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to get fields for"
},
"includeFieldPerms": {
"type": "boolean",
"default": false,
"description": "Include field permissions in response"
}
},
"required": [
"PCID",
"tableId"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to list reports for"
}
},
"required": [
"PCID",
"tableId"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID the report belongs to"
},
"reportId": {
"type": "string",
"description": "Report ID to run"
},
"top": {
"type": "number",
"description": "Maximum number of records to return"
},
"skip": {
"type": "number",
"description": "Number of records to skip"
}
},
"required": [
"PCID",
"tableId",
"reportId"
]
}
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 |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"tableId": {
"type": "string",
"description": "Table ID to get relationships for"
}
},
"required": [
"PCID",
"tableId"
]
}
