---
title: "Query a MongoDB collection"
method: GET
path: "/query/{collectionName}"
tags: ["Query"]
---

# Query a MongoDB collection

`GET /query/{collectionName}`

Query a MongoDB collection with OData-style parameters.

Examples:
- `GET /api/query/sam_cph_holdings?$filter=CPH eq 'ABC123'&$top=50`
- `GET /api/query/sam_cph_holdings?$filter=contains(CPH,'ABC') and IsDeleted eq false&$orderby=UpdatedAtUtc desc`
- `GET /api/query/sam_cph_holdings?$select=CPH,UpdatedAtUtc&$top=20`

## Path parameters

- `collectionName` string, required

## Query parameters

- `$filter` string
- `$orderby` string
- `$select` string
- `$skip` integer
- `$top` integer
- `$count` boolean

## Response `200`

Query results

- QueryResult
  - `collectionName` string
  - `count` integer
  - `totalCount` integer, nullable
  - `data` object[]
  - `executedAtUtc` string, date-time

## Other responses

- `400` — Invalid query parameters
- `404` — Collection not found
- `499` — Client closed request
- `500` — Internal server error

---

[API](https://skmtc.net/defra/apis/keeper-data-bridge-api.md) · [All operations](https://skmtc.net/defra/apis/keeper-data-bridge-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/defra/keeper-data-bridge-api/revisions/0ab7d7a7a24f/schema)