COcontext
webdbs

Query rows

Changed on

Filters and sorts collection rows. Use next_cursor to load more results.

post/webdbs/collections/{collection_id}/query

Request

  • Base URL
    https://api.context.dev/v1
  • URL
    https://api.context.dev/v1/webdbs/collections/{collection_id}/query
  • Auth
    HTTP bearer

Path parameters

collection_idstring required

Collection ID.

Example:col_123

Request body

whereobject

Filters rows by field values. Supports comparisons, lists, text matching, and boolean groups.

selectstring[]

Fields to include in each row. _id is always included.

limitinteger

Maximum rows to return. Defaults to 25.

cursorstring

Pagination cursor from a previous query.

tagsstring[]

Optional tags for tracking usage. Up to 20 tags, each 1 to 50 characters.

Example request

{
  "tags": [
    "production",
    "team-alpha"
  ]
}

Response

A page of matching rows

has_moreboolean required

Whether another page is available.

next_cursorstring nullable required

Cursor for the next page, or null at the end.

scan_limitedboolean

Whether the query stopped before scanning every possible match.

Example response

{
  "data": [
    {
      "_id": "row_1a2b3c",
      "_collection": "col_123",
      "_meta": {
        "source": {
          "target_id": "tgt_123"
        }
      }
    }
  ]
}

Changes

  • 182f532c2552Revision changes
    • warning

      added the new WEBSITE_BLOCKED enum value to the response property for the response status

    • warning

      added the new WEBSITE_BLOCKED enum value to the response property for the response status

    • warning

      added the new WEBSITE_BLOCKED enum value to the response property for the response status

  • 3c6a01ba967fRevision changes
    • warning

      added the new COLD_DOMAIN_TIMEOUT_TOO_LOW enum value to the response property for the response status

    • warning

      added the new COLD_DOMAIN_TIMEOUT_TOO_LOW enum value to the response property for the response status

    • warning

      added the new COLD_DOMAIN_TIMEOUT_TOO_LOW enum value to the response property for the response status