Skip to main content

Query products with filters and pagination

POST 
/products/query

Query products using filters, sorting, and pagination. This endpoint supports a maximum of 10,000 results.

Filter: The filter object must have exactly one key. It can be a property filter (e.g. id, search, brand, publicCategories, medipimCategories, organization, deleted, status, productFamilies, media, attributes, dietaryRestrictions, colors, createdAt, touchedAt / updatedSince, hasContent, hasCorrections, publicPrice, regulatedPrice, gtin, ean, activeIngredient, atc) or a compound filter (and, or, not). See the ProductFilter schema for details. Additional region-specific filters may also be available.

Pagination Limit: This endpoint can only return up to 10,000 products. If your query matches more than 10,000 products:

  • The total field in the response will be capped at 10,000
  • The totalExceedsLimit field will be set to true
  • Use the /products/stream endpoint to retrieve all matching products
  • Pass compact=true to return only product ids and the regional code. The compact path is served from the search index and does not hydrate full product documents. For result sets larger than 10,000, use /products/stream?compact=true instead.
  • If you only need Medipim product ids, use /products/query-ids (or /products/stream-ids when the result set exceeds 10,000).

Request​

Responses​

Successful operation