> ## 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 Records

> Retrieve a list of all records in the specified table.



## OpenAPI

````yaml openapi.yaml GET /databases/{databaseId}/tables/{tableId}/records
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:
    parameters:
      - name: databaseId
        in: path
        required: true
        schema:
          type: string
      - name: tableId
        in: path
        required: true
        schema:
          type: string
    get:
      tags:
        - Records
      summary: Get Records
      description: Retrieve a list of all records in the specified table.
      operationId: getRecords
      parameters:
        - name: offset
          in: query
          schema:
            type: integer
            default: 0
        - name: limit
          in: query
          schema:
            type: integer
            default: 10
        - 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
        - name: viewId
          in: query
          description: Filter records by a specific view.
          schema:
            type: string
      responses:
        '200':
          description: A paginated list of records.
          content:
            application/json:
              schema:
                type: object
                properties:
                  data:
                    type: array
                    items:
                      $ref: '#/components/schemas/Record'
                  metadata:
                    $ref: '#/components/schemas/RecordListMetadata'
        '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
    RecordListMetadata:
      type: object
      properties:
        offset:
          type: integer
        limit:
          type: integer
        total:
          type: integer
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: Softr-Api-Key

````