Validate CSV before import using a fixed JSON column specification
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…
by api.mekler.ai · discovered, not yet claimed by its owner · updated 2026-10-08
Mirrored from Coinbase's public x402 Bazaar. The description is the provider's own text and has not been reviewed here; the payment requirements are copied as published.
What it does
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.
Tags: csv · data-validation · data-quality · bazaar
Use with an agent
- Discover. Agents find this listing with
GET https://bazaar.saylorinnovations.com/discovery/search?query=…, the MCP toolsearch_resources, or/discovery/resources. - Inspect. Fetch
/resources/34975.jsonfor the price and payment options. - Pay. Call
GET https://api.mekler.ai/v1/data/csv/validate-data. The provider answers402with its payment requirements. An x402 client signs one of the options below and retries withPAYMENT-SIGNATURE. - Execute. The provider returns
200with the data. Agent Bazaar is not in the request path and never sees your payment.
For humans
You don't need an account or an API key; you need a wallet holding a small amount of USDC on Solana, Base, and an x402-capable client (see the examples below). Call the endpoint unpaid first to see exactly what it asks for.
Pricing & payment
- Price
- $0.05 / request
- Protocol
- x402 v2
- Auth
- No account or API key. Pay per request.
- Networks
- Solana, Base
- Calls (30d)
- 3 · 3 unique payers (third-party data from the public x402 Bazaar)
x402 payment requirements
| Scheme | Network | Asset | Amount | Pay to | Timeout |
|---|---|---|---|---|---|
| exact | Solana solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp | USDC | $0.05 | 9mMDrHabSf73MPn1ANdANSmsNw2wKiqE7JZ7eD6EUSRc | 60s |
| exact | Base eip155:8453 | USDC | $0.05 | 0xF6c6E2e530bb311c14a49C1a07C720fc232c07c5 | 60s |
accepts[] (raw JSON)
[
{
"scheme": "exact",
"network": "solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp",
"payTo": "9mMDrHabSf73MPn1ANdANSmsNw2wKiqE7JZ7eD6EUSRc",
"asset": "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v",
"amount": "50000",
"amountUsd": 0.05,
"maxTimeoutSeconds": 60
},
{
"scheme": "exact",
"network": "eip155:8453",
"payTo": "0xF6c6E2e530bb311c14a49C1a07C720fc232c07c5",
"asset": "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913",
"amount": "50000",
"amountUsd": 0.05,
"maxTimeoutSeconds": 60
}
]Schemas
Output schema (JSON Schema)
{
"properties": {
"example": {
"properties": {
"boundary": {
"type": "string"
},
"failure_count": {
"minimum": 0,
"type": "integer"
},
"failures": {
"items": {
"properties": {
"code": {
"enum": [
"missing_column",
"extra_columns",
"row_width",
"required",
"type",
"min",
"max",
"enum",
"unique",
"min_rows",
"max_rows"
],
"type": "string"
},
"column": {
"description": "Column name, or null when the error applies to the row or file.",
"type": [
"string",
"null"
]
},
"row": {
"description": "One-based data record, excluding header; null for file/header errors.",
"type": [
"integer",
"null"
]
}
},
"required": [
"code",
"row",
"column"
],
"type": "object"
},
"maxItems": 50,
"type": "array"
},
"failures_truncated": {
"type": "boolean"
},
"receipt_sha256": {
"pattern": "^[0-9a-f]{64}$",
"type": "string"
},
"rows_checked": {
"minimum": 0,
"type": "integer"
},
"schema_version": {
"enum": [
1
],
"type": "integer"
},
"verdict": {
"enum": [
"pass",
"fail"
],
"type": "string"
}
},
"required": [
"schema_version",
"verdict",
"rows_checked",
"failure_count",
"failures",
"failures_truncated",
"receipt_sha256",
"boundary"
],
"type": "object"
},
"type": {
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}Example shape — generated from the schema, not a captured live response
{
"example": {
"boundary": "string",
"failure_count": 0,
"failures": [
{
"code": "missing_column",
"column": "string",
"row": 0
}
],
"failures_truncated": true,
"receipt_sha256": "string",
"rows_checked": 0,
"schema_version": 1,
"verdict": "pass"
},
"type": "string"
}Examples
curl "https://api.mekler.ai/v1/data/csv/validate-data"
# -> 402 Payment Required, accepts[] lists how to pay
# retry with a PAYMENT-SIGNATURE (or PAYMENT header) once paidconst res = await fetch("https://api.mekler.ai/v1/data/csv/validate-data");
if (res.status === 402) {
const { accepts } = await res.json();
// pay one of accepts[] via an x402 client, then retry with the payment header
}import httpx
res = httpx.get("https://api.mekler.ai/v1/data/csv/validate-data")
if res.status_code == 402:
accepts = res.json()["accepts"]
# pay one of accepts[] via an x402 client, then retry with the payment headerDetails
- Provider
- api.mekler.ai
- Endpoint
- https://api.mekler.ai/v1/data/csv/validate-data
- Machine-readable
/resources/34975.json