Search records

Records whose searchable report fields contain your text.

GET https://cotlet.dev/api/v1/quickbase/records/search

read

Types your text into the Search box on the table home page and returns the matching rows. The Search box only checks fields that the report marks as searchable, so a value in another field is not found. Pass a report to search inside it; without one, the table's default report is used. Returns rows like run_report, with Record ID# for get_record and update_record.

Parameters

Parameters: search_records
NameTypeDescription
app string required string App name as it appears under My apps, e.g. 'Field Ops'.
table string required string Table name as it appears in the app's sidebar, e.g. 'Work orders'.
query string required string Text to search for.
report string string Report to search in. Default: the table's default report.
limit integer integer Rows to return in this call.
cursor string string Next page cursor from the previous call.

Request

cURL
curl "https://cotlet.dev/api/v1/quickbase/records/search?app=Field+Ops&table=Work+orders&query=query" \
  -H "Authorization: Bearer $COTLET_API_KEY"
Python
result = client.call("quickbase", "search_records", {"app":"Field Ops","table":"Work orders","query":"query"})
Node.js
const result = await cotlet.call('quickbase', 'search_records', {"app":"Field Ops","table":"Work orders","query":"query"});
CLI
cotlet call quickbase search_records --data '{"app":"Field Ops","table":"Work orders","query":"query"}'

Example response

JSON

{
  "report": "List All",
  "columns": [
    "Title",
    "Site",
    "Assigned to",
    "Due"
  ],
  "rows": [
    {
      "record_id": 1042,
      "values": [
        "Replace pump seal",
        "Plant North",
        "Sam Ortiz",
        "2026-10-17"
      ]
    }
  ],
  "next_cursor": null
}

Sign in once. Your agent does the rest.

Sign up and add the apps you need. Free 7-day trial with 2,000 credits, no card needed.