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

# Get table data

> Get data from a specific table in the branch's database with pagination



## OpenAPI

````yaml https://api.specular.dev/openapi.json get /branches/{id}/tables/{tableName}
openapi: 3.0.0
info:
  title: Specular API
  description: Backend-as-a-Service API for managing projects and branches
  version: 1.0.0
servers:
  - url: https://api.specular.dev
    description: Production server
  - url: http://localhost:3000
    description: Development server
security:
  - bearerAuth: []
paths:
  /branches/{id}/tables/{tableName}:
    get:
      tags:
        - Branches
      summary: Get table data
      description: Get data from a specific table in the branch's database with pagination
      parameters:
        - schema:
            type: number
            minimum: 1
            maximum: 1000
          in: query
          name: limit
          required: false
          description: 'Number of rows to return (default: 50, max: 1000)'
        - schema:
            type: number
            minimum: 0
          in: query
          name: offset
          required: false
          description: 'Number of rows to skip (default: 0)'
        - schema:
            type: string
          in: path
          name: id
          required: true
          description: Branch ID
        - schema:
            type: string
          in: path
          name: tableName
          required: true
          description: Table name
      responses:
        '200':
          description: Table data
          content:
            application/json:
              schema:
                description: Table data
                type: object
                properties:
                  rows:
                    type: array
                    items:
                      type: object
                      additionalProperties: true
                  totalCount:
                    type: number
                  limit:
                    type: number
                  offset:
                    type: number
        '400':
          description: Branch has no database or invalid parameters
          content:
            application/json:
              schema:
                description: Branch has no database or invalid parameters
                type: object
                properties:
                  error:
                    type: string
                  message:
                    type: string
        '401':
          description: Authentication required
          content:
            application/json:
              schema:
                description: Authentication required
                type: object
                properties:
                  error:
                    type: string
        '404':
          description: Branch or table not found
          content:
            application/json:
              schema:
                description: Branch or table not found
                type: object
                properties:
                  error:
                    type: string
                  message:
                    type: string
        '500':
          description: Internal server error
          content:
            application/json:
              schema:
                description: Internal server error
                type: object
                properties:
                  error:
                    type: string
                  message:
                    type: string
components:
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Key
      description: 'Bearer authentication with API key (format: Bearer sk_xxx)'

````