quickbase_query_records
Retrieve and filter records from a QuickBase table using specific criteria, select fields, and apply sorting for efficient data management. Simplify querying with customizable options.
Instructions
Query records from a table with optional filtering and sorting
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| select | No | Field IDs to select | |
| skip | No | Number of records to skip | |
| sortBy | No | Sort criteria | |
| tableId | Yes | Table ID to query | |
| top | No | Max number of records | |
| where | No | QuickBase query filter (e.g., "{6.EX.'John'}") |
Input Schema (JSON Schema)
{
"properties": {
"select": {
"description": "Field IDs to select",
"items": {
"type": "number"
},
"type": "array"
},
"skip": {
"description": "Number of records to skip",
"type": "number"
},
"sortBy": {
"description": "Sort criteria",
"items": {
"properties": {
"fieldId": {
"type": "number"
},
"order": {
"enum": [
"ASC",
"DESC"
],
"type": "string"
}
},
"type": "object"
},
"type": "array"
},
"tableId": {
"description": "Table ID to query",
"type": "string"
},
"top": {
"description": "Max number of records",
"type": "number"
},
"where": {
"description": "QuickBase query filter (e.g., \"{6.EX.'John'}\")",
"type": "string"
}
},
"required": [
"tableId"
],
"type": "object"
}