{"uid":"cap_1E7S4VjI_sQyT40nI3y_6","slug":"knowledge-base-maintenance-exact-row-deduplication-numeric-distribution-b0c0f694","name":"Knowledge Base Maintenance — Exact Row Deduplication + Numeric Distribution","description":"Knowledge base maintenance — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied knowledge base maintenance records (updated_articles, due_articles). 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-writing-16-039?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","updated_articles","due_articles"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"due_articles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"document_group":{"type":"string","default":"","maxLength":80},"updated_articles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","due_articles":1,"document_group":"group-a","updated_articles":10},{"date":"2026-10-02","row_id":"row-2","due_articles":2,"document_group":"group-b","updated_articles":20},{"date":"2026-10-03","row_id":"row-3","due_articles":3,"document_group":"group-a","updated_articles":15},{"date":"2026-10-04","row_id":"row-4","due_articles":4,"document_group":"group-b","updated_articles":30}],"maxItems":200,"minItems":1},"field":{"enum":["updated_articles","due_articles"],"type":"string","default":"updated_articles"}}},"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_UujIycZsNMKXVYrstPuk7","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 rows and produces a numeric distribution report for knowledge base maintenance records (updated_articles, due_articles) across up to 200 rows.","exampleAgentPrompt":"I have 4 rows of KB maintenance data — row-1 through row-4 with dates 2026-10-01 to 2026-10-04, document groups group-a and group-b, and updated_articles values 10, 20, 15, 30 — can you deduplicate the exact rows and give me a numeric distribution report for the updated_articles field?","exampleUseCases":[{"title":"Deduplicating article update logs","prompt":"I've got a batch of knowledge base maintenance records — about 50 rows with row_id, date, document_group, updated_articles, and due_articles fields — and I think there are some exact duplicates in there. Can you deduplicate them and show me the numeric distribution of the updated_articles values?"},{"title":"Auditing due articles across document groups","prompt":"Here are 120 KB maintenance rows covering several document groups over the past quarter. Please remove any exact duplicate rows and give me a numeric distribution breakdown for the due_articles field so I can see how workload is spread."},{"title":"Cleaning exported knowledge base tracker","prompt":"I exported our knowledge base tracker and got 80 rows with updated_articles and due_articles counts per date and document group — some rows look like duplicates. Run exact row deduplication and a numeric distribution report on the due_articles column for me."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication result identifying and removing fully identical rows from the submitted dataset, and (2) a numeric distribution report summarizing the statistical spread (e.g. min, max, mean, percentiles, frequency counts) of the selected field (updated_articles or due_articles) across the supplied rows. No external data is fetched; all analysis is performed on the submitted rows only.","failureModes":["Input array is empty or exceeds 200 rows — request rejected","Missing required fields (row_id, document_group, date, updated_articles, due_articles) on any row — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Field enum value not in ['updated_articles','due_articles'] — invalid input","All rows are duplicates leaving no unique records — deduplication returns empty set","Numeric values outside allowed range (-1e12 to 1e12) — rejected by schema validation"],"whenToPreferThis":"Choose this endpoint when you have up to 200 knowledge base maintenance records with updated_articles and due_articles fields and need both exact duplicate removal and a numeric distribution summary in a single low-cost ($0.01 USDC) call. Ideal for periodic data quality checks on KB tracking exports without needing live data access, external lookups, or predictions. Prefer over generic analytics tools when you specifically need these two bundled reports on document-group-based article tracking data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:47:45.617Z","isFirstParty":false,"canonicalSlug":"knowledge-base-maintenance-exact-row-deduplication-numeric-distribution-b0c0f694"}