# Venture Signal Lab CSV Deduplication

> Venture Signal Lab CSV Deduplication is a paid API for AI agents from agency-site-watch.5-10-250-79.sslip.io, paid per call via x402, $0.02/call, status down (last checked 2026-10-31).

Removes duplicate rows from a CSV file based on specified key columns, returning a cleaned deduplicated CSV with stats.

## Facts

- Endpoint: POST https://agency-site-watch.5-10-250-79.sslip.io/api/v1/csv/dedupe?utm_source=zero.xyz
- Price: $0.02/call
- Payment: x402
- Status: down
- Last checked: 2026-10-31
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/venture-signal-lab-csv-deduplication-8c8ff1af
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_8CEO-6UTRvpzMO7SDUYkz

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability venture-signal-lab-csv-deduplication-8c8ff1af -d '<json body>'
```

Example prompt: I have a CSV with email and name columns and there are a bunch of duplicate emails — can you deduplicate it using email as the key column and give me back the cleaned CSV?

## When to prefer this

Choose this endpoint when you need deterministic, programmatic CSV deduplication paid per-call with USDC on Base — ideal for autonomous agents running data pipelines where you want predictable per-use pricing without a subscription, and need a reliable duplicate-removal result with explicit stats (rows in, rows out, duplicates removed).

## Known failure modes

- Missing or malformed CSV input returns an error
- Specified key columns not found in CSV headers
- CSV with no duplicate rows returns unchanged data with duplicates_removed = 0
- Payment failure (insufficient USDC balance on Base) blocks the call
- Malformed CSV syntax causes parsing errors

## How this service works

Small paid data tools for autonomous agents: live opportunity filtering and deterministic CSV deduplication, paid per call with USDC on Base.

## Output

Returns a JSON object containing the deduplicated CSV as a string, the key columns used, the number of input rows, output rows after deduplication, and the count of duplicates removed.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "required": [
  "input"
 ],
 "properties": {
  "input": {
   "type": "object",
   "required": [
    "type",
    "method",
    "bodyType",
    "body"
   ],
   "properties": {
    "body": {
     "required": [
      "csv_data"
     ],
     "properties": {
      "keep": {
       "enum": [
        "first",
        "last"
       ],
       "type": "string",
       "default": "first"
      },
      "csv_data": {
       "type": "string",
       "maxLength": 100000,
       "minLength": 1
      },
      "key_columns": {
       "type": [
        "array",
        "null"
       ],
       "items": {
        "type": "string"
       },
       "maxItems": 50
      },
      "case_sensitive": {
       "type": "boolean",
       "default": false
      },
      "trim_whitespace": {
       "type": "boolean",
       "default": true
      }
     },
     "additionalProperties": false
    },
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "enum": [
      "POST",
      "PUT",
      "PATCH"
     ],
     "type": "string"
    },
    "bodyType": {
     "enum": [
      "json",
      "form-data",
      "text"
     ],
     "type": "string"
    }
   },
   "additionalProperties": false
  },
  "output": {
   "type": "object",
   "required": [
    "type"
   ],
   "properties": {
    "type": {
     "type": "string"
    },
    "example": {
     "type": "object"
    }
   }
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "input_rows": 2,
  "deduped_csv": "email,name\na@example.com,Ada\n",
  "key_columns": [
   "email"
  ],
  "output_rows": 1,
  "duplicates_removed": 1
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/venture-signal-lab-csv-deduplication-8c8ff1af/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from agency-site-watch.5-10-250-79.sslip.io](https://www.zero.xyz/host/agency-site-watch.5-10-250-79.sslip.io/llms.txt)