{"uid":"cap_tnGSW27-txjVw_Mh6QxR3","slug":"data-ingestion-batches-exact-row-deduplication-keyed-dataset-comparison-4356ac89","name":"Data Ingestion Batches — Exact Row Deduplication + Keyed Dataset Comparison","description":"Data ingestion batches — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison for supplied data ingestion batches records (received_rows, accepted_rows). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-01-053?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":21},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":17},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":33}],"maxItems":200,"minItems":0}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","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.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_h5euRg8GH-5uaYtmcz_gU","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Performs exact row deduplication and keyed dataset comparison on two supplied data ingestion batch datasets (received_rows, accepted_rows) of up to 200 rows each, returning two independent analytical reports.","exampleAgentPrompt":"I have two versions of my data ingestion batch — the original and a revised one — each with up to 50 rows tagged with row_id, dataset_group, date, received_rows, and accepted_rows. Can you run exact row deduplication on the primary set and then compare both datasets by key to find what changed?","exampleUseCases":[{"title":"Deduplicating a daily ingestion pipeline","prompt":"I've got today's ingestion batch with about 80 rows — each has a row_id, dataset_group, date, received_rows, and accepted_rows. Can you run exact row deduplication on it so I can see which records are true duplicates before I load them into the warehouse?"},{"title":"Reconciling two batch snapshots for discrepancies","prompt":"I have two snapshots of my ingestion batch from this morning and this afternoon — both have the same row_ids like 'row-1' through 'row-120' with dataset_group, date, received_rows, and accepted_rows. Can you do a keyed comparison to show me exactly which rows changed between the two snapshots?"},{"title":"Auditing received vs accepted row counts across groups","prompt":"My data team produced two ingestion batch reports for group-a and group-b across October — around 60 rows each with row_id, date, received_rows, and accepted_rows. Run the deduplication and keyed dataset comparison so I can audit whether our accepted row counts are consistent with what we received."}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying duplicate records in the primary dataset, and (2) a keyed dataset comparison report highlighting row-level differences between the two supplied datasets based on row_id keys, covering received_rows and accepted_rows fields. No external lookups or predictions are made — all analysis is performed locally on the supplied data.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema validation failure","row_id empty or exceeds 80 characters — field validation error","Numeric values out of allowed range (±1,000,000,000,000) — schema rejection","Empty rows array (minItems: 1 not met) — validation error","Payment of 0.01 USDC not received — 402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need to locally analyze data ingestion batch records for exact duplicates and cross-dataset key-based differences without any external data lookups or live system access. It is ideal for ETL pipeline audits, data quality checks, and reconciliation tasks where you have two structured batch datasets with row_id, dataset_group, date, received_rows, and accepted_rows fields. Prefer it over general-purpose analytics when you need both a deduplication report and a keyed comparison report in a single low-cost call ($0.01 USDC) on up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:27.660Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-exact-row-deduplication-keyed-dataset-comparison-4356ac89"}