---
title: "Detects fully duplicated rows within a specified sheet range."
method: POST
path: "/duplicateRowsDetection"
---

# Detects fully duplicated rows within a specified sheet range.

`POST /duplicateRowsDetection`

This function identifies and returns fully duplicated rows from a given range in a spreadsheet. It takes a single parameter object containing the sheet ID and the range to check, and returns a Promise that resolves to an array of duplicate rows. This can be useful for data cleaning and analysis tasks in spreadsheet applications.

## Request body

- object
  - `body` object — Body of the duplicateRowsDetection sls call
    - `arguments` unknown[], required
      - unknown
    - `auth` object — Authentication object
      - `strategy` 'oauth2' — Authentication strategy
      - `variables` unknown[] — Variables for the authentication strategy
        - unknown
    - `packageName` string — @microfox/google-sheets

## Response `200`

Successful operation

- array[] — An array of duplicate rows
  - string[] — A duplicate row

## Other responses

- `400` — Bad request - invalid input parameters
- `404` — Not found - sheet or range not found
- `500` — Internal server error

## Changes

- **2025-05-29** `470b95f73df9` — 1 breaking, 1 info
  - the `items/` response's property type/format changed from `object`/`` to `array`/`` for status `200`
  - added the non-success response with the status `404`
- **2025-05-28** `77260ff78232` — 1 breaking, 1 info
  - the `items/` response's property type/format changed from `array`/`` to `object`/`` for status `200`
  - removed the non-success response with the status `404`

[Change history](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api/changes/duplicateRowsDetection/post.md)

---

[API](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api.md) · [All operations](https://skmtc.dev/microfox-ai/apis/google-sheets-sdk-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/microfox-ai/google-sheets-sdk-api/revisions/85db428f2808/schema)