quickbase

Applications, tables, records, and fields

Server path: /quickbase | Type: Application | PCID required: Yes

Tools

Tool	Description
quickbase_create_record	Create a new record in a Quickbase table
quickbase_delete_record	Delete a record from a Quickbase table
quickbase_get_app_info	Get information about a Quickbase application
quickbase_get_fields	Get field definitions for a Quickbase table
quickbase_get_relationships	Get table relationships (foreign keys, lookups) for a Quickbase table
quickbase_get_table_info	Get information about a Quickbase table
quickbase_list_reports	List all reports/views for a Quickbase table
quickbase_list_tables	List all tables in a Quickbase application
quickbase_query_records	Query records from a Quickbase table
quickbase_run_report	Run a saved report/view in a Quickbase table and return its results
quickbase_update_record	Update an existing record in 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

Show inputSchema

{
  "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_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

Show inputSchema

{
  "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_get_app_info

Get information about a Quickbase application

Show inputSchema

{
  "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

Show inputSchema

{
  "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_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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "tableId": {
      "type": "string",
      "description": "Table ID to get relationships for"
    }
  },
  "required": [
    "PCID",
    "tableId"
  ]
}

---

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

Show inputSchema

{
  "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_reports

List all reports/views for a Quickbase table

Parameters:

Parameter	Type	Required	Default	Description
tableId	string	Yes	—	Table ID to list reports for

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "tableId": {
      "type": "string",
      "description": "Table ID to list reports for"
    }
  },
  "required": [
    "PCID",
    "tableId"
  ]
}

---

quickbase_list_tables

List all tables in a Quickbase application

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    }
  },
  "required": [
    "PCID"
  ]
}

---

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

Show inputSchema

{
  "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_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

Show inputSchema

{
  "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_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

Show inputSchema

{
  "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"
  ]
}