{"uid":"cap_jWLOzFzjdo3wwDp0ws-Ee","slug":"forum-topic-activity-string-normalisation-duplicate-key-report-1b0aa506","name":"Forum Topic Activity — String Normalisation + Duplicate Key Report","description":"Forum topic activity — String normalisation + Duplicate key report: String normalisation + Duplicate key report for supplied forum topic activity records (thread_count, reply_count). 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-22-021?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","thread_count","reply_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"reply_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"thread_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"channel_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","reply_count":1,"thread_count":10,"channel_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","reply_count":2,"thread_count":20,"channel_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","reply_count":3,"thread_count":15,"channel_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","reply_count":4,"thread_count":30,"channel_group":"group-b"}],"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_eLbvcY9jGRXwJqJd3BELl","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 string fields and identifies duplicate keys in forum topic activity records (thread_count, reply_count) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"I have up to 200 rows of forum topic activity data with fields like row_id, channel_group, date, thread_count, and reply_count — can you run string normalisation and a duplicate key check on them and give me both reports?","exampleUseCases":[{"title":"Forum export data quality audit","prompt":"I just exported our forum engagement data for October — here are 150 rows with row_id, channel_group, date, thread_count, and reply_count. Can you normalise the string fields and flag any duplicate row IDs for me?"},{"title":"Multi-channel forum deduplication check","prompt":"We aggregate forum activity from several channel groups and I'm worried there are duplicate entries. Can you take these 80 forum activity rows and run a string normalisation plus duplicate key report so I can clean up before importing?"},{"title":"Weekly forum data pipeline validation","prompt":"Before we load this week's forum thread and reply counts into our database, can you check these 200 rows for string inconsistencies and duplicate keys across row_id and channel_group?"}],"resultDescription":"Two independent reports: (1) a string normalisation report showing cleaned/standardised values for string fields (row_id, channel_group, date), and (2) a duplicate key report identifying rows sharing the same key fields — all computed locally without external lookups, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, channel_group, date, thread_count, reply_count) — validation error","Malformed date format (must match YYYY-MM-DD pattern) — schema validation failure","Empty rows array — minimum 1 item required","Numeric values outside allowed range (±1,000,000,000,000) — schema rejection","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have forum topic activity data (thread counts, reply counts by channel group and date) that needs both string field standardisation and duplicate key detection in a single low-cost call. It is ideal for pre-ingestion data quality checks on forum exports of up to 200 rows where no live lookups, predictions, or external actions are needed. Prefer it over generic data cleaning tools when you specifically need these two report types bundled at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:50:19.203Z","isFirstParty":false,"canonicalSlug":"forum-topic-activity-string-normalisation-duplicate-key-report-1b0aa506"}