# Search and Delete Row — Zoho Sheet

> Searches for a row based on provided criteria and deletes it. See the documentation

- Key: `zoho_sheet-search-delete-row`
- Type: Action (Write)
- Version: 0.0.2
- App: Zoho Sheet (`zoho_sheet`) — https://pipedream.com/apps/zoho-sheet.md
- This page (HTML): https://pipedream.com/apps/zoho-sheet/actions/search-delete-row
- Hints: destructive · open-world
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/zoho_sheet/actions/search-delete-row/search-delete-row.mjs

## Description

Searches for a row based on provided criteria and deletes it. [See the documentation](https://www.zoho.com/sheet/help/api/v2/)

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `workbookId` | `string` | Yes | The ID of the workbook (Spreadsheet) Options are loaded from the connected account. |
| `worksheet` | `string` | Yes | The ID of the worksheet (Sheet of the Spreadsheet) Options are loaded from the connected account. |
| `headerRow` | `integer` | No | By default, first row of the worksheet is considered as header row. This can be used if tabular data starts from any row other than the first row.. |
| `criteria` | `string` | No | Conditions to locate the row to delete. Example: "Month"="March" and "Amount">50 |
| `rowArray` | `integer[]` | No | Array of row indexs, which needs to be deleted. |
| `firstMatchOnly` | `boolean` | Yes | If true and if there are multiple records on the specified criteria, records will be deleted for first match alone. Otherwise, all the matched records will be deleted. This parameter will be ignored if criteria is not mentioned. |
| `isCaseSensitive` | `boolean` | Yes | Can be set as false for case insensitive search. |
| `deleteRows` | `boolean` | Yes | If true it will delete the rows completely, otherwise the records are only erased by default. |

## Run it

**MCP**

```ts
import { Client } from "@modelcontextprotocol/sdk/client/index.js"
import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const accessToken = await pd.rawAccessToken

const transport = new StreamableHTTPClientTransport(
  new URL("https://remote.mcp.pipedream.net/v3"),
  {
    requestInit: {
      headers: {
        Authorization: `Bearer ${accessToken}`,
        "x-pd-project-id": process.env.PIPEDREAM_PROJECT_ID!,
        "x-pd-environment": "production",
        "x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
        "x-pd-app-slug": "zoho_sheet",
      },
    },
  },
)

const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)

const { tools } = await mcp.listTools()

// listTools() hands your model this tool's input schema, so it can
// fill the arguments itself:
const result = await mcp.callTool({
  name: "zoho_sheet-search-delete-row",
  arguments: {
    workbookId: "Worksheet",
    worksheet: "Worksheet",
  },
})
```

**TypeScript**

```ts
import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "zoho_sheet-search-delete-row",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    zoho_sheet: { authProvisionId: "apn_xxxxxxx" },
    workbookId: "Worksheet",
    worksheet: "Worksheet",
  },
})

console.log(result)
```

**cURL**

```bash
curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
  -H "Content-Type: application/json" \
  -H "X-PD-Environment: production" \
  -H "Authorization: Bearer {access_token}" \
  -d '{
    "external_user_id": "{external_user_id}",
    "id": "zoho_sheet-search-delete-row",
    "configured_props": {
      "zoho_sheet": { "authProvisionId": "apn_xxxxxxx" },
      "workbookId": "Worksheet",
      "worksheet": "Worksheet"
    }
  }'
```

---

- App: https://pipedream.com/apps/zoho-sheet.md · All apps: https://pipedream.com/apps