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

# Update a connection record

> Updates a single row by key. Only supported for connection types that
allow writes (currently SQL Server); other connection types return 400.




## OpenAPI

````yaml /api-reference/openapi.yaml patch /api/v1/connections/{connection_id}/records
openapi: 3.1.0
info:
  title: Fluent API
  version: 1.0.0
  summary: Run Fluent agents and access connected data.
  description: |
    The public Fluent API powers the CLI and customer integrations.
    Most successful responses wrap their payload in a data property. Errors
    contain detail and status properties without that envelope.
servers:
  - url: https://www.fluenterp.com
    description: Production
security:
  - ApiKey: []
  - BearerCredential: []
tags:
  - name: Discovery
    description: Find the API, its scopes, and its policies without a credential.
  - name: Agents
    description: Discover agents and prepare their input files.
  - name: Runs
    description: Start and monitor asynchronous agent runs.
  - name: Documents
    description: Read, process, and delete documents produced by agents.
  - name: Connections
    description: Discover connected systems and read their records.
  - name: Databases
    description: Discover queryable databases and schemas.
  - name: Tables
    description: Read records from a queryable table.
  - name: Queries
    description: Run queries against accessible databases.
  - name: Utilities
    description: Search the web and manage conversation resources.
  - name: MCP
    x-group: Model Context Protocol
    description: Connect an external MCP client to an agent's tools.
paths:
  /api/v1/connections/{connection_id}/records:
    patch:
      tags:
        - Connections
      summary: Update a connection record
      description: |
        Updates a single row by key. Only supported for connection types that
        allow writes (currently SQL Server); other connection types return 400.
      operationId: updateConnectionRecord
      parameters:
        - $ref: '#/components/parameters/ConnectionId'
        - $ref: '#/components/parameters/StableEgress'
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              required:
                - entity
                - key_column
                - key_value
                - values
              properties:
                entity:
                  type: string
                  description: Table to update, as "schema.table".
                key_column:
                  type: string
                  description: Column identifying the row to update.
                key_value:
                  oneOf:
                    - type: string
                    - type: number
                  description: Value of key_column for the target row.
                values:
                  type: object
                  additionalProperties:
                    oneOf:
                      - type: string
                      - type: number
                      - type: boolean
                      - type: 'null'
                  description: Column/value pairs to set.
            examples:
              resetStatus:
                value:
                  entity: dbo.IDEAS_ISSUEMTL
                  key_column: RegNum
                  key_value: 127
                  values:
                    ProcStatus: 0
      responses:
        '200':
          description: Rows affected
          content:
            application/json:
              schema:
                type: object
                properties:
                  rows_affected:
                    type: integer
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/RateLimited'
components:
  parameters:
    ConnectionId:
      name: connection_id
      in: path
      required: true
      description: Connection ID.
      schema:
        type: string
        format: uuid
    StableEgress:
      name: X-Fl-Egress
      in: header
      required: false
      description: |
        Optional. Set to `true` to route this request through a stable,
        allowlistable egress IP instead of the default path — needed for an
        on-premise connection (e.g. a customer's own SQL Server) whose
        firewall allowlists by IP. Same operation and response either way.
        The same `fl-*` key also works by calling this same operation
        directly at `https://api-ecs.fluenterp.com/v1/connections/{id}/records`,
        for the same stable-egress guarantee without this header.
      schema:
        type: boolean
  responses:
    BadRequest:
      description: Invalid request
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    Unauthorized:
      description: Missing, invalid, expired, or unsupported credential
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    NotFound:
      description: Resource not found or not visible to the caller
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    RateLimited:
      description: Rate limit exceeded
      headers:
        RateLimit-Limit:
          description: Requests allowed in the current window.
          schema:
            type: integer
        RateLimit-Remaining:
          description: Requests remaining in the current window.
          schema:
            type: integer
        RateLimit-Reset:
          description: Seconds until the current window resets.
          schema:
            type: integer
        Retry-After:
          description: Seconds to wait before retrying.
          schema:
            type: integer
        x-ratelimit-limit:
          description: Legacy alias of RateLimit-Limit.
          schema:
            type: integer
        x-ratelimit-remaining:
          description: Legacy alias of RateLimit-Remaining.
          schema:
            type: integer
        x-ratelimit-reset:
          description: |
            Unix timestamp (seconds) at which the current window resets. Unlike
            RateLimit-Reset, which is a delta.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
  schemas:
    Error:
      type: object
      required:
        - detail
      properties:
        detail:
          type: string
          description: Human-readable failure detail.
        status:
          type: integer
          description: HTTP status code.
      additionalProperties: true
      example:
        detail: Agent not found
        status: 404
  securitySchemes:
    ApiKey:
      type: apiKey
      in: header
      name: X-API-Key
      description: A Fluent API key beginning with fl-.
    BearerCredential:
      type: http
      scheme: bearer
      bearerFormat: Fluent API key or OAuth access token
      description: |
        A Fluent API key beginning with fl-, or an OAuth access token beginning
        with flpt_ on operations that support OAuth.

````