{"uid":"cap_T-ly_CsyE4awCwBTrMHJ0","slug":"data-ingestion-batches-exact-row-deduplication-duplicate-key-report-8593d210","name":"Data Ingestion Batches — Exact Row Deduplication + Duplicate Key Report","description":"Data ingestion batches — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report 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-038?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}}},"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_Yc4y27Bz8WdjSe25UxY2K","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":"Deduplicates exact rows and generates a duplicate key report for up to 200 data ingestion batch records containing received_rows and accepted_rows fields.","exampleAgentPrompt":"I have a batch of data ingestion records across dataset groups with received_rows and accepted_rows counts — can you run exact row deduplication and generate a duplicate key report on these up to 200 rows?","exampleUseCases":[{"title":"ETL pipeline duplicate audit","prompt":"We ran our nightly ETL and I suspect some ingestion batch records got duplicated — can you take these rows with row_id, dataset_group, date, received_rows, and accepted_rows and give me an exact row deduplication result plus a duplicate key report so I can see what repeated?"},{"title":"Data quality check before warehouse load","prompt":"Before we load these ingestion batch records into the warehouse, can you deduplicate them exactly and tell me which keys appear more than once? Here are about 150 rows each with a row_id, dataset_group, date, received_rows, and accepted_rows."},{"title":"Multi-group ingestion reconciliation","prompt":"I have ingestion batch data from several dataset groups — group-a and group-b — for the past few weeks, and I want to know if any rows are exact duplicates and which keys are repeated. Can you run both the deduplication and the duplicate key report on this set of records?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully identical records, and (2) a duplicate key report listing which row keys (row_id, dataset_group, date combinations) appear more than once — all computed locally without any external lookup or live data access.","failureModes":["More than 200 rows submitted — request rejected due to maxItems limit","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","received_rows or accepted_rows values outside ±1,000,000,000,000 range rejected","Empty rows array (minItems: 1 not satisfied) returns an error","row_id exceeding 80 characters triggers maxLength validation failure"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication AND a duplicate key report in a single call for data ingestion batch records specifically structured with received_rows and accepted_rows metrics. It is ideal for data engineering pipelines, ETL quality checks, and batch reconciliation workflows where you need two complementary deduplication reports at once for up to 200 rows at minimal cost. Prefer alternatives if you only need a single report type, need live data lookup, or are working with non-ingestion data schemas.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T00:56:13.967Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-exact-row-deduplication-duplicate-key-report-8593d210"}