{"uid":"cap_rldKjaNkVN1ZroiFOYhHE","slug":"forum-topic-activity-string-normalisation-and-numeric-row-ordering-0832cd5b","name":"Forum Topic Activity String Normalisation and Numeric Row Ordering","description":"Forum topic activity — String normalisation + Numeric row ordering: String normalisation + Numeric row ordering 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-025?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},"field":{"enum":["thread_count","reply_count"],"type":"string","default":"thread_count"}}},"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_EazHubhtjOHl_1hRUMq0j","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 orders rows numerically for forum topic activity records (thread_count, reply_count) across up to 200 rows, returning two analytical reports.","exampleAgentPrompt":"Can you normalize the channel group strings and rank all these forum rows by thread_count? I have 4 rows: row-1 on 2026-10-01 with channel group-a, thread_count 10, reply_count 1; row-2 on 2026-10-02 with group-b, thread_count 20, reply_count 2; row-3 on 2026-10-03 with group-a, thread_count 15, reply_count 3; row-4 on 2026-10-04 with group-b, thread_count 30, reply_count 4.","exampleUseCases":[{"title":"Ranking forum channels by thread volume","prompt":"I have a week's worth of forum data across two channel groups — can you normalize the channel names and order all 8 rows by thread_count so I can see which channels are most active? Here are the rows: row-1 2026-10-01 group-a thread_count 10 reply_count 5, row-2 2026-10-02 group-b thread_count 25 reply_count 12, row-3 2026-10-03 group-a thread_count 8 reply_count 3, row-4 2026-10-04 group-b thread_count 40 reply_count 20, row-5 2026-10-05 group-a thread_count 15 reply_count 7, row-6 2026-10-06 group-b thread_count 30 reply_count 15, row-7 2026-10-07 group-a thread_count 22 reply_count 9, row-8 2026-10-08 group-b thread_count 18 reply_count 6."},{"title":"Cleaning messy forum reply data for reporting","prompt":"My forum export has inconsistent channel group labels and I need the reply_count column sorted numerically — can you run a string normalisation and numeric row ordering report on these 5 rows? row-1 2026-09-01 Group_A thread_count 5 reply_count 100, row-2 2026-09-02 group-a thread_count 8 reply_count 45, row-3 2026-09-03 GROUP-B thread_count 12 reply_count 200, row-4 2026-09-04 group-b thread_count 3 reply_count 80, row-5 2026-09-05 Group_A thread_count 7 reply_count 150. Use reply_count as the field."},{"title":"Monthly forum engagement summary by channel","prompt":"I want to understand which forum channel groups drove the most discussions last month — please normalize the group names and rank these 6 rows by thread_count: row-1 2026-11-01 channel-alpha thread_count 50 reply_count 300, row-2 2026-11-05 channel-beta thread_count 20 reply_count 90, row-3 2026-11-10 channel-alpha thread_count 75 reply_count 420, row-4 2026-11-15 channel-beta thread_count 10 reply_count 55, row-5 2026-11-20 channel-alpha thread_count 60 reply_count 380, row-6 2026-11-25 channel-beta thread_count 35 reply_count 140."}],"resultDescription":"Returns two analytical reports: (1) a string normalisation report standardising the channel_group field values across submitted rows, and (2) a numeric row ordering report ranking rows by the selected metric (thread_count or reply_count). Both reports are computed locally from the supplied data, with no external lookups or predictions.","failureModes":["More than 200 rows submitted — 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) — validation error","Invalid field enum value (must be thread_count or reply_count) — rejection","Payment failure via x402 protocol — request not processed"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of forum activity data (thread counts, reply counts per channel group and date) and need both string normalisation and numeric ordering in a single $0.01 call. It is best suited for lightweight, offline analytical preprocessing of forum engagement data where no live data lookup, external enrichment, or predictive modelling is required. Prefer alternatives if you need correlation analysis, deduplication, or more than two report types in one call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:38:21.489Z","isFirstParty":false,"canonicalSlug":"forum-topic-activity-string-normalisation-and-numeric-row-ordering-0832cd5b"}