> ## Documentation Index
> Fetch the complete documentation index at: https://docs.merchantops.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# List Lakehouse Products

> List lakehouse products with filtering and pagination.

Requires: lakehouse:read permission



## OpenAPI

````yaml /openapi/merchantops-public.json get /api/lakehouse/products
openapi: 3.1.0
info:
  description: >-
    Public API for the MerchantOps product catalog, pricing, and publishing
    surface.
  title: MerchantOps API
  version: 1.0.0
servers:
  - description: Production
    url: https://api.merchantops.ai
security: []
paths:
  /api/lakehouse/products:
    get:
      tags:
        - Product Lakehouse
      summary: List Lakehouse Products
      description: |-
        List lakehouse products with filtering and pagination.

        Requires: lakehouse:read permission
      operationId: list_lakehouse_products
      parameters:
        - description: Search by name or brand
          in: query
          name: search
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Search by name or brand
            title: Search
        - description: Filter by needs_review flag
          in: query
          name: needs_review
          required: false
          schema:
            anyOf:
              - type: boolean
              - type: 'null'
            description: Filter by needs_review flag
            title: Needs Review
        - description: Filter by is_duplicate flag
          in: query
          name: is_duplicate
          required: false
          schema:
            anyOf:
              - type: boolean
              - type: 'null'
            description: Filter by is_duplicate flag
            title: Is Duplicate
        - description: Filter by promoted status
          in: query
          name: promoted
          required: false
          schema:
            anyOf:
              - type: boolean
              - type: 'null'
            description: Filter by promoted status
            title: Promoted
        - description: Filter by source document ID
          in: query
          name: document_id
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Filter by source document ID
            title: Document Id
        - description: Filter by user who uploaded (member_id)
          in: query
          name: created_by
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Filter by user who uploaded (member_id)
            title: Created By
        - description: Filter by exact brand match
          in: query
          name: brand
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Filter by exact brand match
            title: Brand
        - description: Filter by attribute key (e.g., 'color', 'material')
          in: query
          name: attribute_key
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Filter by attribute key (e.g., 'color', 'material')
            title: Attribute Key
        - in: query
          name: limit
          required: false
          schema:
            default: 50
            maximum: 200
            minimum: 1
            title: Limit
            type: integer
        - in: query
          name: skip
          required: false
          schema:
            default: 0
            minimum: 0
            title: Skip
            type: integer
        - in: header
          name: authorization
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            title: Authorization
        - in: header
          name: X-Organization-ID
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            title: X-Organization-Id
        - in: cookie
          name: stytch_session
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            title: Stytch Session
      responses:
        '200':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ListResponse'
          description: Successful Response
        '422':
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
          description: Validation Error
components:
  schemas:
    ListResponse:
      description: Generic list response with pagination.
      properties:
        items:
          items: {}
          title: Items
          type: array
        limit:
          title: Limit
          type: integer
        skip:
          title: Skip
          type: integer
        total:
          title: Total
          type: integer
      required:
        - items
        - total
        - limit
        - skip
      title: ListResponse
      type: object
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          title: Detail
          type: array
      title: HTTPValidationError
      type: object
    ValidationError:
      properties:
        ctx:
          title: Context
          type: object
        input:
          title: Input
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          title: Location
          type: array
        msg:
          title: Message
          type: string
        type:
          title: Error Type
          type: string
      required:
        - loc
        - msg
        - type
      title: ValidationError
      type: object

````