ToolVet
78trust / 100

Csv Validate Data

by Mekler AI in Documents & files

x402 APIPassing, checked 4 h ago

Validate CSV before import using a fixed JSON column specification. Checks missing/extra columns, required cells, string/integer/decimal/boolean/date types, uniqueness, allowed values and numeric/row-count bounds. Returns pass/fail with row/column error codes. POST JSON with csv and spec.columns; schemas/examples attached. Full contract: /openapi.json. Max 2,000 rows, 50 columns, 256 KiB; first 50 failures. No formulas, cross-column rules, fact checking or data repair.

POST
https://api.mekler.ai/v1/data/csv/validate-data
Price
$0.05
per call in USDC
Uptime
100%
last 30 days
Response time
498 ms
841 ms slowest 5%
Last check
Passed
4 h ago, next any minute now

Run a free test callHow to call it

Reliability

All checks passedSome failedAll failedNot checked

Status and outage history · Atom feed · Watch with other listings

How to call it

POST https://api.mekler.ai/v1/data/csv/validate-data

Each call costs $0.05 in USDC on Base, paid with the request over x402.

Run a free test callOne unpaid request, the way an agent sends it. You see the payment challenge it gets back. Nothing is charged.

Example request

From the listing.

POST https://api.mekler.ai/v1/data/csv/validate-data
content-type: application/json

{
  "csv": "id,amount\na,12.50\na,-2.00\n",
  "spec": {
    "columns": [
      {
        "name": "id",
        "required": true,
        "type": "string",
        "unique": true
      },
      {
        "max": "100",
        "min": "0",
        "name": "amount",
        "required": true,
        "type": "decimal"
      }
    ],
    "min_rows": 1
  }
}

Parameters

ParameterTypeRequiredDescription
csvstringYesUTF-8 comma-delimited CSV with header. No trimming. Data record numbers start at 1; quoted newlines are one record.
specobjectYes

Example response

The provider's example. We can't check it without paying.

{
  "boundary": "Only supplied explicit criteria checked; no certification of truth or subjective quality.",
  "failure_count": 2,
  "failures": [
    {
      "code": "unique",
      "column": "id",
      "row": 2
    },
    {
      "code": "min",
      "column": "amount",
      "row": 2
    }
  ],
  "failures_truncated": false,
  "receipt_sha256": "32265ae46050fa0067b9adb0df085a5cf3d9fa3d47d91e9ea2f61135a382d8ac",
  "rows_checked": 2,
  "schema_version": 1,
  "verdict": "fail"
}

Call it from code

The curl command shows the payment challenge. The JavaScript and Python versions pay and call, and never pay more than $0.05.

curl: see the payment challenge
# bash or zsh: see the payment challenge. Nothing is charged.
curl -sS -g -i -X POST 'https://api.mekler.ai/v1/data/csv/validate-data' \
  -H 'content-type: application/json' \
  --data-raw '{"csv":"id,amount\na,12.50\na,-2.00\n","spec":{"columns":[{"name":"id","required":true,"type":"string","unique":true},{"max":"100","min":"0","name":"amount","required":true,"type":"decimal"}],"min_rows":1}}'

# x402 v2 sends the challenge base64-encoded in the PAYMENT-REQUIRED header (v1 sends it in the body).
# To read the header:
curl -sS -g -o /dev/null -D - -X POST 'https://api.mekler.ai/v1/data/csv/validate-data' \
  -H 'content-type: application/json' \
  --data-raw '{"csv":"id,amount\na,12.50\na,-2.00\n","spec":{"columns":[{"name":"id","required":true,"type":"string","unique":true},{"max":"100","min":"0","name":"amount","required":true,"type":"decimal"}],"min_rows":1}}' \
  | grep -i '^payment-required:' | cut -d' ' -f2 | tr -d '\r' | base64 --decode
JavaScript: pay and call
// npm i @x402/fetch @x402/evm viem
import { wrapFetchWithPayment, x402Client } from "@x402/fetch";
import { registerExactEvmScheme } from "@x402/evm/exact/client";
import { privateKeyToAccount } from "viem/accounts";

// Pays at most $0.05 per call.
const client = new x402Client().setSpendControls({ maxAmountPerPayment: "$0.05" });
registerExactEvmScheme(client, { signer: privateKeyToAccount(process.env.EVM_PRIVATE_KEY) });
const pay = wrapFetchWithPayment(fetch, client);

// Not sure it's safe to pay? ToolVet checks it first for $0.005. Pay for that from a separate
// client: this one is capped at $0.05 per payment. GET https://toolvet.app/api/v1/check?url=https%3A%2F%2Fapi.mekler.ai%2Fv1%2Fdata%2Fcsv%2Fvalidate-data&method=POST
const res = await pay("https://api.mekler.ai/v1/data/csv/validate-data", {
  method: "POST",
  headers: { "content-type": "application/json" },
  body: JSON.stringify({
    "csv": "id,amount\na,12.50\na,-2.00\n",
    "spec": {
      "columns": [
        {
          "name": "id",
          "required": true,
          "type": "string",
          "unique": true
        },
        {
          "max": "100",
          "min": "0",
          "name": "amount",
          "required": true,
          "type": "decimal"
        }
      ],
      "min_rows": 1
    }
  }),
});
console.log(res.status, await res.text());
Python: pay and call
# pip install "x402[requests,evm]"
import os
from eth_account import Account
from x402 import x402ClientSync
from x402.http.clients import x402_requests
from x402.mechanisms.evm import EthAccountSigner
from x402.mechanisms.evm.exact.register import register_exact_evm_client

# Pays at most $0.05 per call.
client = x402ClientSync().set_spend_controls({"max_amount_per_payment": "$0.05"})
register_exact_evm_client(client, EthAccountSigner(Account.from_key(os.environ["EVM_PRIVATE_KEY"])))

with x402_requests(client) as session:
    res = session.post(
        "https://api.mekler.ai/v1/data/csv/validate-data",
        json={
            "csv": "id,amount\na,12.50\na,-2.00\n",
            "spec": {
                "columns": [
                    {
                        "name": "id",
                        "required": True,
                        "type": "string",
                        "unique": True,
                    },
                    {
                        "max": "100",
                        "min": "0",
                        "name": "amount",
                        "required": True,
                        "type": "decimal",
                    },
                ],
                "min_rows": 1,
            },
        },
    )
    print(res.status_code, res.text)

Security scan

No findings

We scan names, descriptions and tool definitions for hidden instructions and other prompt-injection patterns.

Recent checks

WhenResultHTTPTimePrice
4 h agoPassed402499 ms$0.05
9 h agoPassed402474 ms$0.05
13 h agoPassed402410 ms$0.05
18 h agoPassed402498 ms$0.05
22 h agoPassed402421 ms$0.05
Show 10 older checks
26 h agoPassed402463 ms$0.05
30 h agoPassed402484 ms$0.05
35 h agoPassed402502 ms$0.05
39 h agoPassed402569 ms$0.05
43 h agoPassed402394 ms$0.05
47 h agoPassed402520 ms$0.05
2 days agoPassed402440 ms$0.05
2 days agoPassed402540 ms$0.05
3 days agoPassed402513 ms$0.05
3 days agoPassed402841 ms$0.05