---
title: "Get row"
method: GET
path: "/sheets/{sheetId}/rows/{rowId}"
tags: ["rows"]
---

# Get row

`GET /sheets/{sheetId}/rows/{rowId}`

Gets the row specified in the URL.

## Query parameters

- `accessApiLevel` number
- `include` 'columns' | 'filters'
- `exclude` 'filteredOutRows' | 'linkInFromCellDetails' | 'linksOutToCellsDetails' | 'nonexistentCells'
- `level` integer

## Response `200`

Returns [Row object]() populated according to the specified parameters.

- object
  - `id` number — Row ID.
  - `sheetId` number — Parent sheet ID.
  - `rowNumber` number — Row number within the sheet.
  - `expanded` boolean — Indicates whether the row is expanded or collapsed.
  - `cells` CellObjectForRows[] — Cells objects.
    - `columnId` number — The ID of the column that the cell is located in.
    - `columnType` string — Only returned if the include query string parameter contains **columnType**.
    - `value` union — A string, number, or a Boolean value -- depending on the cell type and the data in the cell. Cell values larger than 4000 characters are silently truncated. An empty cell returns no value.
      - string
      - number
      - boolean
    - `displayValue` string — Visual representation of cell contents, as presented to the user in the UI.
  - `createdAt` union
    - string, date-time
    - number
  - `modifiedAt` union
    - string, date-time
    - number

---

[API](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference.md) · [All operations](https://skmtc.net/smartsheet/apis/smartsheet-openapi-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/smartsheet/smartsheet-openapi-reference/versions/b4afda95fb51/schema)