{"uid":"cap_32DDYAyS1GsbYFvYR1eWh","slug":"tableproof-csv-data-import-diff-by-exact-ids-fbca18aa","name":"TableProof – CSV Data Import Diff 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/diff?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","required":["keys","after","before"],"properties":{"keys":{"type":"array"},"after":{"type":"string"},"before":{"type":"string"}}},"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_xKgt_vPtmCXAFrb7acTrF","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 two CSV exports (before and after a data import) by exact IDs to find missing, added, and changed records.","exampleAgentPrompt":"I just migrated our customer database and want to make sure nothing got lost — can you compare these two CSV exports using 'customer_id' as the key and show me any missing, added, or changed records?","exampleUseCases":[{"title":"Validate post-migration record integrity","prompt":"I finished importing our product catalog into the new platform — can you diff the original CSV and the exported-back CSV using 'product_id' as the key so I can see if any products are missing or were changed?"},{"title":"Audit ETL pipeline output for data loss","prompt":"Our ETL job ran last night and I want to verify nothing dropped — compare the source snapshot CSV and the destination export CSV using 'order_id' as the key and flag any missing or added rows."},{"title":"Detect accidental data changes after bulk edit","prompt":"I ran a bulk update script on our contacts table and want to make sure only the right fields changed — can you compare the before and after CSV exports keyed on 'contact_id' and show me which records were modified?"}],"resultDescription":"Returns a bounded diff report identifying records that are missing (present in 'before' but absent in 'after'), added (present in 'after' but absent in 'before'), and changed (same key but differing field values), with a free preview of the results.","failureModes":["Missing required field (keys, before, or after) returns a validation error","Malformed or non-CSV string input may result in a parse error or empty diff","Key column names that don't exist in the CSV headers may yield no matches or an error","Very large CSVs may be truncated or only partially diffed due to bounded preview limits","Mismatched column schemas between before/after CSVs may produce unexpected change records"],"whenToPreferThis":"Choose this endpoint when you need a quick, exact-ID-based comparison between two CSV snapshots — particularly after a data migration, ETL pipeline run, or bulk import — to verify completeness and accuracy. It is ideal when you already have both before and after exports as CSV strings and need a structured diff rather than a full database reconciliation tool.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T18:36:58.776Z","isFirstParty":false,"canonicalSlug":"tableproof-csv-data-import-diff-by-exact-ids-fbca18aa"}