{"uid":"cap_SWClrBPCPuGJpKKVuHMj8","slug":"data-ingestion-batches-record-quality-audit-exact-row-deduplication-a5822aa1","name":"Data Ingestion Batches — Record Quality Audit + Exact Row Deduplication + Duplicate Key Report","description":"Data ingestion batches — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied data ingestion batches records (received_rows, accepted_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-01-209?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_XxVQZz5AZi7HelHeWyzqG","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":"Runs three analytical reports on up to 200 data ingestion batch records: a record quality audit, exact row deduplication, and a duplicate key report — all from supplied data, no external lookups.","exampleAgentPrompt":"Can you run the three-in-one ingestion batch analysis — quality audit, exact row deduplication, and duplicate key report — on these records: row-1 for group-a on 2026-10-01 with 10 received and 1 accepted, row-2 for group-b on 2026-10-02 with 20 received and 2 accepted, and row-3 for group-a on 2026-10-03 with 15 received and 3 accepted?","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"I've got a batch of ingestion records from our ETL pipeline — can you run a quality audit, find any exact duplicate rows, and flag duplicate keys? Here are the rows: row-1, group-alpha, 2025-03-01, received 500, accepted 480; row-2, group-beta, 2025-03-01, received 300, accepted 295; row-3, group-alpha, 2025-03-01, received 500, accepted 480."},{"title":"Investigating high rejection rate in batches","prompt":"Something looks off in our ingestion batches — a lot of rows are being rejected. Can you audit record quality, check for exact duplicates, and produce a duplicate key report for these 5 records: row-A group-x 2025-06-10 received 1000 accepted 10, row-B group-y 2025-06-10 received 800 accepted 790, row-C group-x 2025-06-10 received 1000 accepted 10, row-D group-z 2025-06-11 received 200 accepted 0, row-E group-y 2025-06-10 received 800 accepted 790?"},{"title":"Pre-merge deduplication for warehouse load","prompt":"Before I merge these ingestion batches into the data warehouse, can you do an exact row deduplication, quality audit, and duplicate key check on my 4 records? Row-1: dataset group 'sales', date 2025-09-15, received 2000 accepted 1980. Row-2: dataset group 'sales', date 2025-09-15, received 2000 accepted 1980. Row-3: dataset group 'returns', date 2025-09-15, received 400 accepted 398. Row-4: dataset group 'returns', date 2025-09-16, received 410 accepted 405."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit highlighting anomalies or issues in the supplied rows, (2) an exact row deduplication report identifying records that are byte-for-byte identical across all fields, and (3) a duplicate key report flagging rows sharing the same key fields (such as row_id or dataset_group+date combinations). All analysis is performed locally on supplied data with no external calls.","failureModes":["Exceeding 200 rows causes a validation error","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) triggers a schema validation failure","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Values outside the allowed numeric range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Submitting an empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC not fulfilled results in 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need all three analytical reports — quality audit, exact deduplication, and duplicate key detection — on the same ingestion batch dataset in a single call, at a low fixed cost of $0.01 USDC for up to 200 rows. It is ideal for data engineering workflows where the data is already available locally and no external enrichment, live lookup, or prediction is needed. Prefer alternatives if you need only one report type, need to process more than 200 rows at once, or require real-time external data validation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T00:46:38.719Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-record-quality-audit-exact-row-deduplication-a5822aa1"}