---
title: "Get record cells by field"
method: GET
path: "/sheets/{sheetId}/cells"
tags: ["sheets"]
---

# Get record cells by field

`GET /sheets/{sheetId}/cells`

Returns record cell values grouped by all fields in the sheet

## Path parameters

- `sheetId` string, required — Sheet ID

## Query parameters

- `fieldKey` string — Returns results from the given field only. Otherwise all field cells are returned
- `sortField` string — Name of field by which to sort records
- `sortDirection` 'asc' | 'desc' — Sort direction - asc (ascending) or desc (descending)
- `filter` 'valid' | 'error' | 'all' | 'none' — Options to filter records
- `filterField` string — Use this to narrow the valid/error filter results to a specific field
- `pageSize` integer — Number of logs to return in a page (default 20)
- `pageNumber` integer — Based on pageSize, which page of records to return
- `distinct` boolean, required — When true, excludes duplicate values
- `includeCounts` boolean — When both distinct and includeCounts are true, the count of distinct field values will be returned
- `searchValue` string — Search for the given value, returning matching rows. For exact matches, wrap the value in double quotes ("Bob"). To search for null values, send empty double quotes ("")
- `q` string

## Headers

- `Authorization` string, required
- `X-Disable-Hooks` 'true', required

## Response `200`

Response with status 200

- TypeSheetsCellsResponse
  - `data` TypeSheetsCellsResponseData, required — Cell values grouped by field key

---

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