{"slug":"api-zfinia-com-x402-v1-referential-integrity-audit-579193","title":"Check that every reference in a child dataset resolves to a parent","host":"api.zfinia.com","method":"POST","resource":"https://api.zfinia.com/x402/v1/referential-integrity-audit","category":"code","description":"Check that every reference in a child dataset resolves to a parent. Containment is one-directional, which is the difference from a reconciliation: a parent key nothing references is normal and is reported as a count, while a child key with no parent is a broken reference reported with every row carr","price_listed":0.14,"price_asked":null,"state":"no_terms","state_label":"Answers HTTP 429 without x402 payment terms","checks_7d":1,"answered_7d":0,"latency_ms_median":null,"reported_calls_30d":1,"reported_payers_30d":1,"networks":["eip155:8453"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"child":"order_id,customer_id,amount\nO-1,C-001,10.10\nO-2,C-001,20.20\nO-3,C-002,5.00\nO-4,C-999,7.50\nO-5,,3.00\n","child_key":["customer_id"],"parent":"customer_id,name,region\nC-001,Acme,ap-southeast-2\nC-002,Globex,us-east-1\nC-003,Initech,eu-west-1\nC-003,Initech Duplicate,eu-west-1\n","parent_key":["customer_id"]},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"additionalProperties":false,"properties":{"allow_empty_reference":{"type":"boolean"},"child":{"maxLength":262144,"type":"string"},"child_key":{"items":{"maxLength":256,"type":"string"},"maxItems":4,"minItems":1,"type":"array"},"delimiter":{"maxLength":1,"minLength":1,"type":"string"},"parent":{"maxLength":262144,"type":"string"},"parent_key":{"items":{"maxLength":256,"type":"string"},"maxItems":4,"minItems":1,"type":"array"}},"required":["parent","child","parent_key","child_key"],"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-10-04","reachable":true,"status":429,"valid_402":false,"asked_usdc":null,"price_match":null,"latency_ms":239,"error":null}],"description_full":"Check that every reference in a child dataset resolves to a parent. Containment is one-directional, which is the difference from a reconciliation: a parent key nothing references is normal and is reported as a count, while a child key with no parent is a broken reference reported with every row carrying it. Also catches a duplicated parent key, which makes any reference to it ambiguous.","last_updated":"2026-10-04T08:10:55.303Z","schemes":["exact"]}