{"uid":"cap_vmhUSLVuA50NUT5iwkMgf","slug":"foundry-csv-keyed-row-reconciliation-05b8ba1a","name":"Foundry CSV Keyed Row Reconciliation","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-keyed-row-reconciliation","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"after_csv":{"type":"string","maxLength":12000,"minLength":1},"before_csv":{"type":"string","maxLength":12000,"minLength":1},"key_column":{"type":"string","maxLength":100,"minLength":1},"compare_columns":{"type":"array","items":{"type":"string","maxLength":100,"minLength":1},"maxItems":25,"minItems":1}}},"responseSchema":{"type":"json","example":{"route":"csv-keyed-row-reconciliation","result":{"after_rows":2,"added_count":1,"before_rows":2,"limitations":["Synthetic example hashes."],"after_sha256":"0000000000000000000000000000000000000000000000000000000000000000","before_sha256":"0000000000000000000000000000000000000000000000000000000000000000","changed_count":1,"removed_count":1,"changed_records":[{"after_record":2,"before_record":2,"changed_columns":["stock"]}],"unchanged_count":0,"evidence_truncated":false,"added_record_numbers":[3],"removed_record_numbers":[3]},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.015","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.015/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.015","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.015","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_hdyH3J4_TuPJvrWnsGXQo","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.015","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Compares two CSV snapshots row-by-row using a key column and reports added, removed, changed, and unchanged records with SHA-256 provenance hashes.","exampleAgentPrompt":"Compare these two CSV snapshots of our product inventory — the 'before' CSV is from last Monday and the 'after' CSV is from today — using 'product_id' as the key column, and check for changes in the 'price', 'stock', and 'category' columns. Tell me which rows were added, removed, or modified.","exampleUseCases":[{"title":"Inventory change audit between exports","prompt":"I have two CSV exports of our warehouse inventory — one from the start of the week and one from today. Use 'sku' as the key column and compare the 'quantity', 'location', and 'unit_cost' columns. Show me every row that was added, removed, or changed."},{"title":"Financial ledger reconciliation","prompt":"Can you diff these two CSV versions of our accounts payable ledger using 'invoice_id' as the key? I want to know which invoices were added, which were removed, and which had their 'amount', 'due_date', or 'status' fields changed between the two snapshots."},{"title":"User roster change detection","prompt":"We export our employee list to CSV every week. Here are the before and after files — key on 'employee_id' and check for differences in 'department', 'title', and 'salary'. Flag any new hires, terminations, or role changes."}],"resultDescription":"Returns a JSON object with counts of added, removed, changed, and unchanged rows; lists of added and removed record numbers; detailed changed-record entries showing which columns changed and the before/after record positions; SHA-256 hashes of both CSVs for provenance; an observation timestamp; and a flag indicating whether evidence was truncated.","failureModes":["Missing required fields (after_csv, before_csv, key_column, compare_columns) return a validation error","CSV content exceeding 12,000 characters per field is rejected","key_column not found in one or both CSVs causes a reconciliation error","compare_columns referencing non-existent columns may produce empty diffs or errors","Malformed CSV (unquoted commas, inconsistent columns) may cause parse errors","Payment failure or insufficient USDC balance prevents the call from completing"],"whenToPreferThis":"Choose this endpoint when you need structured, key-based row-level diffing of two CSV snapshots with cryptographic provenance (SHA-256 hashes) and an auditable JSON result — especially in pay-per-request agentic workflows where you need exact evidence of what changed. Prefer it over generic CSV diff tools when provenance timestamps and source hashes matter for audit trails, or when integrating into an x402-compatible payment pipeline.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:52:47.207Z","isFirstParty":false}