Declarative record constraints
Evaluate up to 40 bounded rules across 500 supplied records: presence, JSON type, inclusive numeric bounds, string/array length, typed allowed values and composite uniqueness. Returns per-rule counts and row-addressed violations. No expressions, regex or automatic repair.
data-assurance · Operation ID: record-constraints
Choose this operation when
- validate dataset quality rules and composite uniqueness
- find records violating required fields ranges enums lengths
- return machine-readable row violations for data quality gates
Outside this profile
- Arbitrary JSON Schema conformance
- Evaluate code SQL regex or repair data automatically
Exact release references
Static JSON contract · Markdown reference · Fixed example response
Complete input schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"records": {
"maxItems": 500,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/$defs/__schema0"
}
}
},
"rules": {
"minItems": 1,
"maxItems": 40,
"type": "array",
"items": {
"oneOf": [
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "present"
},
"path": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
},
"allowNull": {
"default": false,
"type": "boolean"
}
},
"required": [
"id",
"kind",
"path"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "type"
},
"path": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
},
"type": {
"type": "string",
"enum": [
"string",
"number",
"integer",
"boolean",
"null",
"array",
"object"
]
}
},
"required": [
"id",
"kind",
"path",
"type"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "number-range"
},
"path": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
},
"min": {
"type": "number"
},
"max": {
"type": "number"
}
},
"required": [
"id",
"kind",
"path"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "length"
},
"path": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
},
"min": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"max": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"id",
"kind",
"path"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "one-of"
},
"path": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
},
"values": {
"minItems": 1,
"maxItems": 50,
"type": "array",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
}
}
},
"required": [
"id",
"kind",
"path",
"values"
],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"id": {
"type": "string",
"minLength": 1,
"maxLength": 80
},
"kind": {
"type": "string",
"const": "unique"
},
"paths": {
"minItems": 1,
"maxItems": 5,
"type": "array",
"items": {
"type": "string",
"maxLength": 512,
"description": "RFC 6901 JSON string pointer; empty string selects the row root. URI fragments and unsafe property names are rejected."
}
},
"missing": {
"default": "reject",
"type": "string",
"enum": [
"reject",
"ignore"
]
},
"nulls": {
"default": "value",
"type": "string",
"enum": [
"value",
"ignore"
]
}
},
"required": [
"id",
"kind",
"paths"
],
"additionalProperties": false
}
]
}
}
},
"required": [
"records",
"rules"
],
"additionalProperties": false,
"$defs": {
"__schema0": {
"anyOf": [
{
"type": "string"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
},
{
"type": "array",
"items": {
"$ref": "#/$defs/__schema0"
}
},
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/$defs/__schema0"
}
}
]
}
}
}
Complete output-envelope schema
{
"type": "object",
"required": [
"operation",
"version",
"result",
"provenance"
],
"properties": {
"operation": {
"const": "record-constraints",
"type": "string"
},
"version": {
"const": "0.29.0",
"type": "string"
},
"result": {
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"profile": {
"type": "string",
"const": "record-constraints-v1"
},
"passes": {
"type": "boolean"
},
"rowCount": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"violationCount": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"rules": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"evaluatedCount": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"ignoredCount": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"violationCount": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"id",
"evaluatedCount",
"ignoredCount",
"violationCount"
],
"additionalProperties": false
}
},
"violations": {
"type": "array",
"items": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"rowIndex": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"path": {
"type": "string"
},
"message": {
"type": "string"
},
"ruleId": {
"type": "string"
},
"relatedRowIndex": {
"anyOf": [
{
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
{
"type": "null"
}
]
}
},
"required": [
"code",
"rowIndex",
"path",
"message",
"ruleId",
"relatedRowIndex"
],
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
},
"caveats": {
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"profile",
"passes",
"rowCount",
"violationCount",
"rules",
"violations",
"truncated",
"caveats"
],
"additionalProperties": false
},
"provenance": {
"type": "object",
"required": [
"inputSha256",
"outputSha256",
"deterministic",
"externalRequests"
],
"properties": {
"inputSha256": {
"type": "string",
"pattern": "^[a-f0-9]{64}$"
},
"outputSha256": {
"type": "string",
"pattern": "^[a-f0-9]{64}$"
},
"deterministic": {
"const": true
},
"externalRequests": {
"const": 0
}
}
}
},
"additionalProperties": false
}
Fixed example
One accepted fixed example, not a custom-input trial. No operation runs when this static page is requested.
Example input
{
"records": [
{
"id": "a",
"score": 0.8
},
{
"id": "a",
"score": 1.2
},
{
"score": null
}
],
"rules": [
{
"id": "id-required",
"kind": "present",
"path": "/id"
},
{
"id": "score-range",
"kind": "number-range",
"path": "/score",
"min": 0,
"max": 1
},
{
"id": "id-unique",
"kind": "unique",
"paths": [
"/id"
]
}
]
}
Example response
{
"operation": "record-constraints",
"version": "0.29.0",
"result": {
"profile": "record-constraints-v1",
"passes": false,
"rowCount": 3,
"violationCount": 5,
"rules": [
{
"id": "id-required",
"evaluatedCount": 3,
"ignoredCount": 0,
"violationCount": 1
},
{
"id": "score-range",
"evaluatedCount": 3,
"ignoredCount": 0,
"violationCount": 2
},
{
"id": "id-unique",
"evaluatedCount": 3,
"ignoredCount": 0,
"violationCount": 2
}
],
"violations": [
{
"code": "MISSING_VALUE",
"rowIndex": 2,
"path": "/id",
"message": "Field is absent",
"ruleId": "id-required",
"relatedRowIndex": null
},
{
"code": "OUT_OF_RANGE",
"rowIndex": 1,
"path": "/score",
"message": "Number is outside inclusive bounds",
"ruleId": "score-range",
"relatedRowIndex": null
},
{
"code": "TYPE_MISMATCH",
"rowIndex": 2,
"path": "/score",
"message": "Expected number; observed null",
"ruleId": "score-range",
"relatedRowIndex": null
},
{
"code": "DUPLICATE_VALUE",
"rowIndex": 1,
"path": "",
"message": "Composite key duplicates an earlier row",
"ruleId": "id-unique",
"relatedRowIndex": 0
},
{
"code": "MISSING_VALUE",
"rowIndex": 2,
"path": "",
"message": "A unique-key field is absent",
"ruleId": "id-unique",
"relatedRowIndex": null
}
],
"truncated": false,
"caveats": [
"All rules are evaluated independently. Counts include findings beyond the retained evidence limit.",
"Unique violations identify each later duplicate and its first row; missing and null policies are explicit. String length uses UTF-16 code units."
]
},
"provenance": {
"inputSha256": "39ce3bc4f0e0760179cdc3f84efcab5402ccceee5fb13137750a1cf60d26e1b2",
"outputSha256": "d09e9b55481c864dbd6d0d45e910854e079e33edb7ea1599b9db64ab31ac8370",
"deterministic": true,
"externalRequests": 0
}
}
Bounds and precision
JavaScript IEEE-754 numbers; use strings for large integer IDs/exact decimals where the schema accepts strings. No lossless numeric parsing.
{
"global": {
"requestBytes": 131072,
"responseBytes": 524288,
"jsonDepth": 32,
"jsonNodes": 20000,
"requestsPerMinute": 60,
"paidAttemptsPerMinute": 20,
"idempotencyHours": 24
},
"operation": {
"inputBytes": 100000,
"outputBytes": 400000,
"jsonNodes": 12000,
"depth": 20,
"evidence": 200,
"keyWorkBytes": 3000000,
"matchingSteps": 2000000,
"records": 500,
"rules": 40,
"compositeFields": 5
}
}
Complete schemas, descriptions and cross-field validation may impose additional limits.
Proposed price and protocol definitions
{
"unit": "one successful operation call",
"proposedNominalUsd": "0.01",
"sixDecimalTokenBaseUnits": "10000",
"subscription": false,
"includesPayerWalletOrNetworkFees": false,
"liveQuoteVerified": false,
"condition": "Actual SDK challenge is authoritative only within the caller's explicit authorization; configured six-decimal token peg is an operator assertion, not a conversion guarantee."
}
Protocol definitions: x402, mpp. MPP uses Tempo charge. Paid MCP execution is unsupported. All runtime readiness is not evaluated in this build.
API path templates, not endpoints on this documentation host
{
"x402": "/v1/x402/record-constraints",
"mpp": "/v1/mpp/record-constraints"
}
Required headers
{
"Content-Type": "application/json",
"Idempotency-Key": "random 16–128 character operation identifier"
}
Actual SDK challenge amount, asset, network, recipient and wallet costs must pass independent authorization. Preserve identical key, body, protocol and credential on retries; on PAYMENT_UNCERTAIN stop and reconcile.
Execution profile and provider conditions
{
"deterministic": true,
"externalRequests": 0,
"maxExternalRequests": 0,
"resultSnapshotPersisted": false,
"fixedExampleIsIllustrativeSnapshot": false,
"requiresPayment": true,
"supportsMcpExecution": false
}
Deterministic supplied-input operation with no external requests or stored request/result bodies. Payment infrastructure retains payment metadata and hashes.
Failure handling
- HTTP 400: Malformed JSON, missing/invalid idempotency key, or payment identifier mismatch Correct the request before payment
- HTTP 402: Payment challenge or rejected payment Use official protocol SDK; inspect payment outcome before another payment
- HTTP 409: Idempotency conflict, duplicate proof, or PAYMENT_UNCERTAIN Keep original key, body, and proof; reconcile uncertainty with operator; never blindly repay
- HTTP 413: Input or generated output too large Reduce input; no payment attempted for validation failure
- HTTP 415: Unsupported media type or compression Send uncompressed application/json
- HTTP 422: Schema or service-specific semantic validation failure Correct input using returned error code; no payment attempted
- HTTP 429: Request/payment-attempt rate exceeded Wait for rate limit window; preserve existing payment identity
- HTTP 503: Payment configuration/provider/state unavailable, or live DNS preparation failed before settlement Check readiness; DNS preparation failures may retry the identical key/body/credential only; uncertainty requires reconciliation
Declared requirements
Before any paid call, refresh the live operation contract and POST the complete bounded budgeted plan to the separate API's /preflight. Unknown requirements block selection; compatible preflight is not permission to spend.