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

# Filter table rows

> Filters and sorts table rows. Supports up to 10 filter conditions with AND/OR logic. Max 60s execution time.




## OpenAPI

````yaml /openapi/flows.yaml post /tables/{id}/filter
openapi: 3.1.0
info:
  title: Connie Flows API
  version: 1.0.0
  description: >
    API for Tables (structured data), Workflows (automation pipelines), the
    Workflow Builder, triggers, jobs, and streaming state. "Flows" is the
    product name for Tables + Workflows.
servers:
  - url: https://connie.ai/api
    description: Production
security:
  - cookieAuth: []
tags:
  - name: Tables
    description: Table management, views, and configuration
  - name: Table Items
    description: Row (item) operations
  - name: Table Cells
    description: Cell-level read and write operations
  - name: Table Properties
    description: Column management
  - name: Table Bulk
    description: Bulk row operations
  - name: Table Transforms
    description: Formula, split, text-to-columns, and enrichment
  - name: Table Imports
    description: Importing data from CSV, Apollo, Pipe0, and People sources
  - name: Workflows
    description: Workflow CRUD and execution
  - name: Workflow Builder
    description: Node configuration, testing, and AI assistance
  - name: Workflow Results
    description: Workflow result table management
  - name: Triggers
    description: Workflow trigger management
  - name: Jobs
    description: Async background job management
  - name: Streaming State
    description: Streaming job state management
  - name: Saved Prompts
    description: Saved AI prompt library
  - name: Internal
    description: Internal options and formula action endpoints
paths:
  /tables/{id}/filter:
    post:
      tags:
        - Table Items
      summary: Filter table rows
      description: >
        Filters and sorts table rows. Supports up to 10 filter conditions with
        AND/OR logic. Max 60s execution time.
      operationId: filterTableRows
      parameters:
        - $ref: '#/components/parameters/tableId'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                filters:
                  type: array
                  maxItems: 10
                  items:
                    $ref: '#/components/schemas/FilterCondition'
                filter_operator:
                  type: string
                  enum:
                    - AND
                    - OR
                  default: AND
                sorts:
                  type: array
                  items:
                    $ref: '#/components/schemas/SortCondition'
                limit:
                  type: integer
                  minimum: 1
                  maximum: 10000
                  default: 100
                offset:
                  type: integer
                  minimum: 0
                  default: 0
                search:
                  type: string
                  maxLength: 500
      responses:
        '200':
          description: Filtered rows
          content:
            application/json:
              schema:
                type: object
                properties:
                  items:
                    type: array
                    items:
                      $ref: '#/components/schemas/TableItem'
                  totalCount:
                    type: integer
components:
  parameters:
    tableId:
      name: id
      in: path
      required: true
      schema:
        type: string
        format: uuid
  schemas:
    FilterCondition:
      type: object
      required:
        - property_id
        - operator
      properties:
        property_id:
          type: string
        operator:
          type: string
        value: {}
        join:
          type: string
          enum:
            - AND
            - OR
    SortCondition:
      type: object
      required:
        - property_id
        - direction
      properties:
        property_id:
          type: string
        direction:
          type: string
          enum:
            - asc
            - desc
    TableItem:
      type: object
      properties:
        id:
          type: string
          format: uuid
        table_id:
          type: string
        properties:
          type: object
          description: Property values keyed by property ID
        icon:
          type: string
          nullable: true
        cover_image:
          type: string
          nullable: true
        created_at:
          type: string
          format: date-time
        updated_at:
          type: string
          format: date-time
  securitySchemes:
    cookieAuth:
      type: apiKey
      in: cookie
      name: session

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.