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

# Get Individual Row

> Fetches a specific row based on its physical row ID in the sheet.



## OpenAPI

````yaml GET /{endpointNamespace}/{projectName}/{tabSlug}/{rowId}
openapi: 3.0.3
info:
  title: Sheet Ninja API
  description: >-
    The official API for Sheet Ninja, turning Google Sheets into RESTful
    endpoints. Supports hierarchical routing, bulk operations, and camelCase
    header mapping.
  version: 1.0.0
  contact:
    name: Sheet Ninja Support
    url: https://sheetninja.io
servers:
  - url: https://api.sheetninja.io
    description: Production Server
security: []
paths:
  /{endpointNamespace}/{projectName}/{tabSlug}/{rowId}:
    parameters:
      - name: endpointNamespace
        in: path
        required: true
        description: Your unique user namespace
        schema:
          type: string
      - name: projectName
        in: path
        required: true
        description: The slugified name of your project
        schema:
          type: string
      - name: tabSlug
        in: path
        required: true
        description: The slugified name of the specific worksheet (tab)
        schema:
          type: string
      - name: rowId
        in: path
        required: true
        description: >-
          The physical row number in the Google Sheet (Note: Row 1 is the header
          row)
        schema:
          type: integer
          minimum: 2
    get:
      tags:
        - Rows
      summary: Get Individual Row
      description: Fetches a specific row based on its physical row ID in the sheet.
      responses:
        '200':
          description: Successful retrieval of the row
          content:
            application/json:
              schema:
                type: object
                additionalProperties: true
                properties:
                  id:
                    type: integer
                    description: The physical row number of the record
        '400':
          $ref: '#/components/responses/BadRequestError'
        '401':
          $ref: '#/components/responses/UnauthorizedError'
        '402':
          $ref: '#/components/responses/PaymentRequiredError'
        '403':
          $ref: '#/components/responses/ForbiddenError'
        '404':
          $ref: '#/components/responses/NotFoundError'
        '429':
          $ref: '#/components/responses/RateLimitError'
        '500':
          $ref: '#/components/responses/ServerError'
      security:
        - bearerAuth: []
        - {}
components:
  responses:
    BadRequestError:
      description: >-
        The request was invalid (malformed JSON, invalid rowId, or system limits
        reached).
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    UnauthorizedError:
      description: Authentication failed, token is missing.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    PaymentRequiredError:
      description: Row quota exceeded (Subscription or Credits).
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    ForbiddenError:
      description: >-
        Invalid token, insufficient permissions, or the project/operation is
        disabled.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    NotFoundError:
      description: The requested namespace, project, tab, or row was not found.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    RateLimitError:
      description: Google Sheets API rate limits exceeded.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    ServerError:
      description: An unexpected internal server error occurred.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
  schemas:
    ErrorResponse:
      type: object
      description: Standardized error structure returned for non-2xx responses
      properties:
        error:
          type: string
          description: The machine-readable error code
          enum:
            - not_found
            - unauthorized
            - forbidden
            - disabled
            - invalid
            - conflict
            - quota_exceeded
            - google_token_invalid
            - google_unsupported_document
            - google_rate_limit_exceeded
            - google_permission_denied
            - google_sheet_not_found
            - google_timeout
            - internal_server_error
            - encoding_failed
        message:
          type: string
          description: A human-readable explanation of what went wrong
        data:
          type: object
          nullable: true
          description: Optional additional context or metadata regarding the error
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Token
      description: >-
        The Bearer Token associated with your endpoint. This is only required if
        you have enabled protection for this endpoint.

````