What can you do with it?

Create and manage custom applications and workflows using Quickbase, including retrieving table information, querying records, and inserting new data into your custom applications.

How to use it?

Basic Command Structure

/your-quickbase-connection [action] [required-parameters] [optional-parameters]

Parameters

Required:

  • action - The operation to perform (get-tables, query-records, query-by-id, insert-records)

Optional:

  • app-id - Quickbase application ID
  • table-id - Quickbase table ID
  • limit - Number of records to retrieve (default: 100)

Tools

Get Tables

Retrieve a list of tables in the specified Quickbase application

Parameters:

  • app-id (required) - The Quickbase application ID

Example:

/your-quickbase-connection
action: get-tables
app-id: bq7abc123

Response:

{
  "output": [
    {
      "alias": "_DBID_TABLE1",
      "created": "2024-10-23T05:41:27Z",
      "defaultSortFieldId": 2,
      "defaultSortOrder": "DESC",
      "description": "",
      "id": "buk58j6w3",
      "keyFieldId": 3,
      "name": "table1",
      "nextFieldId": 9,
      "nextRecordId": 5,
      "pluralRecordName": "table1S",
      "singleRecordName": "table1",
      "sizeLimit": "500 MB",
      "spaceRemaining": "500 MB",
      "spaceUsed": "1 KB",
      "updated": "2024-10-30T17:49:46Z"
    }
  ]
}

Query All Records

Retrieve all records from a specified table

Parameters:

  • table-id (required) - The table ID to query
  • limit (optional) - Maximum number of records to retrieve

Example:

/your-quickbase-connection
action: query-records
table-id: buk58j6w3
limit: 100

Response:

{
  "output": {
    "data": [
      {
        "7": {
          "value": "dev23"
        },
        "8": {
          "value": "dummy@test.com"
        }
      },
      {
        "7": {
          "value": "John"
        },
        "8": {
          "value": "Doe"
        }
      }
    ],
    "fields": [
      {
        "id": 7,
        "label": "Pinkfish Field 1",
        "type": "text"
      },
      {
        "id": 8,
        "label": "Pinkfish Field 12",
        "type": "text"
      }
    ],
    "metadata": {
      "numFields": 2,
      "numRecords": 4,
      "skip": 0,
      "totalRecords": 4
    }
  }
}

Query Records By ID

Retrieve specific records by their ID

Parameters:

  • table-id (required) - The table ID to query
  • record-id (required) - The specific record ID to retrieve
  • limit (optional) - Maximum number of records to retrieve

Example:

/your-quickbase-connection
action: query-by-id
table-id: buk58j6w3
record-id: 2
limit: 100

Response:

{
  "output": {
    "data": [
      {
        "7": {
          "value": "John"
        },
        "8": {
          "value": "Doe"
        }
      }
    ],
    "fields": [
      {
        "id": 7,
        "label": "Pinkfish Field 1",
        "type": "text"
      },
      {
        "id": 8,
        "label": "Pinkfish Field 12",
        "type": "text"
      }
    ],
    "metadata": {
      "numFields": 2,
      "numRecords": 1,
      "skip": 0,
      "totalRecords": 1
    }
  }
}

Insert Records

Insert new records into a table

Parameters:

  • table-id (required) - The table ID to insert records into
  • field-data (required) - The field data to insert (field ID and value pairs)

Example:

/your-quickbase-connection
action: insert-records
table-id: buk58j6w3
field-data: Field 7: John, Field 8: Doe

Response:

{
  "output": {
    "data": [],
    "metadata": {
      "createdRecordIds": [
        6
      ],
      "totalNumberOfRecordsProcessed": 1,
      "unchangedRecordIds": [],
      "updatedRecordIds": []
    }
  }
}

Notes

Quickbase uses field IDs (numbers) to identify table columns. When querying records, data is returned using these field IDs as keys. The application ID is required for table operations, and table IDs are required for record operations.