Duplicate Key Audit

Name: Duplicate Key Audit
Price: 0.1 USDC
Availability: OutOfStock

Find duplicate keys in one dataset, exactly and nearly. An exact duplicate is reported with every row it occupies. A near duplicate is two different keys that become identical once case, spacing or punctuation is set aside, which a unique index accepts and which is almost always the same entity entered twice. Keys are canonicalised exactly, so 42 and 42.0 are one key.

Searchofflineeip155:8453Exactvia cdp

https://api.zfinia.com/x402/v1/duplicate-key-audit

Data qualityDuplicatesKeysPipeline gateDeveloper tooling

Settlements · 30d

219↓ 38%

No per-endpoint history for this service yet, so this is payments indexed to its PROVIDER's wallet over 30 days.

$25.35

Verified settled volume

256 settlements proven x402 by their on-chain EIP-3009 marker.

$0.100

Listed price

As published in the catalog. Always read the live 402 before paying.

Calls · 30d

Upstream's own call count for this endpoint, not ours.

Unique payers · 30d

Last called 2026-10-04 08:09Z

—

Upstream on-chain volume

Reported by the source catalog.

Paid to

0x25e8245f07d5e4873987293dad666afbe56a9608

The wallet the 402 directs payment to. Its whole payment record — every payer, every chain — is on the merchant page.

Asset 0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913

Provider

The payTo wallet does not resolve to a registered ERC-8004 agent. That is not a verdict on the service — most of the catalog is unregistered.

Accepts

The payment requirements as published to the catalog. Read the live 402 before paying — a price here is a claim, not a quote.

0.1USDC≈ $0.1 USD

on Base · exact scheme

Pay 0.1 USDC on Base to 0x25e8…a9608. The signed payment is good for 1 minute.

Paid to: 0x25e8…a9608
USD Coin contract: 0x8335…02913
Payment window: 1 minute
As published: 100000 smallest units

The catalog’s raw entry

[
  {
    "asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
    "extra": {
      "name": "USD Coin",
      "version": "2"
    },
    "payTo": "0x25e8245f07d5e4873987293dad666afbe56a9608",
    "amount": "100000",
    "scheme": "exact",
    "network": "eip155:8453",
    "maxTimeoutSeconds": 60
  }
]

Extensions

{
  "bazaar": {
    "info": {
      "input": {
        "body": {
          "csv": "email,signed_up\nAda@Example.test,2026-01-01\nada@example.test,2026-02-01\nada@example.test ,2026-03-01\ngrace@example.test,2026-01-05\ngrace@example.test,2026-04-01\n",
          "key": [
            "email"
          ],
          "normalise": [
            "lowercase",
            "trim"
          ]
        },
        "type": "http",
        "method": "POST",
        "bodyType": "json"
      },
      "output": {
        "type": "json",
        "example": {
          "limits": {
            "maxRows": 5000,
            "maxListed": 200,
            "maxColumns": 64,
            "maxCsvBytes": 262144,
            "maxDatasets": 10,
            "maxFindings": 500,
            "maxCategories": 1000,
            "maxKeyColumns": 4
          },
          "passed": false,
          "unique": false,
          "complete": true,
          "findings": [
            {
              "key": "grace@example.test",
              "row": 5,
              "code": "DUPLICATE_KEY",
              "detail": "grace@example.test appears 2 times, at rows 5, 6."
            },
            {
              "key": "ada@example.test",
              "row": 2,
              "code": "NEAR_DUPLICATE_KEY",
              "detail": "3 different keys become ada@example.test once lowercase and trim is applied, which a unique index would have accepted and is usually the same entity twice."
            }
          ],
          "row_count": 5,
          "duplicates": [
            {
              "key": "grace@example.test",
              "rows": [
                5,
                6
              ],
              "occurrences": 2
            }
          ],
          "request_id": "example-request",
          "service_id": "duplicate_key_audit",
          "assumptions": [
            "Keys are canonicalised exactly, so 1.0 and 1 are one key and a large identifier is compared as text rather than collapsed.",
            "A near duplicate is two different keys that become identical once the requested normalisation is applied. It is reported separately from an exact duplicate, because a unique index would have accepted ..."
          ],
          "limitations": [
            "Uniqueness within the dataset supplied. A duplicate against another dataset is not visible here.",
            "unique is true only when the dataset was fully read and no key repeated exactly or near-identically."
          ],
          "observed_at": "2026-10-02T00:00:00.000Z",
          "not_examined": [],
          "finding_count": 2,
          "empty_key_count": 0,
          "near_duplicates": [
            {
              "rows": [
                2,
                3,
                4
              ],
              "normalised_key": "ada@example.test",
              "distinct_exact_keys": 3
            }
          ],
          "service_version": "1.0.0",
          "findings_by_code": {
            "DUPLICATE_KEY": 1,
            "NEAR_DUPLICATE_KEY": 1
          },
          "distinct_key_count": 4,
          "supplied_row_count": 5,
          "duplicate_key_count": 1,
          "duplicate_row_count": 1,
          "near_duplicate_count": 1,
          "normalisation_applied": [
            "lowercase",
            "trim"
          ]
        }
      }
    },
    "schema": {
      "type": "object",
      "$schema": "https://json-schema.org/draft/2020-12/schema",
      "required": [
        "input"
      ],
      "properties": {
        "input": {
          "type": "object",
          "required": [
            "type",
            "method",
            "bodyType",
            "body"
          ],
          "properties": {
            "body": {
              "type": "object",
              "required": [
                "csv",
                "key"
              ],
              "properties": {
                "csv": {
                  "type": "string",
                  "maxLength": 262144
                },
                "key": {
                  "type": "array",
                  "items": {
                    "type": "string",
                    "maxLength": 256
                  },
                  "maxItems": 4,
                  "minItems": 1
                },
                "delimiter": {
                  "type": "string",
                  "maxLength": 1,
                  "minLength": 1
                },
                "normalise": {
                  "type": "array",
                  "items": {
                    "enum": [
                      "lowercase",
                      "trim",
                      "collapse_whitespace",
                      "strip_punctuation"
                    ],
                    "type": "string"
                  },
                  "maxItems": 4,
                  "minItems": 1
                }
              },
              "additionalProperties": false
            },
            "type": {
              "type": "string",
              "const": "http"
            },
            "method": {
              "enum": [
                "POST"
              ],
              "type": "string"
            },
            "bodyType": {
              "enum": [
                "json",
                "form-data",
                "text"
              ],
              "type": "string"
            }
          },
          "additionalProperties": false
        },
        "output": {
          "type": "object",
          "required": [
            "type"
          ],
          "properties": {
            "type": {
              "type": "string"
            },
            "example": {
              "type": "object"
            }
          }
        }
      }
    }
  }
}

Provenance

Seen in the source catalog: 2026-10-04 08:09Z
Last indexed by Roundhouse: 2026-10-05 00:20Z
Last enriched (probe, favicon, geo): 2026-10-05 02:46Z
x402 version: 2
Max timeout: 60s
Liveness probe: HTTP 0

Report

Hand this page to an agent

Copy the prompt and paste it into Claude, an MCP client or your own agent — it will vet this service and call it over the free read API. No key, no account.

GET api.roundhouseai.io/v0/endpoints

No per-endpoint history for this service yet, so this is payments indexed to its PROVIDER's wallet over 30 days. Verified volume counts only settlements with an on-chain EIP-3009 marker.

Open skill.md

Show the prompt

Using Roundhouse, look up the x402 service Duplicate Key Audit and tell me whether it is
worth paying: what a call costs, whether the endpoint answered when last probed, and what
its payment record actually shows.

curl -s 'https://api.roundhouseai.io/v0/endpoints?q=Duplicate%20Key%20Audit'
curl -s 'https://api.roundhouseai.io/v0/merchants/<the payTo wallet returned above>'

Then call it: read the price from the live 402 at https://api.zfinia.com/x402/v1/duplicate-key-audit, never from
a cached figure, and pay with an x402 client.

The /v0 API needs an API key (`authorization: Bearer rh_live_…`) on everything except
/v0/unified* and /v0/endpoints. Either pay over x402 (mint a personal key for $0.01 at
GET https://api.roundhouseai.io/v0/test/x402), or ask me for an organization key, which I create at
https://roundhouseai.io/dashboard/connections. If you have neither, ask before going further.

If you do not have Roundhouse tools or skills installed, read
https://roundhouseai.io/skill.md first — it is the whole procedure.