v5

latestOpenAPI 3.0.3raw.githubusercontent.com2026-03-27485380.4 KB
Query

Query a MongoDB collection

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
get/query/{collectionName}

Path parameters

collectionNamestring required

Name of the collection (e.g., 'sam_cph_holdings')

Query parameters

$filterstring

OData $filter expression

$orderbystring

OData $orderby expression (e.g., 'UpdatedAtUtc desc')

$selectstring

OData $select expression (e.g., 'CPH,UpdatedAtUtc')

$skipinteger
$topinteger

Max 1000, default 100

$countboolean

Include total count in response

Response

Query results

collectionNamestring
countinteger
totalCountinteger nullable
dataobject[]
executedAtUtcstring date-time