{"uid":"cap_Gyt4njvrnULM36lwJ_sA1","slug":"forum-topic-activity-record-quality-audit-string-normalisation-keyed-cbd276ff","name":"Forum Topic Activity — Record Quality Audit + String Normalisation + Keyed Dataset Comparison","description":"Forum topic activity — Record quality audit + String normalisation + Keyed dataset comparison: Record quality audit + String normalisation + Keyed dataset comparison for supplied forum topic activity records (thread_count, reply_count). 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-news-22-207?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},"other":{"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":21,"channel_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","reply_count":3,"thread_count":17,"channel_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","reply_count":4,"thread_count":33,"channel_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_a63hQpMbfeod9Z6gd7NZ2","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 local analytical reports on forum topic activity data (thread_count, reply_count): a record quality audit, string normalisation, and keyed dataset comparison across two supplied datasets of up to 200 rows each.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and keyed comparison on these two sets of forum activity data — each has up to 50 rows with fields row_id, channel_group, date, thread_count, and reply_count — and give me the three reports?","exampleUseCases":[{"title":"Weekly forum data quality check","prompt":"I have this week's forum activity data with thread counts and reply counts across channel groups — can you audit it for record quality issues, normalise any inconsistent string fields, and compare it against last week's snapshot to flag any differences? Each dataset has about 80 rows with row_id, channel_group, date, thread_count, and reply_count."},{"title":"Channel group engagement discrepancy audit","prompt":"We've got two exports of our forum topic activity — one from our CRM and one from our analytics platform — each up to 150 rows covering row_id, channel_group, date, thread_count, and reply_count. Can you run a keyed comparison plus a quality audit and string normalisation report on both to find where they diverge?"},{"title":"Pre-migration forum data validation","prompt":"Before we migrate our forum data to the new system, please audit these 200 rows of thread and reply count records for quality issues, normalise the channel_group strings, and compare the source dataset against our target dataset using row_id as the key — I need all three reports."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit highlighting issues such as nulls, out-of-range values, or malformed fields in the supplied rows; (2) a string normalisation report showing transformations applied to string fields like channel_group; and (3) a keyed dataset comparison report identifying added, removed, or changed rows between the two supplied datasets, matched by row_id.","failureModes":["More than 200 rows supplied — request rejected or truncated","Missing required fields (row_id, channel_group, date, thread_count, reply_count) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema rejection","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — rejection","Empty rows array (minItems: 1 violated) — error response","Payment not included or insufficient — HTTP 402 returned"],"whenToPreferThis":"Choose this endpoint when you need all three analytical operations — record quality audit, string normalisation, and keyed dataset comparison — performed together on forum topic activity data (thread_count, reply_count) in a single low-cost call. It is ideal for offline/local analysis with no external lookups or live data dependencies. Not suitable if you need predictions, external data enrichment, or more than 200 rows per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:32.844Z","isFirstParty":false,"canonicalSlug":"forum-topic-activity-record-quality-audit-string-normalisation-keyed-cbd276ff"}