{"uid":"cap_AigyQUIp2OAgyAmoLt1c4","slug":"news-archive-completeness-string-normalisation-exact-row-deduplication-90d8e142","name":"News Archive Completeness — String Normalisation + Exact Row Deduplication","description":"News archive completeness — String normalisation + Exact row deduplication: String normalisation + 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-020?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_RpBTFVRhVt_G_pndM33Ki","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":"Normalises strings and deduplicates exact rows in news archive completeness records containing indexed_items and expected_items fields, producing 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you clean up my news archive completeness records — normalise the channel group strings and remove any exact duplicate rows? I have up to 200 rows each with a row_id, channel_group, date, indexed_items, and expected_items fields.","exampleUseCases":[{"title":"Daily news index audit cleanup","prompt":"I have a batch of 150 daily news archive records across channel groups like 'BBC_News', 'bbc news', and 'BBC news ' — can you normalise those strings and deduplicate any exact duplicate rows so my completeness report is accurate?"},{"title":"Channel group deduplication before reporting","prompt":"Before I generate our weekly news coverage report, can you run string normalisation and exact row deduplication on these 80 archive completeness rows with indexed_items and expected_items counts per date and channel_group?"},{"title":"Archive completeness data hygiene","prompt":"Our news archive pipeline sometimes produces duplicate entries and inconsistent capitalisation in channel names — can you clean up these records covering 2024-01-01 through 2024-01-31 across groups like 'Sports_EN' and 'sports en', and give me two deduplication reports?"}],"resultDescription":"Two analytical reports covering: (1) string-normalised versions of the input records with standardised channel_group and other string fields, and (2) exact row deduplication results identifying and removing fully duplicate rows from the supplied news archive completeness dataset of up to 200 rows.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, indexed_items, expected_items) cause row-level rejection","Malformed date strings not matching YYYY-MM-DD pattern are rejected","Null values in indexed_items or expected_items may be excluded from numeric analysis","Empty array input (minItems:1 violated) returns an error"],"whenToPreferThis":"Choose this endpoint when you have news archive completeness records (indexed vs expected items per channel group and date) and need both string normalisation and exact duplicate removal in a single batch call for up to 200 rows. It is purpose-built for news archive data quality workflows and provides two independent analytical reports per call at a low flat cost, with no external lookups or network calls involved.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:38.454Z","isFirstParty":false,"canonicalSlug":"news-archive-completeness-string-normalisation-exact-row-deduplication-90d8e142"}