Typed guarded record join
WHEN TO USE: Produce actual inner, left or full joined row pairs from two supplied tables using typed scalar JSON Pointer keys. Enforces declared cardinality over both complete inputs before matching; duplicate null-containing keys count for uniqueness even when nullKeys=never-match. Preserves provenance and order, rejects fanout overruns without partial output. No coercion, fuzzy matching, database access or semantic relationship verification.
structured · Operation ID: records-join
Choose this operation when
- Join two tables while retaining source rows and indexes
- Enrich records with a typed lookup and guard duplicate keys
- Build inner left or full joins with explicit many-to-many fanout
Outside this profile
- Fuzzy or semantic entity matching, coercing scalar keys, or proving a business relationship
- Silently combining colliding columns or truncating a join to fit a cap
- Fetching data, executing caller code, contacting agents, transmitting a payload, or changing remote state
- Verifying semantic truth, source authenticity, identity, permissions, or business relationships
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": {
"left": {
"maxItems": 500,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/$defs/__schema0"
}
}
},
"right": {
"maxItems": 500,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/$defs/__schema0"
}
}
},
"keys": {
"minItems": 1,
"maxItems": 5,
"type": "array",
"items": {
"type": "object",
"properties": {
"left": {
"type": "string",
"maxLength": 2048,
"description": "RFC 6901 string pointer, at most 20 segments. Empty pointer selects the row object, which is not a scalar join key. No URI fragments or reserved property segments."
},
"right": {
"type": "string",
"maxLength": 2048,
"description": "RFC 6901 string pointer, at most 20 segments. Empty pointer selects the row object, which is not a scalar join key. No URI fragments or reserved property segments."
}
},
"required": [
"left",
"right"
],
"additionalProperties": false
}
},
"kind": {
"type": "string",
"enum": [
"inner",
"left",
"full"
]
},
"cardinality": {
"default": "many-to-one",
"type": "string",
"enum": [
"one-to-one",
"many-to-one",
"many-to-many"
]
},
"nullKeys": {
"default": "never-match",
"type": "string",
"enum": [
"never-match",
"match"
]
},
"maxOutputRows": {
"type": "integer",
"minimum": 0,
"maximum": 2000
}
},
"required": [
"left",
"right",
"keys",
"kind",
"maxOutputRows"
],
"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": "records-join",
"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": "typed-records-join-v1"
},
"kind": {
"type": "string",
"enum": [
"inner",
"left",
"full"
]
},
"cardinality": {
"type": "string",
"enum": [
"one-to-one",
"many-to-one",
"many-to-many"
]
},
"nullKeys": {
"type": "string",
"enum": [
"never-match",
"match"
]
},
"rows": {
"maxItems": 2000,
"type": "array",
"items": {
"type": "object",
"properties": {
"leftIndex": {
"anyOf": [
{
"type": "integer",
"minimum": 0,
"maximum": 499
},
{
"type": "null"
}
]
},
"rightIndex": {
"anyOf": [
{
"type": "integer",
"minimum": 0,
"maximum": 499
},
{
"type": "null"
}
]
},
"left": {
"anyOf": [
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/properties/result/$defs/__schema0"
}
},
{
"type": "null"
}
]
},
"right": {
"anyOf": [
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/properties/result/$defs/__schema0"
}
},
{
"type": "null"
}
]
}
},
"required": [
"leftIndex",
"rightIndex",
"left",
"right"
],
"additionalProperties": false
}
},
"outputRows": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"matchedLeftRows": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"unmatchedLeftRows": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"matchedRightRows": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"unmatchedRightRows": {
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"externalRequests": {
"type": "number",
"const": 0
},
"semanticValidityVerified": {
"type": "boolean",
"const": false
}
},
"required": [
"profile",
"kind",
"cardinality",
"nullKeys",
"rows",
"outputRows",
"matchedLeftRows",
"unmatchedLeftRows",
"matchedRightRows",
"unmatchedRightRows",
"externalRequests",
"semanticValidityVerified"
],
"additionalProperties": false,
"$defs": {
"__schema0": {
"anyOf": [
{
"type": "string"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
},
{
"type": "array",
"items": {
"$ref": "#/properties/result/$defs/__schema0"
}
},
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"$ref": "#/properties/result/$defs/__schema0"
}
}
]
}
}
},
"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
{
"left": [
{
"sku": "A",
"qty": 2
},
{
"sku": "B",
"qty": 1
}
],
"right": [
{
"code": "A",
"label": "Adapters"
}
],
"keys": [
{
"left": "/sku",
"right": "/code"
}
],
"kind": "left",
"cardinality": "many-to-one",
"nullKeys": "never-match",
"maxOutputRows": 10
}
Example response
{
"operation": "records-join",
"version": "0.29.0",
"result": {
"profile": "typed-records-join-v1",
"kind": "left",
"cardinality": "many-to-one",
"nullKeys": "never-match",
"rows": [
{
"leftIndex": 0,
"rightIndex": 0,
"left": {
"sku": "A",
"qty": 2
},
"right": {
"code": "A",
"label": "Adapters"
}
},
{
"leftIndex": 1,
"rightIndex": null,
"left": {
"sku": "B",
"qty": 1
},
"right": null
}
],
"outputRows": 2,
"matchedLeftRows": 1,
"unmatchedLeftRows": 1,
"matchedRightRows": 1,
"unmatchedRightRows": 0,
"externalRequests": 0,
"semanticValidityVerified": false
},
"provenance": {
"inputSha256": "2a6e27489652f9ea391dd0820684e8a9690cbe8d4028b086ee11cdd12dc51022",
"outputSha256": "68a134752f33121788d4152199e9678ecea72b4e7e92ca50d19e0eb40fdbc57b",
"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,
"maxRowsPerSide": 500,
"maxKeyPairs": 5,
"maxPointerSegments": 20,
"maxOutputRows": 2000,
"nullUniqueness": "null-containing keys count toward uniqueness"
}
}
Complete schemas, descriptions and cross-field validation may impose additional limits.
Proposed price and protocol definitions
{
"unit": "one successful operation call",
"proposedNominalUsd": "0.005",
"sixDecimalTokenBaseUnits": "5000",
"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/records-join",
"mpp": "/v1/mpp/records-join"
}
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.