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

# Get Single Record

> Retrieve details of a specific record by its ID.



## OpenAPI

````yaml openapi.yaml GET /databases/{databaseId}/tables/{tableId}/records/{recordId}
openapi: 3.0.0
info:
  title: Softr Database API
  description: >
    Public API to communicate with Softr Databases. The API follows REST
    semantics and uses JSON to encode objects.


    **Rate Limiting:**

    All calls are subject to rate limiting. On exceeding the limit, you will
    receive a 429 HTTP Response Status Code.

    - **Reads** (GET, POST /search): 40 requests/second per token.

    - **Writes** (POST, PUT, PATCH, DELETE): 30 requests/second per token.
  version: 1.0.0
servers:
  - url: https://tables-api.softr.io/api/v1
    description: Production Server
security:
  - ApiKeyAuth: []
tags:
  - name: Databases
    description: Operations related to Softr databases.
  - name: Tables
    description: Operations related to tables within a database.
  - name: Table Fields
    description: Operations to manage fields within a table.
  - name: Records
    description: Operations to manage records (rows) within a table.
paths:
  /databases/{databaseId}/tables/{tableId}/records/{recordId}:
    parameters:
      - name: databaseId
        in: path
        required: true
        schema:
          type: string
      - name: tableId
        in: path
        required: true
        schema:
          type: string
      - name: recordId
        in: path
        required: true
        schema:
          type: string
    get:
      tags:
        - Records
      summary: Get Single Record
      description: Retrieve details of a specific record by its ID.
      operationId: getRecordById
      parameters:
        - name: fieldNames
          in: query
          description: >-
            If true, use field names as keys in the fields object instead of
            field IDs.
          schema:
            type: boolean
            default: false
      responses:
        '200':
          description: Record details.
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    $ref: '#/components/schemas/Record'
        '429':
          description: Rate limit exceeded.
components:
  schemas:
    Record:
      type: object
      properties:
        id:
          type: string
        tableId:
          type: string
        fields:
          type: object
          description: A map of Field IDs to their values for this record.
          additionalProperties: true
        createdAt:
          type: string
          format: date-time
        updatedAt:
          type: string
          format: date-time
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: Softr-Api-Key

````