{"uid":"cap_Rzy5njOmjXtXCyAf12SEk","slug":"news-archive-completeness-record-quality-audit-exact-row-deduplication-060f3b68","name":"News Archive Completeness — Record Quality Audit + Exact Row Deduplication","description":"News archive completeness — Record quality audit + Exact row deduplication: Record quality audit + Exact row deduplication for supplied news archive completeness records (indexed_items, expected_items). 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-news-23-002?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","indexed_items","expected_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"channel_group":{"type":"string","default":"","maxLength":80},"indexed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"expected_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","channel_group":"group-a","indexed_items":10,"expected_items":1},{"date":"2026-10-02","row_id":"row-2","channel_group":"group-b","indexed_items":20,"expected_items":2},{"date":"2026-10-03","row_id":"row-3","channel_group":"group-a","indexed_items":15,"expected_items":3},{"date":"2026-10-04","row_id":"row-4","channel_group":"group-b","indexed_items":30,"expected_items":4}],"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_f6RAaaS9d6fOlFKxm6UFf","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":"Audits record quality and detects exact duplicate rows in news archive completeness data (indexed_items vs expected_items) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you audit these news archive completeness records for quality issues and exact duplicates? I have up to 50 rows with fields like row_id, channel_group, date, indexed_items, and expected_items — I need both a record quality audit and a deduplication report.","exampleUseCases":[{"title":"Daily news indexing pipeline health check","prompt":"I have a batch of 120 rows from our daily news archive completeness tracker — each row has a row_id, channel_group, date, indexed_items, and expected_items. Can you run a quality audit and flag any exact duplicate rows before we load them into our reporting system?"},{"title":"Detecting duplicate rows after data ingestion","prompt":"We just ingested news archive data from multiple sources and I suspect there are duplicate records mixed in. Can you check these 80 rows for exact duplicates and also give me a record quality report on the indexed_items and expected_items fields?"},{"title":"Pre-analysis cleanup of news coverage data","prompt":"Before I hand off this news archive completeness dataset to the analytics team, I need to make sure the records are clean. Can you audit the quality and find any exact duplicate rows across these 60 entries — the data has channel_group, date, indexed_items, and expected_items columns?"}],"resultDescription":"Two independent analytical reports: (1) a record quality audit covering field completeness, value ranges, and anomalies for indexed_items and expected_items; (2) an exact row deduplication report identifying rows with identical field values across the submitted dataset. No external data is fetched — analysis is performed entirely on the submitted rows.","failureModes":["Fewer than 1 row submitted — request rejected","More than 200 rows submitted — exceeds batch limit, request rejected","Missing required fields (row_id, channel_group, date, indexed_items, expected_items) — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema validation failure","row_id exceeds 80-character limit — schema validation failure","numeric values outside allowed range (±1,000,000,000,000) — schema validation failure","Payment of 0.01 USDC not provided or declined — 402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need to validate and deduplicate news archive completeness records (indexed_items vs expected_items) in a single low-cost call. It is ideal for pre-processing pipelines where data integrity must be confirmed before downstream analysis, and when you have up to 200 rows to inspect at once. Prefer this over generic data-quality tools when your data specifically tracks news indexing completeness by channel group and date.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:38:17.674Z","isFirstParty":false,"canonicalSlug":"news-archive-completeness-record-quality-audit-exact-row-deduplication-060f3b68"}