{"uid":"cap_akJImnnvWuzLsdV_UI-H1","slug":"foundry-csv-partition-consistency-validator-ab6ae9d2","name":"Foundry CSV Partition Consistency Validator","description":"Pay-per-request evidence and data tools: CSV validation and reconciliation, DNS/email configuration evidence, and bounded official weather, earthquake, vehicle, company and study records. Exact USDC prices, explicit JSON contracts and source provenance. No mailbox, ownership, medical or safety guarantees.","url":"https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-partition-consistency","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"key_column":{"type":"string","maxLength":100,"minLength":1},"partitions":{"type":"array","items":{"type":"string","maxLength":12000,"minLength":1},"maxItems":5,"minItems":2}}},"responseSchema":{"type":"json","example":{"route":"csv-partition-consistency","result":{"status":"PASS","conflicts":[],"total_rows":2,"limitations":["Synthetic example hashes."],"input_sha256":["0000000000000000000000000000000000000000000000000000000000000000","0000000000000000000000000000000000000000000000000000000000000000"],"blank_key_count":0,"compatible_headers":true,"evidence_truncated":false,"duplicate_key_count":0},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.008","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.008/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.008","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.008","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_r-arM43BHoDOBduEWUWXW","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.008","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Validates and reconciles multiple CSV partitions by checking for key conflicts, duplicate keys, blank keys, and header compatibility across all partitions.","exampleAgentPrompt":"Check these two CSV partitions for consistency — use 'user_id' as the key column — and tell me if there are any duplicate keys, blank keys, header mismatches, or conflicts between the two chunks: [partition 1 CSV text] and [partition 2 CSV text].","exampleUseCases":[{"title":"Merge validation before ETL pipeline","prompt":"I have three CSV chunks from our data export and I need to merge them by 'order_id' — can you check whether they have any conflicting rows, duplicate keys, or mismatched headers before I combine them?"},{"title":"Audit split data for duplicate records","prompt":"We split our customer table into two CSV files by region and I'm worried there might be rows duplicated across both. Can you validate them against each other using 'customer_id' as the key and flag any duplicates or blanks?"},{"title":"Verify CSV shards from parallel workers","prompt":"Our pipeline produced four CSV partitions in parallel and I need to confirm they're consistent — please check all four using 'transaction_id' as the key and report any conflicts or header incompatibilities."}],"resultDescription":"A JSON object containing: overall status (PASS or FAIL), a list of detected conflicts between partitions, total row count across all partitions, count of duplicate keys, count of blank keys, a boolean indicating whether headers are compatible across all partitions, SHA-256 hashes for each input partition, and a flag indicating whether evidence was truncated due to size limits.","failureModes":["Missing required field 'key_column' or 'partitions' returns a validation error","Fewer than 2 or more than 5 partitions causes a schema rejection","Any single partition string exceeding 12,000 characters is rejected","Malformed CSV content may result in unexpected parse errors or incomplete analysis","If evidence is very large, 'evidence_truncated' will be true and results may be partial","Network or worker errors may return HTTP 5xx with no result body","Insufficient USDC balance causes payment failure before processing"],"whenToPreferThis":"Choose this endpoint when you need a deterministic, pay-per-request audit of whether 2–5 CSV text partitions are mutually consistent on a shared key column — especially when you need SHA-256 provenance hashes, explicit conflict lists, and header compatibility checks in a single structured JSON response. Prefer this over manual scripts when you need verifiable evidence of data integrity for compliance or pipeline validation purposes.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:54:18.963Z","isFirstParty":false}