{"uid":"cap_R5V49_fLbefVhjX5yPz8d","slug":"tableproof-verify-data-import-by-exact-ids-35e19c36","name":"TableProof – Verify Data Import by Exact IDs","description":"Compare original and imported CSV exports by exact IDs. Find missing, added and changed records with a free bounded preview.","url":"https://tableproof-data.mitchellwhite.chatgpt.site/v1/audit?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","required":["csv"],"properties":{"csv":{"type":"string"},"columns":{"type":"object","description":"Column names map to rules: required (boolean), unique (boolean), type (string, integer, number, boolean, iso-date)."}}},"responseSchema":{"type":"object"},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.05","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"registry","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.05/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.05","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm__HSW6iRDuK0XzdHekyy6l","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.05","costPer":"request","priority":0,"asset":null,"unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Compares original and imported CSV exports by exact IDs to identify missing, added, and changed records, with optional column-level validation rules.","exampleAgentPrompt":"Can you audit my CSV import and tell me if any records went missing, got added unexpectedly, or had their data changed? Here's the CSV export from after the import — please check that the 'id' column is unique and required, and that the 'amount' column is a number.","exampleUseCases":[{"title":"Post-migration data integrity check","prompt":"I just migrated our customer database and exported the result as a CSV. Can you compare it against the original and tell me if any customer records are missing, have been added, or had their fields changed? The 'customer_id' should be unique and required."},{"title":"ETL pipeline output verification","prompt":"Our ETL pipeline ran last night and I have the output CSV. Please audit it to make sure no rows were dropped or altered — flag anything missing, new, or changed. The 'transaction_id' column must be unique and the 'amount' column must be a number."},{"title":"CSV import QA before going live","prompt":"Before I push this import to production, can you verify the CSV export and check that all the original records are still there, nothing extra was added, and nothing was changed? Make sure the 'order_id' is required and unique."}],"resultDescription":"Returns a bounded audit preview showing which records are missing (present in original but not in import), added (new records not in original), and changed (records whose field values differ), identified by exact IDs. May include column-level validation findings based on supplied rules.","failureModes":["Missing required 'csv' field returns a validation error","Malformed or unparseable CSV content causes a parse error","Very large CSV files may exceed preview bounds and return only a partial result","Column rule mismatches (e.g., non-numeric value in a number column) may surface as validation errors","IDs not present in both datasets may cause incorrect diff attribution if ID column is ambiguous"],"whenToPreferThis":"Choose this endpoint when you need to compare two states of tabular data (original vs. imported) and identify exact record-level discrepancies by ID. It is purpose-built for post-import/post-migration auditing of CSV files, offering structured diff output with optional per-column validation rules. Prefer it over generic diff tools when your data is CSV-structured and you need ID-anchored change detection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:37:54.964Z","isFirstParty":false,"canonicalSlug":"tableproof-verify-data-import-by-exact-ids-35e19c36"}