---
updatedAt: 2026-04-21T21:33:48.000Z
agentTools:
  projectIndex: https://docs.oneschema.co/llms.txt
---

# Get rows

Return paginated rows from the sheet.

# OpenAPI definition

```json
{
  "openapi": "3.1.0",
  "info": {
    "title": "Sheets",
    "version": "1",
    "contact": {
      "name": "OneSchema Support",
      "email": "support@oneschema.co"
    },
    "license": {
      "name": "proprietary",
      "url": "https://www.oneschema.co/terms-and-conditions"
    },
    "termsOfService": "https://www.oneschema.co/terms-and-conditions",
    "description": "An API for managing OneSchema Sheets."
  },
  "tags": [
    {
      "name": "Sheets",
      "description": "Sheets operations"
    }
  ],
  "paths": {
    "/v1/sheets/{sheet_id}/rows": {
      "get": {
        "operationId": "get-rows",
        "summary": "Get rows",
        "description": "Return paginated rows from the sheet.",
        "parameters": [
          {
            "name": "sheet_id",
            "in": "path",
            "required": true,
            "description": "The id of the sheet.",
            "schema": {
              "type": "integer",
              "format": "int32"
            }
          },
          {
            "name": "start_row",
            "in": "query",
            "required": false,
            "description": "The (0-based) row index of the first row to include.",
            "schema": {
              "type": "integer",
              "format": "int32",
              "default": 0
            },
            "explode": false
          },
          {
            "name": "count",
            "in": "query",
            "required": false,
            "description": "The number of rows to retrieve (default is all rows).",
            "schema": {
              "type": "integer",
              "format": "int32"
            },
            "explode": false
          },
          {
            "name": "include_unmapped",
            "in": "query",
            "required": false,
            "description": "If unmapped columns should be included in the exported file.",
            "schema": {
              "type": "boolean",
              "default": false
            },
            "explode": false
          },
          {
            "name": "embed_id",
            "in": "query",
            "required": false,
            "description": "The id of the embed which contains the sheet.",
            "schema": {
              "type": "integer",
              "format": "int32"
            },
            "explode": false
          }
        ],
        "responses": {
          "200": {
            "description": "The request has succeeded.",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/empty-response"
                }
              }
            }
          },
          "400": {
            "description": "400",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/empty-response"
                }
              }
            }
          }
        },
        "tags": [
          "Sheets"
        ]
      }
    }
  },
  "security": [
    {
      "ApiKeyAuth": []
    }
  ],
  "components": {
    "schemas": {
      "empty-response": {
        "type": "object",
        "properties": {}
      }
    },
    "securitySchemes": {
      "ApiKeyAuth": {
        "type": "apiKey",
        "in": "header",
        "name": "X-API-KEY"
      }
    }
  },
  "servers": [
    {
      "url": "https://api.oneschema.co",
      "description": "Production server (hosted in the US)",
      "variables": {}
    },
    {
      "url": "https://api.eu.oneschema.co",
      "description": "Production server (hosted in the EU)",
      "variables": {}
    },
    {
      "url": "https://api.ca.oneschema.co",
      "description": "Production server (hosted in Canada)",
      "variables": {}
    },
    {
      "url": "https://api.au.oneschema.co",
      "description": "Production server (hosted in Australia)",
      "variables": {}
    }
  ],
  "x-readme": {
    "explorer-enabled": true,
    "proxy-enabled": true
  }
}
```